Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Macro Question
I have the following formula:
=VLookup(A2,Schedule!B:H,7,False) In my workbook I have 60 worksheets and I need this formula to be entered into every single worksheet in cell A1. Is there a macro to do this? This would save me lots of time. Any help would be great. Thanks, Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Macro Question
You could do it without a macro by grouping all the sheets - but be
very careful. Select the cell with the formula in then right-click on the sheet tab and click Select All Sheets. Then click in the formula bar as if to edit the formula and press Enter. Then right-click the sheet tab and click Ungroup sheets. You should now find the formula has been applied to every sheet. Hope this helps. Pete On Feb 23, 6:58 pm, MikeD1224 wrote: I have the following formula: =VLookup(A2,Schedule!B:H,7,False) In my workbook I have 60 worksheets and I need this formula to be entered into every single worksheet in cell A1. Is there a macro to do this? This would save me lots of time. Any help would be great. Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
question on macro | Excel Discussion (Misc queries) | |||
Using a macro question. | Excel Discussion (Misc queries) | |||
Excel Formula/Worksheet maybe Macro Question | Excel Worksheet Functions |