I have a daily report where the data is saved into a template. This template is then linked to a master sheet which collates the data daily through the month. So the data for the same template would be used for 1St, 2nd etc. When I Enter the data I can get to update the master sheet with iferror(vlookup) command. Obv then when I remove that data and replace it with following day from 2nd it disappears so the master sheet will have the data for the 2nd on the first and second of the month. Is there a way when the data is entered on to master sheet it holds the values for each day so I can delete the data on templates without any issue on master sheets.
All sheets are on the same work book. Or there may be better options than using vlookup. TIA
All sheets are on the same work book. Or there may be better options than using vlookup. TIA