Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return value of heading if an adjacent cell in a row is not blank
I need some help/ideas in creating a macro or subroutine that returns the
column heading of the last cell in a row series that is not blank, and populates the column heading in a cell adjacent to the last task date. I'm using a worksheet to track the dates of when a particular task is completed, and then I want to know what was the last task completed in this series in the cell next to the last task on that row. The data looks like this: Task 1 Task 2 Task 3 Task 4 Task 5 Last Task completed 4/1 4/5 4/6 4/8 Task 4 3/8 3/7 Task 2 3/15 3/17 3/18 3/22 3/29 Task 5 4/12 4/14 4/15 Task 3 ....and so on. What I'd like to do is have Excel check the row to see if it has a date value and then go to the next cell until it finds one that is blank. If it is blank, then return the column heading (task) of the last cell that was not blank in the appropriate cell (in this case "Last Task Completed". I'm using Excel 2000 and I'm comfortable using Excel, but beyond writing simple macros and functions - I'm somewhat limited as I'm not familiar with writing VBA code. So any ideas or suggestions will be greatly appreciated! -- Thanks, Wil H. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I return the value of an adjacent cell? | Excel Discussion (Misc queries) | |||
*HELP* Need a cell to return a column heading | Excel Discussion (Misc queries) | |||
Return value in adjacent cell | Excel Worksheet Functions | |||
return value in adjacent cell different workbook | Excel Worksheet Functions | |||
I want a non-blank cell to return 25% in an adjacent cell. | Excel Programming |