macro or function
 

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.

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.

a macro
--
Gary''s Student


"BAZZA" wrote:

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.