Hi, a workmate pointed me in the direction of this site so i hope someone on here will be kind enough to help as i don't use excel all that often!!
I have many spreadsheet files from which i need to copy and paste just some data from each onto one new big spreadsheet. because the data i need is in the same place on each file i thought i'd just record my actions of copying and pasting the first lot of data as a macro then simply use this macro for every file thereafter....you can probably already guess my question....
the macro only works for the file i first used unless i go in and change the file name in every line manually, i'm pretty sure there's an easier way. how can i set up a macro to not care what the file name is and just work between the two open spreadsheet windows?
many thanks in advance....
I have many spreadsheet files from which i need to copy and paste just some data from each onto one new big spreadsheet. because the data i need is in the same place on each file i thought i'd just record my actions of copying and pasting the first lot of data as a macro then simply use this macro for every file thereafter....you can probably already guess my question....
the macro only works for the file i first used unless i go in and change the file name in every line manually, i'm pretty sure there's an easier way. how can i set up a macro to not care what the file name is and just work between the two open spreadsheet windows?
many thanks in advance....