Copying Totals

H

helpplease

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?
 
J

joel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup of sub totals 2
Copy a formula using Vlookup 2
Excel vba code to match duplicates 4
How copy automatically from one sheet to another. 4
How do I get an #N/A field to return 0? 2
Cannot copy worksheet to another file 2
copy subtotal value only - also can be lookup from other worksheet 1
Macro to copy value in field and insert it into filter 2

Top