Hello All,
I have one spreadsheet that contains all my data by FY, Group, EOC, and $ Amount. I want to populate another spreadsheet showing the data in table format (not using pivot table because I want to be able to give $ minimum criteria) by changing the Group.
Group Lab
EOC FY03 Bud FY04 Bud FY05 Bud
7203
In this example, I want only the Lab values for each time period to appear in the currect columns for EOC 7203.
FY Group EOC CLOSE
FY03 Bud Lab 6301 100000
FY04 Bud OR 6301 97500
FY03 Bud HR 6405 95000
FY04 Bud Lab 7203 92500
FY03 Bud OR 6556 90000
FY04 Bud HR 6556 87500
FY03 Bud Lab 7203 85000
FY04 Bud OR 7203 82500
FY03 Bud HR 7423 80000
FY04 Bud Lab 7423 77500
FY05 Bud OR 7423 75000
FY03 Bud HR 6607 72500
FY04 Bud Lab 6607 70000
FY05 Bud OR 6607 67500
FY03 Act HR 7120 65000
FY03 Bud Lab 7120 62500
FY04 Act OR 7120 60000
FY04 Bud HR 7120 57500
FY05 Act Lab 7120 55000
FY05 Bud OR 7120 52500
Any thoughts??
Thanks!!
I have one spreadsheet that contains all my data by FY, Group, EOC, and $ Amount. I want to populate another spreadsheet showing the data in table format (not using pivot table because I want to be able to give $ minimum criteria) by changing the Group.
Group Lab
EOC FY03 Bud FY04 Bud FY05 Bud
7203
In this example, I want only the Lab values for each time period to appear in the currect columns for EOC 7203.
FY Group EOC CLOSE
FY03 Bud Lab 6301 100000
FY04 Bud OR 6301 97500
FY03 Bud HR 6405 95000
FY04 Bud Lab 7203 92500
FY03 Bud OR 6556 90000
FY04 Bud HR 6556 87500
FY03 Bud Lab 7203 85000
FY04 Bud OR 7203 82500
FY03 Bud HR 7423 80000
FY04 Bud Lab 7423 77500
FY05 Bud OR 7423 75000
FY03 Bud HR 6607 72500
FY04 Bud Lab 6607 70000
FY05 Bud OR 6607 67500
FY03 Act HR 7120 65000
FY03 Bud Lab 7120 62500
FY04 Act OR 7120 60000
FY04 Bud HR 7120 57500
FY05 Act Lab 7120 55000
FY05 Bud OR 7120 52500
Any thoughts??
Thanks!!