This assumes that you have a header on row 1 such as book, paper, etc and
are using col A.
right click sheet tabview codeinsert thismodify for column and source
sheetSAVE
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Target.Column < 1 Then Exit Sub
Cells(Target.Row, Rows(1).Find(Target).Column).Select
End Sub
--
Don Guillett
SalesAid Software
"BAZZA" wrote in message
...
i have a spreadsheet and i want to move from coulmn g to columns m t x aa
ac
if a product is in column g e,g if cell g8 equals paper then go to coulmn
t8
or if cell g8 equals book then go to cell x8.
would i need to make a macro or is there a function that excel has that i
could use
thank you.