Great site! I searched the site and found some very helpfull answers but none that specifically addressed my issue.
Sheet 1
A B C
Unit Vendor Amount
Unit A XYZ $10
Unit B QFR $50
Unit C SOB $20
Unit A QVS $30
Unit A GSA $70
Sheet 1 is the straight forward logsheet for all purchases for all units.
I want to copy the data for Unit A to Sheet 2 like this (each unit will have seperate sheet):
Sheet 2 (Unit A)
A B
Vendor Amount
1 XYZ $10
2 QVS $30
3 GSA $70
I know how to make it total the cost from sheet one for individual units, but not how to list each cost. Let me know if you need any other info.
Thanks,
Randy
Sheet 1
A B C
Unit Vendor Amount
Unit A XYZ $10
Unit B QFR $50
Unit C SOB $20
Unit A QVS $30
Unit A GSA $70
Sheet 1 is the straight forward logsheet for all purchases for all units.
I want to copy the data for Unit A to Sheet 2 like this (each unit will have seperate sheet):
Sheet 2 (Unit A)
A B
Vendor Amount
1 XYZ $10
2 QVS $30
3 GSA $70
I know how to make it total the cost from sheet one for individual units, but not how to list each cost. Let me know if you need any other info.
Thanks,
Randy
