Hi,
I currently have a number of sheets containing data.
Each sheet contains a cell with the following string "XXXX - followed by a number" the XXXX are always in the cell.
The cell is not always in the same location for each sheet e.g. A1 or B5.
Is it possible to have a VBA loop through all sheets to recognise the 4 X's and paste the cell into a master sheet? Similar to ctrl f and ctrl c ctrl v but automated.
Thanks,
S
I currently have a number of sheets containing data.
Each sheet contains a cell with the following string "XXXX - followed by a number" the XXXX are always in the cell.
The cell is not always in the same location for each sheet e.g. A1 or B5.
Is it possible to have a VBA loop through all sheets to recognise the 4 X's and paste the cell into a master sheet? Similar to ctrl f and ctrl c ctrl v but automated.
Thanks,
S