Automatically Move to a Specific Worksheet after Typing in a Specific Cell

[Squint]

I am not sure if this is even possible but I was wondering if anyone knows of a way to automatically move to a specific worksheet if a cell in another worksheet is populated. I have tried conditional formatting and I am not sure if a formula would work because the cell would be typed in and I am not very familiar with VB. I am attaching the workbook and right now I have a comment in the cells (column E on the Enter Data Worksheet) that says that if data is entered into this cell the "Sales Tab" worksheet must be filled out. I am concerned some may not pay attention to the comment so if there are any other solutions anyone has I appreciate any suggestions.

Thanks so much

[JieJenn]

Hit Alt + F11 to open the VB window, expand Microsoft Excel Objects, double click Sheet1 (Enter Data) and copy and paste the code

Please Login or Register  to view this content.

[Squint]

You are amazing. Thank you so much. It worked perfectly. I really want to learn VB

[Squint]

Sorry to bother you again but there does seem to be one little glitch with this that I just noticed. It does not work when I enter the number 1 or 2. Is that a way I can fix that? I don't want to mess up your code.

[JieJenn]

OOps. Remove the S in front of target.rows. It should be target.Row Not target.rows

[Squint]

Perfect! Thanks again!