Forum Discussion
Help with Worksheets
Hi Everyone I have a workbook, with multiple sheet in it, I have arrange the workbook with different categories, plus the master sheets. I would like to know if using the master sheet you can feed the other sheets automatically by only selecting one mode (explanation let say in the master sheet I have a category named as Expenses for Mode T, but I want to Expenses For Mode T in a separate worksheets) How can I do that? and that worksheet feeds on only new Information when I add new info to the master.
1 Reply
- Hello,
The explanation wasn't clear enough. However, you can use formula and functions to perform calculations across sheets (from Source data sheet to the master sheet).
You can use Pivot Table also.
