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.
 

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

a if calculation help 2
naming 15
Vlookup, replace true text result with "X" 5
Turning N/A cells to blank Cells 4
If cell not null use that value 1
I don't understand this formula {=TABLE(d19,d21)} - please help 6
using a cell's reference to return a value. 3
Copy/Paste cells containing only numbers with .50 in it 2

Back
Top