I am working in Excel 2000 and have multiple worksheets I need to summarize onto one page. The worksheets look like:
Date Trade Amount Used Usage code Balance
1/1/04 $200 $200
1/31/04 $50 EU 150
2/4/04 $25 SE 125
3/3/04 $20 BD 105
3/20/04 $10 EU 95
The column Usage code is a drop down box. This is like a form that my end users will be updating each month.
I would like to summarize the Amount Used and Usage Code columns like the following:
Categories Amount Used
EU $60
SE $25
BD $20
Subtotal $105
Total $95
I have tried the following three methods:
1) Pivot Table - This failed because it wouldn't recognize the drop down values
2) VLOOKUP - This failed because it woulded allow a 3d reference
3) If, Then, Else - This also didn't work.
I think I need to use VB but I really am not skilled enough to know where to start. I really would appreciate any help!
Thank you!
Date Trade Amount Used Usage code Balance
1/1/04 $200 $200
1/31/04 $50 EU 150
2/4/04 $25 SE 125
3/3/04 $20 BD 105
3/20/04 $10 EU 95
The column Usage code is a drop down box. This is like a form that my end users will be updating each month.
I would like to summarize the Amount Used and Usage Code columns like the following:
Categories Amount Used
EU $60
SE $25
BD $20
Subtotal $105
Total $95
I have tried the following three methods:
1) Pivot Table - This failed because it wouldn't recognize the drop down values
2) VLOOKUP - This failed because it woulded allow a 3d reference
3) If, Then, Else - This also didn't work.
I think I need to use VB but I really am not skilled enough to know where to start. I really would appreciate any help!
Thank you!