cell address

This is what i have Ok firstly thanx to a couple of people who helped with the original code. now in this code 'F19' would be something like " Goedehoop south colliery"( as the path to save it in. 'K22' would be an order or quote number to the effect of " U15415" in the 'F19' path there...

Hi, I have a range where I want to find a cell address based on another function, like HLOOKUP or any other. But when I use HLOOKUP function as a 'refernce' argument in Excel's inbuilt function Cell(), it gives an error. Is there a way, that I can find a cell address based on any of the...

I am importing stock data and ticker symbol from a page that gets refreshed often. What is the most effective way to automatically keep the data that was derived from the data download and stop it from refreshing from the cell addresses that it came from? Thanks, Michael

Dear users, I am looking to create a summary worksheet using the indirect function to collect "Prices" from several tabs in the same worksheet. As I have about 40 workbooks to do this for, I want to create a Summary Template I can copy and paste into the other workbooks: As seen in MrExcel #...

I'm working on a spreadsheet that has quotation (") marks in cells to signify that the value should be that of the previous cell. With this having over 50,000 rows I'd like to be able to find and replace the quotation marks with the value from the previous cell. Is there a function that allows...

Suppose I wish obtain a value from a cell, say AL4. At a later point, I wish it to refer to another number, say AL20. I specify these numbers in another cell, say BX5. In other words, the number after AL can vary, based on what I place into BX5. I'm inclined to write: =+AL(BX5), but this...

Hi. I'm looking for a way to return a cell address, that can be changed dynamically. In others words, my input on Sheet is two Values (F1,F2) that happen to be also be on a list in column A (although, not cell referenced). I would like to return below the F1,F2 values in sheet 2 there 'location'...

Hi, Hopefully this should be an easy one - I just can't get it to work. In excel 2003 I'm trying to get a multiple search/find to return an offset text string to a text box (it will actually be multiple strings into multiple textboxes, but for the purpose of this question basing it on one...

Hi. I am not an Excel expert, I use it maily as a database whith no macros and so on. I have an Excel sheet where I want to use references from a cell in one row to a cell in another row, for example two rows above (row 13). But when I then sort the table, the references point to a wrong...

Hello! I usually come here for help when I can't find what I'm looking for, so maybe someone can help. Most of the questions I've seen are asking how to get a cell address. I would like to go TO a cell having the address. I have a cell that contains a cell address using the the...