slash32487
Board Regular
- Joined
- Jun 8, 2009
- Messages
- 85
i have 3 generated reports that i quickly break down to customers and dollars via a pivot table and then i like to use it outside the pivot so i copy and paste it and work from there.
these reports generate sales and open orders. there is a master report that uses the data from the sales and open orders that i manually put into the master sheet. the manual input is due to a few things.
1. system name of customer needs to change
2. customers that get consolidated
>customers that all go into one customer
>customers that have more than one billing and get combined
is there a way to use the master report to grab info off the sheets with a formula
these reports generate sales and open orders. there is a master report that uses the data from the sales and open orders that i manually put into the master sheet. the manual input is due to a few things.
1. system name of customer needs to change
2. customers that get consolidated
>customers that all go into one customer
>customers that have more than one billing and get combined
is there a way to use the master report to grab info off the sheets with a formula
