I have 2 columns A1,B1 A1 is a name B1 is a number . But not every B column will have a number only if A column bought something that month.
Example A and B columns
Frodo 10
Gandalf 5
Sam
Merry 5
I need help with a macro that will copy only the row with a number in B column to a seperate sheet or place on the spread sheet.
any help would be great.
Example A and B columns
Frodo 10
Gandalf 5
Sam
Merry 5
I need help with a macro that will copy only the row with a number in B column to a seperate sheet or place on the spread sheet.
any help would be great.