Problem writing a loop

[themindseye]

Good afternoon,

Given these populated columns: Invoice Number, Invoice Item $ amount, Invoice item counter (increments the number of items on an invoice until the invoice number changes; at which point it resets to 1), I need to populate the columns titled Invoice Total $ Amount and Invoice Total # of items, I can't have these as a subtotal I need to have these values next to each individual record. In other words, both the Invoice Total $ Amount and Invoice Total # of Items will have the same values until the data in the Invoice Number column changes.
I am fairly certain that I cannot use a formula for this as there is no stable pattern associated with the change in Invoice Number so I must write a loop. Please help me write a loop for this.

Thanks for reading and for your assistance, have a wonderful day!

[stnkynts]

Please submit an example workbook with a worksheet showing your data and a worksheet showing how you would like to appear.

[SIMBAtheCAT]

Message edited - wrong subject - mistake.

[Leith Ross]

Hello themindseye,

Welcome to the Forum!

Excel has templates available for Invoicing. I would take a look and see what might fit your needs. It could save you a lot of time.

Here is how to upload your workbook...

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

[themindseye]

Please submit an example workbook with a worksheet showing your data and a worksheet showing how you would like to appear.

Hi, sorry for the delay in uploading this, and thanks for your help! Please look at the center worksheet, partial title is Refund Ins Detail, as an example, column F contains the total amount for that invoice number in each row populated by said invoice number and column E contains the total invoice amount in the same format. The source for column E is Column S.

I had to delete the other worksheets before upload because the file was too large.

Thanks again for your help!!

[themindseye]

Please someone help me with this topic.

[Leith Ross]

Hello themindseye,

After looking at the sample workbook, it appears the columns Invoice Total $ Amount and Invoice Total # of items need to be added to the worksheet.

You mention...

In other words, both the Invoice Total $ Amount and Invoice Total # of Items will have the same values until the data in the Invoice Number column changes.

However, there is no data currently in the Invoice Number column. The only sequential numbers appear in NUMBER and VOUCHER NUMBER(15) columns. Did you mean Vouchers and not Invoices?

As I understand the post, the totals will be repeated for each item listed in the invoice. Is that correct?

[themindseye]

Yes I did mean the voucher numbers, sorry for the confusion. And Yes to your second question as well. Thanks.

[themindseye]

If anyone can, please help with this thread. Thanks!!!