Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a worksheet that I want to try and eliminate manual activity. To
simplify the question, assume I have three cells A1,B1 and C1. If the value in C1 is X then I want to place the value of B1 in A1. If the value in C1 is not X I want to leave the value in A1 alone. I am trying to create a worksheet with YTD values and I want to place the appropriate values in the appropriate month's columns. I don't want to change the other values for other month's that have already been colleceted and stored. It looks like I have a loop if I am trying to "pull" information in A1. I can't figure out how to "push" information from another cell into A1 without being in A1. Hope this makes sense. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Repeating Last Action | Excel Discussion (Misc queries) | |||
Repeat last action | Excel Worksheet Functions | |||
Can a formula contain an action? | Excel Discussion (Misc queries) | |||
on particular action run a macro | Excel Discussion (Misc queries) | |||
what is OLE.action | Excel Discussion (Misc queries) |