CODEWITHSUNDEEP
exceldata-transfer
Dylan Davis
Dylan Davis

Reputation: 11

Transferring certain colored cells to other excel sheets

I was wondering if it is possible to transfer certain colored cells to other excel sheets. I have colored the approved cells green and the non approved cells red. There are two different spreadsheets I want distribute this data to, one is called the approved sheet and the other is called the non approved sheet. The reason I would like to make this automatic because there are around 80k rows of data and doing that manually would take forever.

Thank you for the help and all the information provided.

Upvotes: 1

Views: 48700

Answers (2)

Mzf
Mzf

Reputation: 5260

Since I guess that you color the cells according to certain condition, than you can copy to other sheet according to this condition.

You can use the filter like suggested above , or sort and then copy. If you in to code , than you can write some VB script to do that

I think it should something like this (I'm not VBA Expert)

Set mrNames = Sheets("MyDataSheet").Range("C2:C100")

For Each cell In mrNames

If cell.Value = "Approved" Then
cell.EntireRow.Copy
Sheets("Approved").Range("C" & Rows.Count).End(xlUp).Offset(1, -2).PasteSpecial
    End If

Upvotes: 0

Jerry
Jerry

Reputation: 71578

If you don't mind doing two copy/pasting, you can insert a filter

enter image description here

then filter on the specific colours. After that, copy the relevant cells and paste into the required sheet.

enter image description here

And then repeat for the other colour.

Upvotes: 2

Related Questions