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

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