D
Dave
Hi, I got the code below to calculate sales tax on invoices. For example in
cell C7 I enter the net invoice amount of $100. Then I run the macro and it
enters in
cell D7 $6.75, and in E7 it totals it to $106.75.
I don't know anything about coding, so don't assume anything with me. What
I want
the macro to do is that once it calculates the sales tax and total invoice
amount in Row 7, is to go to the next row down cell C8. From here I then
enter the net invoice amount and I want to repeat the macro again.
I can't figure this out. Thanks for any input.
Macro3 Macro
' Sales Tax
'
' Keyboard Shortcut: Ctrl+f
'
Range("D7").Select
Range("D7") = "=0.0675*RC[-1]"
Range("E7").Select
Range("E7") = "=RC[-2]+RC[-1]"
End Sub
cell C7 I enter the net invoice amount of $100. Then I run the macro and it
enters in
cell D7 $6.75, and in E7 it totals it to $106.75.
I don't know anything about coding, so don't assume anything with me. What
I want
the macro to do is that once it calculates the sales tax and total invoice
amount in Row 7, is to go to the next row down cell C8. From here I then
enter the net invoice amount and I want to repeat the macro again.
I can't figure this out. Thanks for any input.
Macro3 Macro
' Sales Tax
'
' Keyboard Shortcut: Ctrl+f
'
Range("D7").Select
Range("D7") = "=0.0675*RC[-1]"
Range("E7").Select
Range("E7") = "=RC[-2]+RC[-1]"
End Sub