Hi All,
I hope everyone is well and keeping safe. I'm hoping someone could help or point me in the right direction to solve this.
I have a workbook that has a Dashboard Tab, 12 Month Tabs and a Master Data Tab.
The aim of the workbook is to track order numbers and invoices and provide a quick search feature for both in the Dashboard.
My original idea was to not bother with the master data and use XLOOKUP to search an array of tables made up from tables in each month - This was way beyond me and I couldn't get that to work... boohoo!
I'm now going to use the XLOOKUP on the Master Data sheet, but I don't want users to have to enter duplicate data in the Master Data sheet and the corresponding Month sheet. I need a solution that is either 1 to many (enter data in Master Data) to auto update the Month sheets from the Master Data sheet or many to 1 (enter data into the correct Month sheet) to auto update the Master Data sheet from the Month sheets.
I've attached the workbook with test data in Jan 2020 tab to test the XLOOKUP before trying to modify the formula to check all the tabs. There is a macro (Clearcells1) assigned to the "Clear Search Box" button.
If possible I'd like to achieve this without using VBA, but if that's not possible then VBA it is.
Thanks in advance for looking at this
Bookmarks