So I have been trying to do this thing for a while but I was not able to. I usually would search more etc but I have a very tight deadline plus I am not very familiar with VBA (only c++, java)
I have a excel file (Workbook) with multiple of sheets that all contain data (Source). I have another excel file that contains again multiple worksheets that contain ONLY the headings (Target).
What I want to do is a code that goes to the target workbook and takes the heading, then goes to the source workbook and loops through all the worksheets until it finds this heading and then copies the data into the target workbook.
Keep in mind all headings in the source file are at the same row in all the worksheets. Explanation
I hope its clear. Your help is greatly appreciated. If this is explained somewhere in detail I am sorry I didnt find it and you can provide me a link.
Thanks in advance!
Link for small example to make it clear is provided!
I have a excel file (Workbook) with multiple of sheets that all contain data (Source). I have another excel file that contains again multiple worksheets that contain ONLY the headings (Target).
What I want to do is a code that goes to the target workbook and takes the heading, then goes to the source workbook and loops through all the worksheets until it finds this heading and then copies the data into the target workbook.
Keep in mind all headings in the source file are at the same row in all the worksheets. Explanation
I hope its clear. Your help is greatly appreciated. If this is explained somewhere in detail I am sorry I didnt find it and you can provide me a link.
Thanks in advance!
Link for small example to make it clear is provided!
