Question Locked

Link worksheets in Excel

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a spreadsheet with multiple worksheets. I want to run conditional formatting/highlight cell rules/duplicate values to mark duplicate data (item numbers). The worksheets are labeled by month and there are 12 of them. For instance, if on sheet 1 (january) in cell B617 the number is 23466778 I want to see if there is the same number on any of the worksheets. I use ctrl f, then find all, and so far it will only check the active worksheet.

3 replies

by thumbsup2

CTRL+F and then click Options to switch to search WORKBOOK instead of SHEET. To do anything else, you'll need to write a macro to do it for you.

But, what has that got to do with LINK worksheets? Links are for calculated values based on values taken from other workbooks. If everything you want to look at is in the same workbook, you don't need links.

by colesbraxton

You are correct, I just didn't know how to title my request. I followed your suggestion and it worked like a charm.

thank you

This discussion is closed to new replies.