When a value is inputted to 'Total Invoice Amount', the tax owed on that invoice number is calculated and outputted onto the 'Total:' cell. I have a list of invoices here, is there a way to put all of those values into 'Total Invoice Amount' one at a time and record the value for each invoice number? Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to log / record output from a list of values?
- Thread starter rec1032
- Start date
When a value is inputted to 'Total Invoice Amount', the tax owed on that invoice number is calculated and outputted onto the 'Total:' cell. I have a list of invoices here, is there a way to put all of those values into 'Total Invoice Amount' one at a time and record the value for each invoice number? Thanks.
Excel Facts
Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
nope. might be time to learn though.
Upvote
0
rpaulson
Well-known Member
- Joined
- Oct 4, 2007
- Messages
- 1,378
try this on a copy of your file.
you will need to adjust the ranges as needed.
hth,
ROss
you will need to adjust the ranges as needed.
VBA Code:
Sub do_it()
For r = 7 To 17 i assume your invoice numbers are in Range(O7:O17)
[C2] = Cells(r, "O") 'copy the current invoice number to cell C2
Cells(r, "R") = [M24]' copy the tax amount (c24) to a new column: R for each invoice.
Next r
End Subhth,
ROss
Upvote
0
much appreciated, this will help me learn VBA too. Thanks!
Upvote
0
