Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refresh Button
I am trying to create a module/procedure code which would let me fill missing fields in Excel based on the values that are above and below it. (That is realy confusing) As an example I have 6 cells one of them has variable? "Close" and the other "New". I need to write a loop in Excel where empty fields that are above or below variable "Close" would show "Close" and variable "New" would fill empty space that are below "New" cell. I believe that it would start something like Sub RefButton() If cell = "Close" empty cell above is also "Close" and empty cell below = "Close. Then If cell is "New" empty cell below would also be= "New". Would anyone know of a cure to my problem? Igor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button anomalies | Excel Discussion (Misc queries) | |||
Command Button VBA code | Excel Discussion (Misc queries) | |||
how to create button commande to refresh data in query in excel 2. | Excel Discussion (Misc queries) | |||
command button moves | Excel Discussion (Misc queries) | |||
How do I setup a spin button in excel | Excel Discussion (Misc queries) |