Good morning.
Okay so I have been trying to acheive this for 3 days now. I have tried loops etc. I am very much a VBA novice. Unfortunately, I have been unable to make this work as required.
I am attaching 2 example Workbooks MasterData.xlsx and WorkingData.xlsm
WorkingData.xlsm needs to have a button that when pressed it will hide all columns in MasterData.xlsx except for the ones where the data in row 4/5 within WorkingData.xlsm match the data in row 1 within MasterData.xlsx
It need to do this irrespective of the sheet labels as they may not always be the same in MasterData.xlsx
I hope this goes somewhat further to explain what I need achieve.
Once again help from anyone would be very much appreciated.
Not sure if the files are going to attach or not.
Kind regards BanburyS