JackChang
01-31-2020, 03:14 PM
All-
Is there a way to link my PO/invoice totals from a newly created tab to my summary sheet? without adding each formula manually?
The idea was, there is a summary tab containing the totals of the PO/invoice amounts for each project. Behind that tab, there is a template tab, which the sales reps are supposed to create a copy of for each new project. But, each time a user creates a copy of the template, they would have to add the formulas to the summary sheet. Is there anyway this can be formula driven without doing anything fancy? Or is my only option is to create a number of tabs in advance and link them up first? I'm asking because we could have 30 active projects at a time, and that's a lot of manual work.
Any suggestions appreciated, thank you!
Is there a way to link my PO/invoice totals from a newly created tab to my summary sheet? without adding each formula manually?
The idea was, there is a summary tab containing the totals of the PO/invoice amounts for each project. Behind that tab, there is a template tab, which the sales reps are supposed to create a copy of for each new project. But, each time a user creates a copy of the template, they would have to add the formulas to the summary sheet. Is there anyway this can be formula driven without doing anything fancy? Or is my only option is to create a number of tabs in advance and link them up first? I'm asking because we could have 30 active projects at a time, and that's a lot of manual work.
Any suggestions appreciated, thank you!