Copying Formulas

G

Guest

I have a report I need to do on a montly basis. I currently have it saved in
one workbook with 12 tabs: JAN - DEC. Each worksheet uses the same
formulas. Is there anyway I can set up the workbook to use the formulas
automatically or do I have to go in each individual worksheet and input the
formulas?

Thank You!
 
G

Guest

Vicki,
Design the first spreadsheet in Jan with all the expressions. After testing
to see that the expressions are working correctly, copy and paste in all the
others sheet, i.e. Feb-Dec. I hope it works for you.

Darkwah,
Ghana
 

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

How to save formulas when creating templates 4
Freeze Formulas - Replace Worksheet 5
Copy same formula to all worksheets in a workbook 1
Defined Names in Formulas when copying Worksheets in a Workbook 1
Paste Values in linked Cells Only 4
Copy worksheet to new doc w/formulas not referencing previous doc 4
Refreshing formulas automatically 3
Printing a worksheet with and without formulas showing 1

Top