macro or function

B

BAZZA

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.
 
D

Don Guillett

This assumes that you have a header on row 1 such as book, paper, etc and
are using col A.
right click sheet tab>view code>insert this>modify for column and source
sheet>SAVE

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
 
Top