need function or macro to move the cursor to the selected cell.

[Giri.hb]

Hello Team,

I have the macro added spread sheet where when I have selected one name from the drop down in the A column, the tab automatically move to G column, when we update the G column the tab automatically move to K column. Please let us know how to do that and one more thing that when I select different name in the A column the tab needs to automatically move to D column and when D column is updated the tab needs to be move to J column. Please assist me on how to do that using formula or macros.

Regards,
Girish

[dflak]

Use a change event on the sheet code.

[Giri.hb]

please explain more on the above change event on the sheet code in brief. Thank you.

[dflak]

Include a sample worksheet and I'll show you how. If you don't attach a spreadsheet we assume you are fairly competent and only need a general answer. Few responders will take the time to create the conditions we think you have so we can answer your question. What's the "one name" and the "different name?"

Do you mean if I enter a specific name in column A, the code does one thing and I enter another specific name in column A, the code does something else?

or
Do you mean if I enter any name in column A, the code does one thing and I enter any other name in the column it does something else?

How are you matching names with what the code is supposed to be doing?

[Giri.hb]

hello team,

actually what I need is when I select Work A in B2 cell from the drop down the cursor has to move automatically to Task 3 (E2 cell) and once Task 3 has been updated the cursor has to move to Task 6 (H2 cell) instead of manually move the cursor using tab or right arrow key

Note I have applied conditional format in my master sheet where when I select Work A both the Task 3 and Task 6 cell will get highlighted.

Please let me know if you need further information and assist me at the earliest. Thanks for your help in advance.

[JohnTopley]

Please Login or Register  to view this content.

Try this:

It clears previous entries if a line has already been entered i.e. is being overwritten

To insert code, right click on Sheet1, View code: you can then copy and paste into your master file by repeating the "view code" on sheet in master file.