Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying cells by checking color of the cells
hi, sorry that I need help in creating the following: column B of Ws2 contains the IDs(may have repetition). When it runs, it will go to Ws1:column A to look for the same ID. Search for the cells with color 'blue' on the whole row below the ID in Ws1. If there are 2 same ID(e.g. two of ID001) on Ws1:Column A, and 2 blue colored cells that have fields "1" and "2" respectively under same ID001. It will end up like this: ID001: 1 ID001: 2 Then, copy those cells over to Ws2:column E on the same ID row. Next, in Ws1, from the copied cell, go to row 121 of that column, copy the fields in the (row 121:column with the blue copied cell), and paste it over to Ws2:column D on the same ID row. This is real hard for me as I tried it out alot of times, but failed.. I know its rather troublesome but really hope someone out there will help me.. please.. -- JJJ010101 ------------------------------------------------------------------------ JJJ010101's Profile: http://www.excelforum.com/member.php...o&userid=30766 View this thread: http://www.excelforum.com/showthread...hreadid=504311 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
Checking the Cells in Sheet1 with Cells in Sheet2 and replace | Excel Worksheet Functions | |||
Fill cells with color based on criteria in two cells | Excel Worksheet Functions | |||
HOW TO FORMATE CELLS TO COUNT CELLS WITH A FILL COLOR? | New Users to Excel | |||
How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) |