A1 change into C1 only if E1 is True.

spiceytayley

New member
Joined
May 15, 2019
Messages
4
Reaction score
0
Points
0
Excel Version(s)
Microsoft Excel 2010
Hello. I'm trying to create a formula in excel that will make A1 change into C1 only if E1 is True.
If E1 is false, I need the cell in A1 to remain as is.
(I'm trying to get this to happen without adding another column with the same values as originally located in column A).
Any assistance would be greatly appreciated.
Thank You <3

U77B2402TRUE
EX: The above "U" should change into the "B" because it is marked as "TRUE"

B72C2264FALSE
EX: The above "B" should remain the same ("B") as it is marked "FALSE".

This is the data that I'm working with:
B12B216FALSE
B13B308TRUE
B14B434FALSE
B38B1061TRUE
M39B1126FALSE
U77B2402TRUE
B78B2414FALSE
B118B3477FALSE
U119B3492TRUE
B124B3631FALSE
U151B4483TRUE
M152B4515FALSE
M162B4769FALSE
U163B4784TRUE
B164B4825FALSE
 
Spiceytaley
A few questions
1) Is the reason you don't want to add a column because you don't want to change how your worksheet looks? If so you could have a data entry column where you enter the values that you have in column A, then you could hide it easily hide it using the group command under the data menu. You could then enter formulas in Column A that reference you data entry column.
2) Another option would be to enter all of your data that you show in workbook 1. Then have formulas in worksheet 2 that will change the what is in column A.
3) Another option would be a code solution.

Would any of this 3 solutions work for you?
 
Please post a sample sheet so we can work with it
Click Go advanced - Manage attachments and follow the wizard. Thanks
 
Maybe a code solution?
We are just trying to make it happen without adding extra data to the mix.
I've attached a sheet.View attachment 9116

Code:
Public Sub mysub()
Sheets("sheet1").Select
Dim rng As Range, cell As Range


Set rng = Range("a1:a200")


For Each cell In rng
    If cell.Offset(0, 4).Value = True Then
    cell.Value = cell.Offset(0, 2).Value
    End If
Next


End Sub
 
Please don't quote whole posts -- it's just clutter and makes the thread hard to read. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding
For normal conversational replies, try using the QUICK REPLY box below.
 
Back
Top