Excel help

Dragon6250 · 2019-07-29 12:35:53

Hi All. I need some help with an Excel issue. I have a macro to create a monthly invoice from the master data sheet. However I need to repeat the macro for each row in the master data sheet, stopping at the last row. The number of rows vary month to month. Appreciate any help.

29-07-2019 12:35PM

#1

Dragon6250

Registered Users, Registered Users 2 Posts: 14 ✭

Join Date: April 2011

Posts: 8

Hi All. I need some help with an Excel issue.
I have a macro to create a monthly invoice from the master data sheet. However I need to repeat the macro for each row in the master data sheet, stopping at the last row. The number of rows vary month to month.

Appreciate any help.

0

Comments

#2 29-07-2019 12:48PM

antix80

Registered Users, Registered Users 2 Posts: 2,417 ✭✭✭

Join Date: September 2016

Posts: 2337

Counting the number of non-blank cells in the column headed "invoice number" should work.
The excel function is COUNTA(A:A) and then you'll have to do a for loop (for x = 1 to numberOfNonBlankCells)

0