Hi,

Here is the formula:-

=VLOOKUP(A1,'[master list.xls]lower'!$B$1:$B$58112,1,FALSE)

The problem is I want to paste that formula in every worksheet within
the file, sometimes the file may have 50 sheets, next day could be 60
sheets, following could be 54.

Is there any work to copy and paste the formula above into cells
c1:c5000 in every worksheet available?

First you need to "group' the sheets: click the tab of the first worksheet,
hold down SHIFT, click the tab of the last one. Note how the tabs all have
the same 'colour'
Now Type the formula
Next you must click any one tab to "ungroup"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Stuart" wrote in message
...
Hi,

Here is the formula:-

=VLOOKUP(A1,'[master list.xls]lower'!$B$1:$B$58112,1,FALSE)

The problem is I want to paste that formula in every worksheet within
the file, sometimes the file may have 50 sheets, next day could be 60
sheets, following could be 54.

Is there any work to copy and paste the formula above into cells
c1:c5000 in every worksheet available?