Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
last entry in a range?
Excel '07 on Windows XP
Working on a YTD summary sheet for 12 month workbook. Each sheet is calulating a monthly inventory variance, with beginning inventory in cell B17 and ending inventory in cell B19. I will set the summary sheet to use the beginning Inventory from cell B17 on teh October sheet( fiscal year not calendar). Is there a way I can fill in cell B19 with last entry in cell B19 from worksheets October:September. I wnat teh summary page to report ending inventory for the last month which has an Ending inventory entry. I need to fuidn and report the last entry in cells October!B19, November!19, December!19, January!19 , etc through September!19. Has anyone solved a similar situation? Have suggestions or ideas? Thanks in advance for your input |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entry must match value in range | Excel Worksheet Functions | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
Highlight a range for data entry | Excel Discussion (Misc queries) | |||
How do I hide spreadsheet range from data entry? | Excel Worksheet Functions | |||
Allowing only one entry in a range | New Users to Excel |