Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing cells to new worksheet
I have a database with contact data that I can export as a .csv. I hav a spreadsheet that I am currently copy & pasting the contents into new excel file to run reports. I would like a macro that I can run tha will eliminate the need to open the .csv and copy it over to the ne .xls file. I have tried two different suggestions I found in other posts bu neither work. Please help! Helpful info: 1. the .csv file is call contact.csv and the data is on sheet 1 (calle "contact") 2. the data in the .csv if is A1:BA10000 (although this could grow s if there is a way to make it search until there is no more data tha would be better) 3. the .xls file is called stats.xls and the data needs to be importe to sheet 1 ( called "Upload Files") I think this covers i -- jermsalerm ----------------------------------------------------------------------- jermsalerms's Profile: http://www.excelforum.com/member.php...fo&userid=3016 View this thread: http://www.excelforum.com/showthread.php?threadid=51701 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Changes Text Cells to Number Cells When Importing XML | Excel Discussion (Misc queries) | |||
Problem when importing one worksheet into another one | Excel Discussion (Misc queries) | |||
Importing data from one worksheet into another | Excel Discussion (Misc queries) | |||
importing data from Excel worksheet to another worksheet | Excel Worksheet Functions | |||
importing worksheet via code | Excel Programming |