Data Copying/Report

[lott42]

I have an Excel 2003 spreadsheet with tab A that has several rows of contracts with various data. What I am trying to do is have the data on the contract row copied to tab B if it exceeds a dollar amount let say 10,000. Further I would like contracts under 10,000 totaled and copied to tab B. Finally I would like tab B to create a summary total line after the last contract line. tab B is basically a "report" for the tab A data. I have no idea how to get tab b going but I attached my sheet. Thank you!

For example tab A:

Contract Billing Cost Profit
10,000 9,000 5,000 4,000
15,000 7,000 2,500 4,500
2,000 1,000 500 500
800 400 150 250

tab B would generate

Contract Billing Cost Profit
10,000 9,000 5,000 4,000
15,000 7,000 2,500 4,500
2,800 1,400 650 750 <-single line to sum contracts under threshold
-----------------------------------
27,800 17,400 8,150 9,250 <-total row added after all applicable data copied (can't have a fixed position since the number of contracts will vary)


====================

[oeldere]

wit an helpcolum.

after that a formula to sum the values < 10.000

after that a filter on the helpvolumn

see the aattached file

[lott42]

wit an helpcolum.

after that a formula to sum the values < 10.000

after that a filter on the helpvolumn

see the aattached file

That is awesome. Thank you so much. Is it possible to maintain the raw data in tab A and have tab B pull the figures over into your format? Also is it possible to have excel detect the final row of data and automatically add a total to all the data to look something like this:

tab B would generate

Contract Billing Cost Profit
10,000 9,000 5,000 4,000
15,000 7,000 2,500 4,500
2,800 1,400 650 750
-----------------------------------
27,800 17,400 8,150 9,250 <-total row added automatically after all applicable data copied (can't have a fixed position since the number of contracts will vary)

[oeldere]

I would solve that, with the formula subtotal.

See the attached file.

[lott42]

I would solve that, with the formula subtotal.

See the attached file.

Excellent - thank you so much. I am going to study this.

[oeldere]

Glad I could help. Thanks for the reply.

If the question is solved, will you mark your question as solved?

If you have (other) questions, on this item, just ask.