I was wondering if it is possible to automatically add a row of information to one tab after it has been added to a different tab?
For instance i have been copying and pasting a single row from multiple spreadsheets into a tab on a master one. The next tab is linked to the first, with information pulled out from each row (the same data each time).
Other people will be updating the first tab with further rows and i want the second tab to recognise that data has been added to the first tab and update itself accordingly. (So i don't have to go into the tab, hightlight a row and use autofill each time).
Bookmarks