Excel move to specific cell

Question

Hi - i need to create a log sheet to map storage of numbered samples in a tray.

i need to create a 10x10 table in excel and scan inthe barcodes fromthe samples. Once i get to A10 i need the cursor to automatically move to B1, then when i get to B10 it needs to move to C1 etc.

thank you

Answer 1

Hi saracasson ,

I am Vijay, an Independent Advisor. I am here to work with you on this problem.

1. Make a backup of your workbook.
2. Open your workbook and ALT+F11
3. Locate your Workbook name in Project Explorer Window
4. Double click on your worksheet name
5. Copy paste the Macro code given below
6. Save your file as .xlsm Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ExitSub If Intersect(Target, Me.Range("A10:I10")) Is Nothing Then Exit Sub Application.EnableEvents = False Me.Cells(1, Target.Column + 1).Select ExitSub: Application.EnableEvents = True End Sub

Do let me know if you require any further help on this. Will be glad to help you.

Answer 2

Hello saracasson,

my name is Manuel and I am an independent advisor.

As far as I know this won't be possible without writing a macro or using a tool to have a function which automatically jumps to cell X when cell Y is reached.

To make this easier you can give names to specific cells:

https://support.office.com/en-us/article/define...

If you know the time distance in which the mouse has to move from cell to cell you can use a tool like ghost mouse where you record an input and ghost mouse repeats the steps.

Greetings,

Manuel