#1
|
|||
|
|||
Highlight Duplicate Values Across Multiple Sheets
Hello,
I have a spreadsheet that I track invoice numbers and cost. These invoice numbers is entered manually each week. I have a tab created for each month. To make sure that I don’t have duplicate invoices, how would I create a rule to highlight duplicate invoice numbers Across multiple tabs? Thanks for helping |
#2
|
||||
|
||||
Hi
do you really need to create different tabs for each month to enter your data? It would be much simpler to enter your data in one sheet ( with a column for dates) for analysis or detecting duplicate entries. Pivot Tables with slicers would allow extracting monthly data or whatever needed. If you wish to keep you actuallayout,to help us help you it would be advisable to post a sample sheet with some data ( mocked up if needed) so we can see your data layout |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to highlight duplicate phrases in document? | taw | Word VBA | 0 | 02-27-2018 01:47 PM |
Trying to match values across multiple sheets | coxyada | Excel | 2 | 12-13-2016 03:44 PM |
Multiple found values from five sheets, multiple returned values in sheet six? | irisha | Excel Programming | 26 | 09-30-2016 01:20 AM |
Highlight duplicate words.. ?? IN MICROSOFT WORD !! | Abhi | Word | 1 | 09-22-2016 07:25 PM |
Reference another workbook and return values from the same cell across multiple sheets/tabs | lwls | Excel Programming | 5 | 11-08-2014 02:11 PM |