Subtotaling - adding new info

Hey guys,

I've got a complex problem. I am not sure how to explain but will give it a whirl. See my youtube video and read below: http://youtu.be/mSbk6vmwzfE

I have a spreadsheet (master) in which the Purchase Order Number and Project ID Number information come from another sheet (data) and are dumped into my master spreadsheet via copying the applicable columns from the data spreadsheet and pasting the columns into my tracker via Paste Special -->Paste Link.

I also have my master spreadsheet set to subtotal the pertinent information.

So, I pull a new data report daily as new purchase orders are created and the info is needed. I save it over my old data spreadsheet and then open my Master to refresh the links and recalculate everything. But when I do this, the new information does not get captured into my subtotaled lines.

Right now I have to remove subtotals and enter them back in. This is a pain in the rear as I have about 13K rows of info (20 columns). Another reason why it's a pain in the rear is because I am using the subtotaled lines to put additional info like total lines in that row and ETC.

See Attached. Book3.xlsx

This is a very VERY basic description of what I'm talking about. I'm kinda scared to actually share my spreadsheet do to proprietary reasons but am open to suggestions.

On this sheet, columns A and B are acquired from my data spreadsheet via the method described above. The Zero's represent empty fields from data spreadsheet that could be populated once new Purchase orders are generated.

See Row 2. This is an example of a new Purchase order being generated, but not showing up with the others with the same project ID in the subtotal.

FYI - the subtotals were put in place to use Column C as the row to sort and column E as the row to total. Again, I've made this very generic.

Help is greatly appreciated. Let me know if you have questions or complaints.

How are you putting the subtotals in ?

maybe create another report for the totals (remove the subtotals )since i think you are adding the values based on the Project ID.

Extract all unique Project ID then do a sumif/s for the other computations need (cost, and others) this will be your subtotals for all Product ID.

ok. i will seek help with others regarding this one.

In my office playing videos are restricted by company firewall.

So I am unable to see what you want and how...

Can you please just show your data for 10 rows with expected result so that I can able to give my suggestions

See attachment

Try this to sum E and H:

In J2:

Please Login or Register  to view this content.

Stay in I2 , apply below formula to condition formating criteria:

=$I1<>""

Choose format border / Top

Applies to whole range