| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Totals
Can any one help..after getting totals I copy and paste it in a new Excel
sheet as a CVS, which is fine but when I try to use that new sheet for a VLOOKUP it will not recognize any of the data and give me #n/a. Is there any suggestions as to why or what I can do? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying Totals
A CVS file is just text and cannot have any formating or formulas and can
only be one sheet. You need to save the file using Save As on File menu to a XLS or equivalent excel file. "helpplease" wrote: Can any one help..after getting totals I copy and paste it in a new Excel sheet as a CVS, which is fine but when I try to use that new sheet for a VLOOKUP it will not recognize any of the data and give me #n/a. Is there any suggestions as to why or what I can do? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying information returned by using Sub Totals | Excel Discussion (Misc queries) | |||
| Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
| Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Setting up and Configuration of Excel | |||
| Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
| Copying Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
