I am looking to create a summary table in one spreadsheet, by copying information from all spreadsheets in a file.
So I am looking to open all spreadsheets (the titles are random and therefore I can't specify) from a folder g:\Iain, and then copy particular cells into my summary table.
E.g open spreadsheet in G:\Iain, copy cell B3 and paste into cell A1 of summary table spreadsheet in folder F:\Table.
I want to go through all spreadsheets in G:\Iain and copy the same cells, but paste below the previous results in results table spreadsheet (e.g. the second spreadsheet opened, I want to copy cell B3 as before, but paste into cell A2 in my table spreadsheet and so on.
I am pretty new to VBA so please bear with me.
I think I may be able to use loops but am unsure as to the "unknown" element of the titles and pasting into next line.
Any help would be appreciated!
haddy27