Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting - Macro or worksheet function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Starting a macro with the IF function | Excel Worksheet Functions | |||
Function Macro for Nested IF | Excel Worksheet Functions | |||
How Do I (Macro Function)? | Excel Worksheet Functions |