Formula Macro Question

M

MikeD1224

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
 
P

Pete_UK

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
 
Top