Hi Team,
I am trying to create a VB sheet for data consolidation from multiple sheets into one summary sheet. And I am through with it.
The help needed is to copy & paste sheet name to range of cells in same sheet. Ex: If Sheetname is Sheet1 then it has to be copied on the used data in column C from C5 till the data exists of all the active sheets except the consolidated sheet in the workbook.
Enclosed the trial file which I was working but not successful.
Please help me out.
Regard,
Ignesh.Trial_cur.xls
Bookmarks