![]() |
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? |
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? |
All times are GMT +1. The time now is 03:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com