Marco that inserts a formula if cell is changed on sheet with in a named range

[meabrams]

I am looking for the proper way to have a formula inserted into a cell if another cell is change and doesn't equal "Rotating".
The Named Range is Shift_Select and I need it to look in the Second column of the named range (the change actual column is F2:F) and change if cell value <> "Rotating". If that is true then insert a basic
equals formula in the first column in the Named Range (the actual column is E2:E)

something like

=F"cellrow"

[skywriter]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[meabrams]

Here is the sample The Sheet Name is MSF
SampleWithUpdates.zip

[skywriter]

I'm not sure what you want to do here, your explanation is a little confusing.

Regarding your named range, you are using a CountA formula so right now that formula is making the resultant range E5:F8 because row 1 is not blank and you have 2 cells farther down the page in column E that are also not blank.

Hit F5 and then where it says reference type SHift_Select and hit ok to see what I am talking about. Is this what you expected to see?

I don't know what this means F2:F, you write F2 but no other number so I don't know what you mean.

It would be best if you would just refer to specific cells.
Just give some one cell examples of what you want.
A simple example not related to your sheet would be, check cell A1, if it is blank the formula in B1 would be Sum(C1:Z1), otherwise B1 = Today's date. Something specific like that would be very helpful.

[meabrams]

I need a simple equals formula to insert when the cell next to it is changed to anything so if
F2 is changed then formula auto inserted into E2 something as simple as =F2

I know that it has to be placed in

Please Login or Register  to view this content.

but Im not sure haw to make it do what I want it to

I did fix my Named Range so it does now grab all that is used

Please Login or Register  to view this content.

[skywriter]

Okay it sounds like you know what you want and want to do it yourself.
Hopefully this will help you.
If you make a change to 1 cell at a time to any cell in your named range in the F column this will make the formula in the cell next to it as you asked for.
You change F2 and the formula in E2 is =F2.

Please Login or Register  to view this content.

[meabrams]

That's what I needed thank you

[skywriter]

My pleasure, thanks for the rep. points.