cristicostache83
New Member
- Joined
- Mar 1, 2022
- Messages
- 1
- Office Version
- 365
- 2021
- Platform
- 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.
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.