Hello,
I have a data in a sheet name "Table" columns from A:I with rows from 1 to 500.
In row 1 from A:I are title names (A1=Owner, B=Account, C=Account Name, D=Amount, E=Type, F=End Date, G=Close Dat, H=posted, I=Paid/Unpaid.
I need to build a Macro to loop through different names in column A and based on criteria in column I "Unpaid"
copy all rows in the same sheet starting from row 520.
I looked at different examples of VBAs and could not find a working example.
I have a data in a sheet name "Table" columns from A:I with rows from 1 to 500.
In row 1 from A:I are title names (A1=Owner, B=Account, C=Account Name, D=Amount, E=Type, F=End Date, G=Close Dat, H=posted, I=Paid/Unpaid.
I need to build a Macro to loop through different names in column A and based on criteria in column I "Unpaid"
copy all rows in the same sheet starting from row 520.
I looked at different examples of VBAs and could not find a working example.