Hi everyone
Im new and Im looking for a help.
This is my problem:
I've got 3 files: a.xlsx, b.xlsx, c.xlsx. Inside each file I've got 12 different worksheets. For each file they got same name, for example:
file a.xlsx got: sheet1,sheet2,sheet3....sheet12.
file b.xlsx got: sheet1,sheet2,sheet3....sheet12.
file c.xlsx got: sheet1,sheet2,sheet3....sheet12.
I need to run macro inside file summary.xlsx which will load specified data(C3,D111) from each sheet and paste it into same name sheet in summary.xlsx file. So lets say sheet5 has a table and I need to copy 2 columns from it, from all sheet5 from all 3 files, and paste it next to each other into sheet5 in file summary. And I need to do the same with each sheet.
It does not have to be automated. I was also thinking maybe putting 3 buttons in file summary which will let choose user the files path.
Just looking for something that can help me avoid all that manual copy/paste job which is time taking.
So far I found a code which let me make a button, press it, select file, copy two columns from that file and paste it in active worksheet. So to do my job i would have to make it 12 times x 3.
Anybody can help me?