Hi
I have 3 Sheets in each sheet Different range in Sheet Basic Range is N2:Last row of data
In Sheet Enh Range is N2:T last row of data
In Sheet OT Range is N2:V last row of data
all 3 sheets data pull in Expeceted Result sheet particular format above sheet wise range is any value then copy paste that range data in Expeceted Result from column M & Column A need to pull Number of that row & AA column pull File Name & In Column C Effective Date that is which is current month that 1st day that date i want in this column
In Column D Element Name This is Sheet Wise for Basic "BASIC NR" , for Enh sheet "ENHANCEMENT NR NP" , for OT sheet "OVERTIME NR NP" this name need to input like this
In attach file show how data look like in Expeceted Result sheet
Please tell me how to do this
I have 3 Sheets in each sheet Different range in Sheet Basic Range is N2:Last row of data
In Sheet Enh Range is N2:T last row of data
In Sheet OT Range is N2:V last row of data
all 3 sheets data pull in Expeceted Result sheet particular format above sheet wise range is any value then copy paste that range data in Expeceted Result from column M & Column A need to pull Number of that row & AA column pull File Name & In Column C Effective Date that is which is current month that 1st day that date i want in this column
In Column D Element Name This is Sheet Wise for Basic "BASIC NR" , for Enh sheet "ENHANCEMENT NR NP" , for OT sheet "OVERTIME NR NP" this name need to input like this
In attach file show how data look like in Expeceted Result sheet
Please tell me how to do this