Paste formula in numerous worksheets

S

Stuart

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?
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy columns and paste with blank column between 5
hide multiple worksheets based on a formula value in one cell 1
Copy and Paste Charts as Picture in Different Workbook 12
Copy/Paste Values code 12
merge worksheets 3
Copying Filtered Data from multiple worksheets 3
= Today()+1 into Sheet1, Sheet2, and Sheet3 2
Macro for Multiple Worksheets 6

Top