Welcome
I want a way that enables me to copy the data of 4 closed excel sheets to one sheet
3 columns C.D.F & lastrow )..file names TTC1 _TTC2_ TTC3 _TTC4 Copied into an excel sheet data same range C.D.F (C18)
And column G
The name of the sheet from which the data was fetched is shown along the column
I want a way that enables me to copy the data of 4 closed excel sheets to one sheet
3 columns C.D.F & lastrow )..file names TTC1 _TTC2_ TTC3 _TTC4 Copied into an excel sheet data same range C.D.F (C18)
And column G
The name of the sheet from which the data was fetched is shown along the column