Automatically Copy rows to different sheets

[Rurkz]

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.

 

[Fluff]

i have an expense sheet that some how replaces the letters of the columns to the names only when you scroll down pass them,

That sounds as though the data is in a structured table, & is normal behaviour.

 

[Rurkz]

That sounds as though the data is in a structured table, & is normal behaviour.

I guess lol, I got this spreadsheet online, was trying to figure out it on my own, but oh well

 

[Rurkz]

hey so i found out who ever created this excel file, they modified it using a table that allows the Letter columns to fade to the header names when scrolling down instead of using the freeze pane function.


I have another question, i found information to sort rows by just clicking on a specific header.

i have my "date paid", "date delivered" , "date collected" and "Overweight Fee" color coded. when data is entered under these headers the rows change colors based on data inputted . Green, Red, yellow and orange in that order.

Is there a macro that will organized specific colored rows together just by clicking on those headers, and another code that will reset the row back to its original position?

 

[Fluff]

they modified it using a table that allows the Letter columns to fade to the header names when scrolling down instead of using the freeze pane function.

That's exactly what I said, it's the default when dealing with tables.

As this is now a totally different question, you will need to start a new thread.

 

[Rurkz]

Ok ok