I am trying to setup a dynamically linked cell.
This is the link i have:
='https://mezcom.sharepoint.com/sites/Mez/Shared Documents/John Smith/[John Smith 2018 Time Sheet.xlsx]Jan 1-15'!$AH$8
this is what i am trying to do:
B1 would equal a persons name, b3 would be the year...
EDIT: Sorry, the title should have read:
"Referencing Closed Workbook via Open Workbook's external links - VBA"
---------------------------------
I have some code in WorkbookA where I ask for the location of WorkbookB (the data and location constantly change). Via a prompt I am able to select...
I have workbooks on SharePoint. I link data from Book2 to Book1 such as:
Book1 cell A1 ='https://hawaii.mil/Tracker/[Book2.xlsm]Tracker'!A1
I understand the concept of not having Book1 open when and if Book2 is opened and moved because the Eternal Link will follow the move.
Here is my...
Hi everyone,
I often use links to external data to upload the data to my current workbook and than I delete the links to save the present values.
But sometimes the link cannot be deleted! I use Office 2010 and all the tools I found on this forum either involve Excel 2003 or are broken.
Can...
I have searched through several threads already posted and some of them "touch" upon what I have trying to do, I try out some of the suggested solutions, but nothing seems to work the way I need it to. So let me start off by explaining what I am "trying" to do.
I have to track employee...
I have a number or workbooks containing weekly status reports..I would like to aggregate them into a single workbook for mgmt access...
Given:
all workbooks (status reports) are formatted identical;
all worksheets (a week status report is contained in a worksheet with the week in the format of...
On Jan. 1st my Jobs List folder will be archived due to the size and the file name changed to "Jobs List 2008-2011". For every job on the Job List, I have a separate workbook that tracks time and expenses for that particular job. Every individual Job Worksheet has a link back to the Job List...
Hi,
I have the following simplified array formula in cell A1 Sheet1, If I wanted to update the link within excel itself I would simply click Edit>Links>Change Source and job done.
The issue is that this formula needs to be within a macro and just the result displayed in cell A1 Sheet1...
a1: 210.xls
a2: 211.xls
a3: 250.xls
....
an: 335.xls
In my master xls file, I want to link a cell from each of the above files listed in column A.
If I type (say to cell B1) =[210.xls]sheet1!$B$6 I can get the value of cell "B6" of "sheet1" of file "210.xls"
Now my question:
Is there a way to...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.