Automatically Copy rows to different sheets

Rurkz

New Member
Joined
Jan 9, 2021
Messages
11
Office Version
  1. 365
Platform
  1. Windows
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
52,939
Office Version
  1. 365
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Rurkz

New Member
Joined
Jan 9, 2021
Messages
11
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Jan 9, 2021
Messages
11
Office Version
  1. 365
Platform
  1. Windows
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
52,939
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,530
Messages
5,596,699
Members
414,088
Latest member
rodriboraun

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top