On my previous thread it showed the foloowing code I placed in each cell. =IF(ISNA(MATCH(Joshua!B25& Joshua!E25,'Week 47'!$B$2:$B$498&'Week 47'!$E$2:$E$498,0)),"",INDEX('Week 47'!$A$2:$E$498,MATCH(Joshua!B25& Joshua!E25,'Week 47'!$B$2:$B$498&'Week 47'!$E$2:$E$498,0),1)). To much time is wasted. I need to cover from A25 thru E724 on all 10 worksheets(each worksheet has a different name on the tab) and color code the cell "A" on the master worksheet(Week 47) once the match is found. The master worksheet changes each week. If more info is needed, let me know. Thanks for all the help in advance!!!!
-
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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
need a macro to match text columns on multiple worksheets and color code a cell from the Master worksheet
- Thread starter Milemae
- Start date
Excel Facts
Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Similar threads
- Question
- Replies
- 0
- Views
- 112
- Question
- Replies
- 0
- Views
- 380
- Replies
- 6
- Views
- 1K
- Replies
- 3
- Views
- 274
- Question
- Replies
- 1
- Views
- 498
