Hey my first time on here and I'm kinda new to excel so go easy on me lol
I'm basically trying to figure how to copy a row from sheet1 to the next available row in sheet2 and sheet3 if 2 criterias are met.
Ok so for sheet1 to sheet 2
I have a column name for "date paid" in row "F3" to "F33"
And
A column name for "date collected" in row "H3" to "H33"
So when "date paid" cell is "empty" and the "date collected" cell is "filled", I want that row to be automatically copied to the next available rows in spread sheet 2.
2nd part
Pretty much want to do the same from spread sheet 1 to spread 3
But use column "overweight fee" in row "L3" to "L33"
When these cells are filled in, I want it to be automatically copied to the next available rows to sheet 3.
I'm basically trying to figure how to copy a row from sheet1 to the next available row in sheet2 and sheet3 if 2 criterias are met.
Ok so for sheet1 to sheet 2
I have a column name for "date paid" in row "F3" to "F33"
And
A column name for "date collected" in row "H3" to "H33"
So when "date paid" cell is "empty" and the "date collected" cell is "filled", I want that row to be automatically copied to the next available rows in spread sheet 2.
2nd part
Pretty much want to do the same from spread sheet 1 to spread 3
But use column "overweight fee" in row "L3" to "L33"
When these cells are filled in, I want it to be automatically copied to the next available rows to sheet 3.