Hi All,
I am urgently trying to find out how you would set up a automated update from 6 tabs within a spreadsheet to one summary tab. The data has uniques refs for each line but the data is dates and not calculations. the 6 workstream tabs are updated daily and then I have to cut and past all the info over to the summary sheet on a daily basis.
I have tried special paste but this does not update if an new line is added out of the original chosen rows.
Has anyone got any ideas? ? ?
Pulling hair out as i speak ,, Amanda 🙁
