Adding Text with numbers and running totals

Hello all...
Long time lurker, 1st time poster. I have gained a lot of knowledge from this site. I have been recently shoved into an office scenario at work while healing from surgery... I give credit to ALL office workers everywhere who have to stare at a screen all day! Anyway, here's my question... or questions...

On the attachment I have included (couldn't paste a screen shot for some reason) I need to do the following:

Starting B3 (it is blank) and going down in column I need to add the "job number" ie (111111, 111112 etc) with "total" added to it and made bold. As such (111111 Total in B3 111112 Total in b5 etc) for the next 1000 entries.

With that, in columns N,O and P (on the same row as 111111 Total, 111112 Total etc) I need to do a subtotal column. People will be adding rows to jobs so it needs to keep a running total. I know how to add them individually but is there a way to add them for all 1000 entries automatically?

I appreciate any and all help anyone can give me!

Thank you very much!

Zaphod

Welcome to the forum!

As a long-time lurker, you will already know that images are of no use to us, so I shall look forward to your uploading the workbook. Then I'll take a look for you.

OK - I'm not really clear on what you are after here. Could you please mock up a few rows manually, showing realistic data and including extra rows that have been added. Highlight the cells where you require the automation.

Not really clear on what you trying to do. Do you need to replicate what you have in Column B? If yes, then try this:
Enter manually 111111 in cell B2
Enter formula in cell B4 and drag formula down

Formula:

Please Login or Register  to view this content.

You could probably do this with a Pivot Table, or with using the Subtotal function on the data tab

Just re-do the ST function again

(thanks for the feedback, too)

Here is another one
1. Enter in B2 111111
2. Enter in B3 =B2&" Total"
3. Enter formula in B4 and drag formula down

Formula:

Please Login or Register  to view this content.

Please see attached file.

If you mean inserting a row into an existing Job, it should calc automatically

If you mean a new job, maybe consider recording a macro that will "redo" the ST for you, then add a button on the side for the user to click?

OK I dont think you are going to be able to combine AlKey's suggestion and mine

If you remove the rows you manually added for the ST, then use the ST function - then add a new row, say, directly above the "TOTAL" row and add the data, then "redo" the ST, it will be included in the total
If you already have more than 1 entry (like 13) then add the row between existing rows, and it will be included automatically

Please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Happy to help, thanks for the kind words and the feedback

I did nothing much in this thread, so a special thanks for the rep - very kind!