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
|