Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding rows from sheets to one sheet
Okay, I am a newbie at Excel code, so please be patient with me. I am
looking at a way of taking all xls files in one folder, copying the second row from each sheet and pasting it into a template that's already opened. I won't know the name of the files in the folder, just that they will end in xls and that only the second row will need to be copied (I think it will go up to the 230th column) into the template, starting in the second row and continuing on down the sheet until all are copied into this one file. I am pretty sure this will involve a looping process, but I am not sure how to programmatically accomplish this. TIA, Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked sheets, blank cells and adding new rows | Excel Worksheet Functions | |||
adding sheets based upon a template sheet | Excel Worksheet Functions | |||
Adding rows to tables in 2 different sheets | Excel Discussion (Misc queries) | |||
SIMULTANEOUSLY adding rows in two sheets | Excel Programming | |||
How to control sheet number when adding and deleting sheets? | Excel Programming |