Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros
I have many different cells in one workbook. They are split into monthly
totals. In a seperate workbook i am using a vlookup formulae to reurn the information. How can i record a mcro to change the following formulae from =VLOOKUP(B86,'[PLAYERS SHEET.xlsx]Sheet1'!$1:$1048576,37,0), where i'm looking fo column 37 to the same but looking for column 50, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros
say the formula is in cell Z100
Sub james() Dim s As String Dim Z As Range Set Z = Range("Z100") s = Z.Formula s2 = Replace(s, "37", "50") Z.Formula = s2 End Sub Use a simple loop if you have other cells to change. -- Gary''s Student - gsnu200816 "James" wrote: I have many different cells in one workbook. They are split into monthly totals. In a seperate workbook i am using a vlookup formulae to reurn the information. How can i record a mcro to change the following formulae from =VLOOKUP(B86,'[PLAYERS SHEET.xlsx]Sheet1'!$1:$1048576,37,0), where i'm looking fo column 37 to the same but looking for column 50, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros: can you copy macros from one doc to another? | Excel Discussion (Misc queries) | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions |