if then statement with inserted rows

[runter]

Ok, so I have a excel document where I have results on sheet1 and it pulls information from other sheets. I have a button on each sheet that allows someone to enter information and it'll push the old information done. What I'm trying to do is format a formula so that it always looks at a specific cell on the newly inserted row, but I can't get the formula to stay. The formula always moves down with the inserted row.

=IF('VibePro Balancer'!E6="","C","D") - This is the formula I'm using. What I need is the E6 to always stay E6 even if a new row is inserted. I have played around with several commands, indirect, index, etc and either I'm not using them correctly or maybe I'm adding them wrong. I have enclosed a pic of the information screen. The "New Record" button inserts a new row.

Any help would be greatly appreciated!

[TMS]

Try:

Please Login or Register  to view this content.

[runter]

That worked! Thank you, thank you, thank you!

[TMS]

You're welcome.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.