Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-11-2020, 09:30 PM
Bo_Knows_04 Bo_Knows_04 is offline Highlight Duplicate Values Across Multiple Sheets Windows 7 64bit Highlight Duplicate Values Across Multiple Sheets Office 2016
Novice
Highlight Duplicate Values Across Multiple Sheets
 
Join Date: Jan 2018
Posts: 3
Bo_Knows_04 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 07-11-2020, 11:41 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Highlight Duplicate Values Across Multiple Sheets Windows 7 64bit Highlight Duplicate Values Across Multiple Sheets Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,422
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to highlight duplicate phrases in document? taw Word VBA 1 03-01-2018 11:01 AM
Highlight Duplicate Values Across Multiple Sheets 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
Highlight Duplicate Values Across Multiple Sheets Reference another workbook and return values from the same cell across multiple sheets/tabs lwls Excel Programming 5 11-08-2014 02:11 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 03:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft