Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Search columns on multiple worksheets
In a workbook I have a worksheet for each month of the year. How would I be
able to automatically determine whether the entry currently being made has been entered in the same column previously on any of the worksheets? (Similar to €śFind€ť under Edit) If so, would it be possible to indicate the previously entered data by highlighting each duplicate cell? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Search columns on multiple worksheets
I suggest you start with Chip's site www.cpearson.com which has lots about
duplicates Then come back with more detailed question best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "wally" wrote in message ... In a workbook I have a worksheet for each month of the year. How would I be able to automatically determine whether the entry currently being made has been entered in the same column previously on any of the worksheets? (Similar to "Find" under Edit) If so, would it be possible to indicate the previously entered data by highlighting each duplicate cell? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Search columns on multiple worksheets
Hi,
Go to each of the other sheets and highlight the range where the data is, suppose B1:B100. In the Name Box, left side of the Formula Bar, enter FirstColumn and press Enter. Move to the next sheet and do the same by give it the name SecondColumn. Highlight the cells where you want the formatting to alert you to duplicates. Choose Format, Conditional Formatting, and pick Formula is from the first drop down. In the second box enter the formula =OR(B1=FirstColumn,B1=SecondColumn) Click the Format button and choose a color on the Patterns tab, click OK twice. -- Thanks, Shane Devenshire "wally" wrote: In a workbook I have a worksheet for each month of the year. How would I be able to automatically determine whether the entry currently being made has been entered in the same column previously on any of the worksheets? (Similar to €śFind€ť under Edit) If so, would it be possible to indicate the previously entered data by highlighting each duplicate cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search in Multiple Worksheets | Excel Discussion (Misc queries) | |||
Search multiple worksheets | Excel Worksheet Functions | |||
Search multiple worksheets - Excel 97 | Excel Discussion (Misc queries) | |||
How do I search for a string across multiple worksheets in Excel? | Excel Worksheet Functions | |||
Search Multiple Worksheets | Excel Discussion (Misc queries) |