Good Morning, this maybe complicated for me to explain. I have Sheet named 'Master' which tracks my office mandatory tasks. In Column B are the names of people (B2:B38) InRow 1 are the task names which match exactly to sheet names. then I have conditional format to show Green, Red, Orange, and Yellow which refer to dates in cells A54 and A56:58 3-Feb-14 5-Mar-14 30 days 4-Apr-14 60 days 4-May-14 90 days What i need to do is move the names in Column B2:B38 the cell color in the same row that are red in columns (2:38) G, I, K, M, O, Q, S, U, W, Y, AA I hope this is making sense. for each of the sheet the names need to placed starting in row 2. along with the value in red (date) Please let me know what else is required for this Macro.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

move Cell to sheet name based on vaule in another column.

Thread starter Jerk24
Start date Feb 3, 2014
Tags

sheets vaule

Jerk24

Board Regular

Feb 3, 2014

Good Morning,

this maybe complicated for me to explain.

I have Sheet named 'Master' which tracks my office mandatory tasks. In Column B are the names of people (B2:B38) InRow 1 are the task names which match exactly to sheet names. 

then I have conditional format to show Green, Red, Orange, and Yellow which refer to dates in cells 

A54 and A56:58

3-Feb-14 

5-Mar-14 30 days 
4-Apr-14 60 days 
4-May-14 90 days 

What i need to do is move the names in Column B2:B38 the cell color in the same row that are red in columns (2:38) G, I, K, M, O, Q, S, U, W, Y, AA

I hope this is making sense. for each of the sheet the names need to placed starting in row 2. along with the value in red (date) 

Please let me know what else is required for this Macro.