Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula finding last cell in row containing data
I have a large workbook that I enter data into each month. On one worksheet
I need to copy only certain pieces of the current month's data. I know I need a formula that finds the last cell that contains data in a row. I'm not that good at this, so it's over my head. Can anyone help me? -- Abbie W. Missouri Dept. of Corrections |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula finding last cell in row containing data
See this:
http://xldynamic.com/source/xld.LastValue.html -- Biff Microsoft Excel MVP "AbbieW" wrote in message ... I have a large workbook that I enter data into each month. On one worksheet I need to copy only certain pieces of the current month's data. I know I need a formula that finds the last cell that contains data in a row. I'm not that good at this, so it's over my head. Can anyone help me? -- Abbie W. Missouri Dept. of Corrections |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula finding last cell in row containing data
Thank you so much. That was exactly what I needed. Why didn't I think of
Lookup? I really appreciate your help! -- Abbie W. Missouri Dept. of Corrections "T. Valko" wrote: See this: http://xldynamic.com/source/xld.LastValue.html -- Biff Microsoft Excel MVP "AbbieW" wrote in message ... I have a large workbook that I enter data into each month. On one worksheet I need to copy only certain pieces of the current month's data. I know I need a formula that finds the last cell that contains data in a row. I'm not that good at this, so it's over my head. Can anyone help me? -- Abbie W. Missouri Dept. of Corrections |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula finding last cell in row containing data
You're welcome!
-- Biff Microsoft Excel MVP "AbbieW" wrote in message ... Thank you so much. That was exactly what I needed. Why didn't I think of Lookup? I really appreciate your help! -- Abbie W. Missouri Dept. of Corrections "T. Valko" wrote: See this: http://xldynamic.com/source/xld.LastValue.html -- Biff Microsoft Excel MVP "AbbieW" wrote in message ... I have a large workbook that I enter data into each month. On one worksheet I need to copy only certain pieces of the current month's data. I know I need a formula that finds the last cell that contains data in a row. I'm not that good at this, so it's over my head. Can anyone help me? -- Abbie W. Missouri Dept. of Corrections |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for finding next cell with data? | Excel Discussion (Misc queries) | |||
Finding matching cell data | Excel Worksheet Functions | |||
Finding Cell Address for Use as Formula Argument | Excel Worksheet Functions | |||
best formula for finding a cell value? | Excel Discussion (Misc queries) | |||
Finding last cell with data in a column | Setting up and Configuration of Excel |