Andy_Leslie
New Member
I am new to this programming VBA and am trying to get the data from multiple sheets into single sheet.
I have downloaded and am trying to run the code but it faults on the highlighted instruction.
Attached is the basic excel file that i'm trying to collate. I need B12 to M24 only along with the date from A4.
This is a report for my job that I am trying to refine to make it user friendly while at the same time learning how to code VBA. I have already gone from manual writing and then inputting it to this but am still working on improving it further.
I have downloaded and am trying to run the code but it faults on the highlighted instruction.
Attached is the basic excel file that i'm trying to collate. I need B12 to M24 only along with the date from A4.
This is a report for my job that I am trying to refine to make it user friendly while at the same time learning how to code VBA. I have already gone from manual writing and then inputting it to this but am still working on improving it further.