| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last row value to another sheet
On one worksheet, I have several rows. Each time a new row of data is added,
I need to take the value from column B in the last row and display it in a D3 on another worksheet. Can anyone help get me started? Ted |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last row value to another sheet
http://www.excelforum.com/showthread.php?t=519044 go here for an answer -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519045 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last row value to another sheet
No, I need the value from a column in whatever row is the most recent, the
last row which changes every so often. In other words, a row with new data is entered every week, from this row, the last row with data in it.... Ted "davesexcel" wrote in message ... http://www.excelforum.com/showthread.php?t=519044 go here for an answer -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519045 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last row value to another sheet
Hi!
Is the data text, numeric or could it be either? Biff "Ted Dawson" wrote in message ... No, I need the value from a column in whatever row is the most recent, the last row which changes every so often. In other words, a row with new data is entered every week, from this row, the last row with data in it.... Ted "davesexcel" wrote in message ... http://www.excelforum.com/showthread.php?t=519044 go here for an answer -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519045 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last row value to another sheet
The data will always be numeric.
Ted "Biff" wrote in message ... Hi! Is the data text, numeric or could it be either? Biff "Ted Dawson" wrote in message ... No, I need the value from a column in whatever row is the most recent, the last row which changes every so often. In other words, a row with new data is entered every week, from this row, the last row with data in it.... Ted "davesexcel" wrote in message ... http://www.excelforum.com/showthread.php?t=519044 go here for an answer -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519045 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last row value to another sheet
Try this:
=LOOKUP(9.99999999999999E+307,Sheet1!B:B) Change the sheet name as needed. Biff "Ted Dawson" wrote in message ... The data will always be numeric. Ted "Biff" wrote in message ... Hi! Is the data text, numeric or could it be either? Biff "Ted Dawson" wrote in message ... No, I need the value from a column in whatever row is the most recent, the last row which changes every so often. In other words, a row with new data is entered every week, from this row, the last row with data in it.... Ted "davesexcel" wrote in message ... http://www.excelforum.com/showthread.php?t=519044 go here for an answer -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519045 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
| Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Hybrid Mode
