Hello,
So, I know how to link one worksheet to a main worksheet so that when I type a new row of info in the second worksheet, the first one changes, too.
How can I get an existing workbook to do this when there are multiple worksheets? We want the main worksheet to update automatically with a new row of information no matter which sub sheet we enter that new info on.
Another way of putting it: We want to update info on sub sheets without having to update info on the main sheet again, manually.
I have done research. The Cntrl function to group two tabs is messy since I have multiple tabs. I tried linking multiple sheets but can only link the main sheet and one sub sheet (in either direction) two. Ex: =mainsheet!A1 or =secondsheet!A1.
Any info is appreciated!
So, I know how to link one worksheet to a main worksheet so that when I type a new row of info in the second worksheet, the first one changes, too.
How can I get an existing workbook to do this when there are multiple worksheets? We want the main worksheet to update automatically with a new row of information no matter which sub sheet we enter that new info on.
Another way of putting it: We want to update info on sub sheets without having to update info on the main sheet again, manually.
I have done research. The Cntrl function to group two tabs is messy since I have multiple tabs. I tried linking multiple sheets but can only link the main sheet and one sub sheet (in either direction) two. Ex: =mainsheet!A1 or =secondsheet!A1.
Any info is appreciated!