Excel Copy Paste [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
There are Job titles in COLUMN A.

There are a list of dates in COLUMNS G, I & K

There is information in all the rows between A, G, I & K

There is a list in COLUMN C which has either "completed" OR "not completed"

IF COLUMN C has "Completed" :


I am trying to write a macro does the following:


*Copies the data in the ROWs OF COLUMN A & COLUMNS G, I & K


*Pastes the data in a new row (20 ROWs down from the orginal ROW)
ONLY the data in columns A, G, I & K.


*Looks at the next row and does the same thing if the COLUMN C Cell for that row has "completed" - There are a total of 10 ROWS.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!