| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet to Worksheet Information
I would like to be able to transfer the value from the LAST used cell in a
column in one worksheet into a cell on a different worksheet..is this possible? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet to Worksheet Information
I should have added that the column I want the last cell from is regularly
added to...so I want the LAST cell added each time to show in a cell on the other worksheet. "Bundy" wrote: I would like to be able to transfer the value from the LAST used cell in a column in one worksheet into a cell on a different worksheet..is this possible? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet to Worksheet Information
Something like this ..
In Sheet2, In say, B2: =LOOKUP(2,1/(Sheet1!A1:A65535<""),Sheet1!A1:A65535) will return Sheet1's last data cell in colA -- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:365 Subscribers:65 xdemechanik --- "Bundy" wrote: I should have added that the column I want the last cell from is regularly added to...so I want the LAST cell added each time to show in a cell on the other worksheet. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet to Worksheet Information
Yes, explaining it is harder:-
last used cell in a column in one worksheet = worksheet called BOND cell B4 Different worksheet, in the cell you want the result =sum('BOND!B4) press enter This works for any cell not just the last used cell. "Bundy" wrote: I would like to be able to transfer the value from the LAST used cell in a column in one worksheet into a cell on a different worksheet..is this possible? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
| Using information from one worksheet, to rename inserted worksheet | Excel Worksheet Functions | |||
| Pulling in Information from a worksheet | Excel Worksheet Functions | |||
| Pull information from one worksheet to another | Excel Discussion (Misc queries) | |||
| Can I sync information on one worksheet with another worksheet | Excel Worksheet Functions | |||
Linear Mode
