Getting Reference (url link) from another cell?
pufAmuf
I want to link a cell to an external file. The name of the external file changes daily though.
I created a cell that contains the full address of the external file (C:\Users\Main\Desktop\data\History\02092013.csv)
I then named that cell HistoryFileReference
So then why does this not work?
='HistoryFileReference'!$A$2
When I press enter, a window named "Update Values: HistoryFileReference" pops up, asking me to choose a file.
edit: I don't want to "update links" via excel. Thanks
Siddharth Rout
For this to work you will have to manually put brackets in the file name and then store it as
C:\Users\Main\Desktop\data\History\[02092013.csv] in the cell which you have named as HistoryFileReference
Now open the CSV file and leave it open. Go back to the above sheet and type this formula
=INDIRECT("'" & HistoryFileReference & "02092013'!$A$2")
and press Enter and you are done :)
Caution: Next time you open the file, do not click on Update Links else all the values generated by the above formula will change into #REF! as Indirect doesn't work with close files.
For the sake of an example, I have place a csv file in C:\ as shown in the screenshot below and I am trying to retrieve values from Cell A1
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: CUDA - atomicAdd only adds up to 16777216
- Next: ExtJS 4.2 Binding Tree Panel/TreeStore to client side dynamic JS object array
Related
Related Related
- 1
Getting Reference (url link) from another cell?
- 2
Reference a cell from another worksheet
- 3
Reference a cell with input from another cell
- 4
reference a cell from another worksheet using a variable
- 5
reference a cell from another worksheet using a variable
- 6
Getting the reference of a cell from inside a childview of the cell when a UITapGesture is triggered
- 7
Google spreadsheet cell reference from value of another cell
- 8
How to get the cell reference from a gesture of another item in the cell
- 9
Google spreadsheet cell reference from value of another cell
- 10
Link the function from one cell to the same cell in another sheet
- 11
Range row number reference from another cell in Excel
- 12
How to link a cell to sheet reference
- 13
How to link a cell to sheet reference
- 14
Getting string from another class and transfering it to url
- 15
How to link a cell from one spreadsheet to another, dependent on the details in another cell.
- 16
Getting data from custom tableview cell to another VC?
- 17
Reference a cell based on another cell's cell reference
- 18
Include link created with CONCATENATE from one cell into IMPORTHTML formula in another cell
- 19
Getting JSON URL link from strings.xml to HTTP Request
- 20
Find data in a column from a cell reference in another worksheet then copy some data to another worksheet
- 21
Getting a variable from a url in mvc from another controller
- 22
Detecting url (link) in the text cell
- 23
Getting #N/A for any calculations that reference a cell by name
- 24
Getting data from another URL using form input and reading that data
- 25
Getting the URL another URL redirects to
- 26
link Open/Libre Office button to cell and reference cell in macro
- 27
Excel Cell reference from equation
- 28
Excel Max Formula Reference to another cell
- 29
Reference cell range on another sheet - Excel
Comments