Hello I hope someone could help me.
Is there any way of getting info from specific cells in many files using VBA to be brought back into one file?
All my files begin with OTDA and the information I need is in about a hundred files.
I was hoping to be able to use a VBA macro to get the information from the third tab named "Deficiencies List", and the cells I need are B1, B2, B3, G1, G2, G3, G4 and J1
All the headings are in the same place and use the same name.
Bookmarks