Pasting a formula to multiple sheets.

  • Thread starter Thread starter M. lane
  • Start date Start date
M

M. lane

I already have a workbook that I want to modify to make it a little more
interactive.
What I want to do is have VLOOKP take user supplied info and return a
calculation to cell D21.
That part I have under control. What I need help with is copying the formula
to cell D21 on every sheet in my workbook. Any help would be appreciated.
 
Rightclick one of the sheettabs and choose
"Select all sheets" (or similar).
Enter in D21

=VLOOKUP(Sheet1!D6,Sheet1!G2:J20,3)

or whatever your formula contains.

Click a sheettab to cancel group editing.


--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
Back
Top