BookkeepingDave
New Member
- Joined
- Jun 17, 2022
- Messages
- 1
- Office Version
- 2021
- Platform
- Windows
Hi I was hoping I could ask for some help here.
I am trying to find a way to get data from workbooks that change name, and am looking to see if there is a good way of doing it.
So the situation is we have a client who is posting there takings figures to a workbook in a shared folder in drop box. there are two sheets for different sites and i need to grab these weekly figures put them into a central workbook on our own computer, then upload them.
The table layout is pretty much the same for both sites, with a bit of variation, days along the top, takings for various products down the side, not in a table but individual cells.
The file name is always the same apart from the date changing, so its "Weekly Takings d-m-yy" format.
Is there anyway to get the formulas to pick up the change of date, when it is referencing the folder.
so its
='C:\Users\Patrick\Compnay name dropbox\Bruce\[Till Takings Sheet 2-5-22.xlsx]Wayne Drive'!H$8
But then have it pick the "2-5-22" part of the filename up from a cell, so we can refresh the main sheet and import the data when we want without having to edit all the cells as thats the only part that changes.
I am trying to find a way to get data from workbooks that change name, and am looking to see if there is a good way of doing it.
So the situation is we have a client who is posting there takings figures to a workbook in a shared folder in drop box. there are two sheets for different sites and i need to grab these weekly figures put them into a central workbook on our own computer, then upload them.
The table layout is pretty much the same for both sites, with a bit of variation, days along the top, takings for various products down the side, not in a table but individual cells.
The file name is always the same apart from the date changing, so its "Weekly Takings d-m-yy" format.
Is there anyway to get the formulas to pick up the change of date, when it is referencing the folder.
so its
='C:\Users\Patrick\Compnay name dropbox\Bruce\[Till Takings Sheet 2-5-22.xlsx]Wayne Drive'!H$8
But then have it pick the "2-5-22" part of the filename up from a cell, so we can refresh the main sheet and import the data when we want without having to edit all the cells as thats the only part that changes.
