Copy a part of rows from one sheet to another based on cell value

cristicostache83

New Member
Joined
Mar 1, 2022
Messages
1
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
Hello
Can you help me with a code to do this:

I need copy and paste a a part of row from one sheet to another if the cell value in column C = AAA or BBB
I need to do this in a automatic way without a button .
When either cell from row 4 in Sheet "DATA" change their value and if the value of cell C4 = AAA then copy cells from B4 to O4 to sheet LIST starting with row 4, and if cell C4 = BBB then copy cells from B4 to G4 and from P4 to W4 to sheet LIST and append to existing without overwrite the last row .
If C4= AAA data who apear is on row 5
If C4= BBB data who apear is on row 6
Data from Row 4 from sheet DATA is changed from another sheet that i deleted, when I hit a button and the number of rows increase with one everytime the I hit a button.

I played around with some code but wasn't getting anywhere with what I had.
Thanks a lot.
 

Attachments

  • sheet LIST.JPG
    sheet LIST.JPG
    201 KB · Views: 18

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,215,734
Messages
6,126,544
Members
449,316
Latest member
sravya

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
Back
Top