Our account structure is ####-xxx-1, where #### is the account number, XXX is the department and 1 is allocation factor. I have multiple dynamically genarated excel sheets and I wonder if I can have a formula on the summary sheet that can add the same account for multiple departments at once.
Date
Votes
1 comment
-
Cat I don't really get what you want to achieve.
You have sheets like DPT01, DPT02, DPT03
and in each sheet e.g.
Account001-DPT01-1
Account002-DPT01-1
Account002-DPT01-1
Account003-DPT01-1And in the summary sheet you want what?
Account001-DPT01-1
Account001-DPT02-1
Account001-DPT03-1
Account002-DPT01-1
Account002-DPT02-1
Account002-DPT03-1
or
Account001
Account002
Please sign in to leave a comment.