Hello all,
First time poster here. Any help would be greatly appreciated.
I am trying to type text in e.g. sheet1 cell A2 and get that same text to show automatically in sheet 2 cell B3
I have kind of worked it out, I use a formula like so:
='C:\Documents and Settings\Administrator\Desktop\[example.xls]Sheet1'!A2
That will work, but when I try to make any changes to that string, e.g. change cell A2 to A3 the formula just shows as text in the destination cell.
Thanks in advance
P.s. I'm using Excel 2002
Are you trying to show data from a seperate closed workbook or show data from the same workbook?
Not all forums are the same - seek and you shall find
Hi Simon, thanks for swift reply. Same workbook, sheet 1 to sheet 2
Use this notation: =Sheet1!A1 you can copy this down, left, right or up and the cell reference will change accordingly, if you wanted lest say the Column to always be the same then we start using Absolute cell referencing (yeah sounds horrific but it's not!) so a formula that looks like this =A1 is called Relative cell referencing and when copied anywhere the column and row number will change accordingly, to use Absolute cell referencing we introduce the $ like this =$A1 the formula there when copied anywhere will always refer to column A but the row number will change, this formula =$A$1 when copied will always reference A1, and this =A$1 when copied will always reference row 1 but the coloumn will change.
So absoulte referencing in your example would be =Sheet1!$A$1 when copied will always be A1 of sheet1 - hope thats clear for you!
Not all forums are the same - seek and you shall find
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks