Cowells01
New Member
- Joined
- Oct 30, 2020
- Messages
- 6
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
- MacOS
Hi guys, I have two workbooks (workbook 2 has two worksheets) I want to pull data from both worksheets by choosing, maybe from a drop down, the correct worksheet. Data has the same headers. Final thing is workbook 2 changes it’s name each week! Can I put the name into a cell to reference the search workbook in workbook 1. The files sit on my drive but will move to teams/SharePoint in the future.