I have problems copying data (from notepad, values are in scientific notation) into Excel 2010 worksheet. This problem only occurs with one of my laptops. I also tried this on my partner's laptop and no problem at all.
My new laptop (which I would like to use in the lab) has Windows 7 professional installed on it. I bought my laptop in Austria/Germany, so I changed the language from German to English. I then installed Microsoft Office 2010 on my laptop (which I am also using on my main laptop- without any issues). I have changed my default language to English UK.
The issue is as follows: Here is a small sample of the data from notepad
I select & copy the data from the notepad (also tried notepad++) and paste it into the Excel 2010 worksheet. This is what I get in Excel:
3.33E+02 1.51E+02 0.00E+00 0.00E+00 4.97E+04 3.85E+02 6.24E+05 1.81E+08
When I use another spreadsheet package (MagicPlot Student version), there are no problems. I have also installed Notepad++ and experience the same issue. So somehow Excel is increasing the value by 5 orders of magnitude. When I copy the values from another Excel sheet into a new Excel sheet, there are no problems. I have re-installed the Microsoft Office suite several times and the problem is still there. I can't re-install Windows 7 as I don't have the installation discs.
I am trying to copy data from an excel sheet and I want to paste it into note pad and save it on c drive. Is there a way to write a macro to do that task? Basically copy the data from excel, then open notepad and paste it there, save the notepad in txt extension on the hard drive.
I'm having problem in copying the data from 2 notepad files into a single excelsheet, i have the below macro which creates two seperate excel sheets. i want to put the data from summary1 to tab1 and summary2 to Tab2....
I have extracted a lot of data (from a webpage), onto Sheet 1 of my Excel 2010. The results I have obtained of this data I have extracted might occupy cells A1 to F1.
I want to keep doing this over and over, copying and pasting data from a webpage onto Sheet 1, then obtaining various results and adding those results under cells A1 to F1, which would of course be A2 to F2.
Is there any way these results can be transferred to say Sheet2, but of course occupying a new line each time so that at the end of the day, I have a list of results.
Of course I could just copy and paste them to say Sheet2, under each other, just wondering if there was some tricky way.
I have two workbooks I am using. Essentially I am copying values out of one workbook, opening a second workbook, manipulating data and pasting it. Everything is working great but one issue! The first workbook has named ranges in it that I don't want in the second workbook (just values). I don't want them because when I try this operation the second time it asks if I want to use the same name or choose a different name. For some reason it is still copying over all the named ranges (all 343 of them!). Is there a way to not allow it to do that or simply just delete the names before I close the second workbook?
I need something that will take data from columns in one Spreadsheet and put in difference cells in a row. I know this could be done with recording a macro but the number of column will never be constant.
Below I attached examples of the Spreadsheet
Financials SpreadSheet Need to have the data in column B to F put their respective cells in row in the Master Spreadsheet So we would have 5 rows.
MS Office Professional Plus 2010 Excel 2010, 32bit
When making a copy of a sheet within the same workbook, I receive several messages "A formula or sheet you want to move or copy contains the name . . ."
How do I identify and remove these names? How do I prevent new ones from being generated in the future?
I used the button in Excel 2010 to record a macro that allows me to format a workbook font and stuff because i do that many times a day for several workbooks. However I want to be able to just push a button and have all open workbooks run the macro I recorded.
I am able to make a button- thats easy, but how do I get it to run for ANY workbook? My problem is that apparently it only runs the workbook that is named a certain way. should i post the code here?
I am trying to insert a blank row into a table (created using the table function in Excel 2010) without the copying the formulas. Every time I insert a row the the formula is copied.
I have a workbook containing two worksheets of staff training records.
The first work sheet contains a list of names and the dates they completed various training courses. I have used some simple date based formulas and conditional formatting to colour-code their name depending on whether their earliest retraining due date has passed, is coming up in the next few weeks, or is a long way off. The data is set out alphabetically, one person per row of data.
The second sheet contains the same list of names, but each person's data is split across two consecutive rows. The cells in column A which contain the staff names are merged in pairs so that the name heads both rows of data.
I want the colour coding of the merged name cells in sheet 2 to automatically copy the colour coding applied to the single name cell in sheet 1, but don't know how.
Im trying to copy multiple workbooks and just save it into only one worksheet. I have 2000 diffrent workbooks with the diffrent amount of rows, The ammount of cells is the same and it dosent change.
im working on a excel 2010
This is what i got for the moment..
Sub LoopThroughDirectory() Dim MyFile As String[code].....
I have one Worksheet Short Course - PB's Which contains all swimmer information and searches through all previous swims and reports back the swimmers current Personal best times (PB)
I am creating a work sheet to calculate percentage increases over a set date period. I have managed the calculations but can not get the autofill to function as I was hoping.
In my short course sheet 1 Row = a Swimmer and there details
In my new sheet, I have 3 rows for the same swimmer
Row 1= Swimmer and PB's before a set date Row 2 = Swimmer and PB's After set date and upto Todays date Row 3 = Percentage calculation of difference between the two rows to enable track performance increase
I have all of this working and in place and want to copy the formula's down now to cover all swimmers in the club.
When I copy the 3 lines down, Autofill adds 3 to the row reference for the first line and I just want it to add 1.
In my spreadsheet, a series of macros calls an external program/application three times.
Each time the program finishes, it (and not Excel, as I formerly thought) opens a resource (*.res) file in Notepad, which of course goes into the taskbar. Since I need to run the spreadsheet seven or eight times in a row, the taskbar can get cluttered quickly.
The program opens three different instances of the same filename: iroutine.res.
Is there a way to get Excel to close these Notepad files (if it's simpler to do, it can kill all instances of Notepad) when it finishes running its routines?
I have a notepad file that contains data. We need to convert the notepad file into excel and then segregate the data after conversion. Segregation point would be the point where in we can find keyword “Summary”. We need to create a macro that finds the occurrence of summary keyword. Then from the beginning till that summary point cut the entire data and paste in other worksheet. Name the worksheet as “Receivables” or “Payables” or “Fee Payable” depending what type of data that summary contains.
After creating different worksheets we need to format the worksheet in specific format. For example: I have attached the “Recon1” XL file attached. Under Recon1 – “RECEIVABLES 1” contains the as is data converted from notepad. Later we need to modify the same data using macro as specified in “RECEIVABLES 2” and then as per the format available in “RECEIVABLES 3”.
I want to know if it is possible to launch a blank notepad from an existing excel spreadsheet and then type relevant "history notes" into notepad and save.
I am creating a manual spreadsheet for the company I am working for which is being used for Maintenance Planning / Scheduling and creating of work orders. Once the work order has been raised and the job has been completed it then needs to be closed out on the spreadsheet and any relevant notes entered in. I am hoping to be able to have a link that opens notepad by the click of a button within the spreadsheet and it allows the user to record any notes against that work order and save. These notes can then viewed by future users.
Tips & Toes Nail Salon 9430 W 191st Mokena Illinois 60448 (708) 478-7420
[Code] ......
I need the above data to be replaced (TEXT File) in the below BLUE highlighted areas
TEXT FILE
Business Name Address 1 City, State Zip < website details will be placed> Business Name Address 1 City, State Zip Phone < website details will be placed> < website details will be placed> Business Name < website details will be placed> City < website details will be placed>
The final output should be creation of 10 TEXT (.txt) files as per the record count in CSV file in the above Text Format.
I have a simple reporting sheet where the data for orders place is in one sheet and on the other sheet is an imput box for 'date' and it filters through and presents a table of data and two graphs for the date chosen.
I give a daily report (contents of this sheet) but I also need to leave this sheet available for anyone to open and change to another date.
I want to copy the repor sheet into a new one and email but I want the graphs to remain, not go blank when anyone changes the original sheet.
I have a colmun of data that needs to be exported to notepad. I managed to make the routine works with the following codes:
[Code]....
However, there's some improvement that I need:
1) I want to refer my file name from here
[Code] .........
How to embed it?
One thing to note, when i ran the code, the txt file was saved as HS instead of KL AUTHS. I tried with different names and apparently it will capture maximum two characters.
2) Based on the code, it saves to my default saving location. I would like to save the txt file in the same directory as my excel file.
I need to do is move a list of data in an excel worksheet to Notepad. The data is 16 numbers long, but the Notepad needs to be left justified to 19 characters. I can't figure out a way to move spaces over to notepad.
Copying data that is in one coloumn in an unsorted order to another file where I have the values in a specific order I want. There I want it sorted in a new row each time I click a button in the first file.
I have a script that does this in a new column each time. I need it in a new row in a table to keep the graphs auto updating without having to use a macro in the end file. Current VBA that copies it to a new column instead of a new row in the table (modified to remove file names).
How the current VBA works. It refreshes the file it is in to update the data from SQL, then opens the other file, copies it over using sumif compared to the first coloumn in the file. Adds the current date, copies everything it added and replaces it with values so the formula isn't kept once it saves and closes the file. It then saves the start file and stops.
I created a slick little excel sheet with the data coming in automatically via Access query. It has been working fine for months. Now all of the sudden there are a bunch of cells with missing data. The weird part is it's not as if whole columns are missing data, more like 90% missing. When I go to Access and run the query all cells are populated as the should be. There have been no changes to the query at all during this time.
Pivot Chart. I would like to set up something to where a user can click on an individual value on a pivot chart (currently a line chart set up with 4 data series) and somehow display some underlying data. I have a lot of information stored in a data worksheet that I can't display all at once, but if a user sees a questionable data point, he/she can click and learn more about it from source data, or even a new query of the data worksheet.
I have a question about using conditional formatting in excel (2010); I made a table with the following columns:
"Supplier Name" "Supplier Lead Time" "Internal Lead Time" "Total Lead Time". I made two different scenarios to show different supplier lead times and different internal lead times, and used the minimum function in the "Total Lead Time" column to find the smallest total lead time to select the best supplier.
The last thing I would want to do with this set of data, is plug in a formula that would somehow indicate which supplier corresponds to the shortest total lead time (which supplier has the smallest supplier lead time). I'd like to be able to use a formula that enters the name of the supplier in a designated cell, which I could indicate as the "Preferred Supplier" cell. If this is not possible perhaps there is a way to highlight the supplier's name with conditional formatting?
I am working on Excel 2010. I want to find a way to link data from one spreadsheet to another one and whenever I update the first spreadsheet, the second one will be automatically updated?
