Hey,
Does anyone know how I would get this done without using a macro? - I need to have a value in a cell and keep that value there unless a value is put in another specific cell so essentially: making A1 = A2 if there is a value in A2 otherwise keep the value already in A1
the only way i can see to achieve that is to put value in required in A into C1 then use
in A1=IF(ISNUMBER(B1),B1,C1)
Last edited by martindwilson; 12-21-2007 at 02:03 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks