Hi There,
I am using a spreadsheet with lots of tabs on it. I have a main tab, then 10 different tabs for machine numbers. The main tab gets updated daily with machine issues. I want to be able to update the relevant machine tab, (as in Machine 1), with the text in that machines cell on the main tab, but KEEP the data that is already on the machine tab, which is a rolling history. Any ideas?
Thanks in advance
I am using a spreadsheet with lots of tabs on it. I have a main tab, then 10 different tabs for machine numbers. The main tab gets updated daily with machine issues. I want to be able to update the relevant machine tab, (as in Machine 1), with the text in that machines cell on the main tab, but KEEP the data that is already on the machine tab, which is a rolling history. Any ideas?
Thanks in advance