Returning cursor to first cell, next line down

I am using a handheld scanner to record asset/serial numbers of hard ware. I
scan 4 cells worth of data (across) and I would like to find a shortcut or
macro to return the cursor to first cell, next line down. Any ideas ?? I have
scoured the Excel help on the web etc. with no luck. I am using Excel 2000.

Jeff

Make sure you save a copy of the file to try this as I am not sure what else
you are doing... right click on the sheet tab and select 'View Code' and
paste the code in the window that pops up.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Columns(4), Target) Is Nothing Then
Target.Offset(1, -3).Select
End If
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Jeff Small" <Jeff Small@discussions.microsoft.com> wrote in message
news:977E29F9-FAAD-4E24-9DB1-86617ADA4C34@microsoft.com...
>I am using a handheld scanner to record asset/serial numbers of hard ware.
>I
> scan 4 cells worth of data (across) and I would like to find a shortcut or
> macro to return the cursor to first cell, next line down. Any ideas ?? I
> have
> scoured the Excel help on the web etc. with no luck. I am using Excel
> 2000.
>

Worked a treat, Nick.

Thanks heaps

Chelle