SOLVED

Updating cell values from one cell based on another cell's data

%3CLINGO-SUB%20id%3D%22lingo-sub-1509800%22%20slang%3D%22en-US%22%3EUpdating%20cell%20values%20from%20one%20cell%20based%20on%20another%20cell's%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509800%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%26nbsp%3B%20I%20would%20like%20Excel%20enter%20data%20from%20one%20cell%20into%20another%20cell%2C%20based%20on%20another%20cell's%20entry.%26nbsp%3B%20For%20example%2C%20I%20have%20a%20date%20in%20column%20A%2C%20in%20column%20B%2C%20there%20will%20either%20be%20a%20date%20entered%2C%20or%20n%2Fa.%26nbsp%3B%20If%20column%20B%20is%20n%2Fa%2C%20then%20I%20would%20like%20Excel%20to%20take%20the%20date%20in%20column%20A%20and%20enter%20it%20into%20column%20C.%26nbsp%3B%20If%20column%20B%20is%20a%20date%2C%20then%20I%20want%20to%20enter%20data%20into%20Column%20C%20myself.%26nbsp%3B%20Is%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1509800%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1509875%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20cell%20values%20from%20one%20cell%20based%20on%20another%20cell's%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509875%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F354533%22%20target%3D%22_blank%22%3E%40Sue_G%3C%2FA%3E%26nbsp%3B%20%26nbsp%3Btry%20something%20like%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(ISNUMBER(B1)%2C%22enter%20date%22%2CA1)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Ewhen%20you%20click%20on%20C1%20to%20%22enter%20date%22%20as%20instructed%20it%20will%20overwrite%20the%20formula%20there.%3C%2FP%3E%3CP%3EThat%20said%2C%20not%20the%20best%20practice.%3C%2FP%3E%3CP%3EI%20would%20recommend%20making%20D1%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(ISNUMBER(B1)%2CC1%2CA1)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Eand%20then%20use%20custom%20formatting%20to%20highlight%20cells%20in%20col%20C%20that%20need%20a%20date%20entered%3C%2FP%3E%3CP%3Ehighlight%20col%20C%20and%20go%20to%20custom%20formatting%20-%26gt%3B%20custom%20formula%20and%20enter%3A%20%3DISNUMBER(B1)%3C%2FP%3E%3CP%3E%26nbsp%3Byou%20may%20also%20want%20to%20lock%20or%20maybe%20gray%20col%20D%20so%20you%2Fothers%20don't%20overwrite%20the%20formula%20there.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1511709%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20cell%20values%20from%20one%20cell%20based%20on%20another%20cell's%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1511709%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570951%22%20target%3D%22_blank%22%3E%40mtarler%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much...this%20is%20perfect.%26nbsp%3B%20I%20appreciate%20your%20suggestions%20as%20well...I%20will%20definitely%20use%20them!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1511757%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20cell%20values%20from%20one%20cell%20based%20on%20another%20cell's%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1511757%22%20slang%3D%22en-US%22%3E%3CP%3Egreat%2C%20so%20glad%20to%20help.%26nbsp%3B%20feel%20free%20to%20like%20and%20mark%20best%20response%20to%20'close'%20the%20thread.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1511808%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20cell%20values%20from%20one%20cell%20based%20on%20another%20cell's%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1511808%22%20slang%3D%22en-US%22%3EDone!%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello.  I would like Excel enter data from one cell into another cell, based on another cell's entry.  For example, I have a date in column A, in column B, there will either be a date entered, or n/a.  If column B is n/a, then I would like Excel to take the date in column A and enter it into column C.  If column B is a date, then I want to enter data into Column C myself.  Is this possible?

4 Replies
Highlighted
Best Response confirmed by Sue_G (Occasional Contributor)
Solution

@Sue_G   try something like 

=IF(ISNUMBER(B1),"enter date",A1)

when you click on C1 to "enter date" as instructed it will overwrite the formula there.

That said, not the best practice.

I would recommend making D1

=IF(ISNUMBER(B1),C1,A1)

and then use custom formatting to highlight cells in col C that need a date entered

highlight col C and go to custom formatting -> custom formula and enter: =ISNUMBER(B1)

 you may also want to lock or maybe gray col D so you/others don't overwrite the formula there.

Highlighted

@mtarler 

 

Thank you so much...this is perfect.  I appreciate your suggestions as well...I will definitely use them!

Highlighted

great, so glad to help.  feel free to like and mark best response to 'close' the thread.

Highlighted