J
joey
I am using excel 2007.
I'd like to be able to make X number of sheets and create a cumulative log of a certain filtered range on a summary sheet.
For example:
I have multiple sheets of identical setup, but different transactions, let's say the range I want to summarize is as follows:
Transaction A
Name Amount Paid
Joe $100 True
Tom $200 False
Jim $50 False
(new sheet)
Transaction B...
Joe $100 True
Tom $10 False
Jim $0 True
....
Now I want a summary sheet that has the transaction name listed as such:
Trans. Name Amount Paid
A Joe $100 True
A Tom ...
A Jim
B Joe
B Tom
B Jim
I've tried pivot table, but can not seem to collect data from multiple sheets.
Any suggestions?
I'd like to be able to make X number of sheets and create a cumulative log of a certain filtered range on a summary sheet.
For example:
I have multiple sheets of identical setup, but different transactions, let's say the range I want to summarize is as follows:
Transaction A
Name Amount Paid
Joe $100 True
Tom $200 False
Jim $50 False
(new sheet)
Transaction B...
Joe $100 True
Tom $10 False
Jim $0 True
....
Now I want a summary sheet that has the transaction name listed as such:
Trans. Name Amount Paid
A Joe $100 True
A Tom ...
A Jim
B Joe
B Tom
B Jim
I've tried pivot table, but can not seem to collect data from multiple sheets.
Any suggestions?