Use "master formula" in multiple workbooks?

jbeaucaire

Well-known Member
Joined
May 8, 2002
Messages
6,012
I trust you will read through the code and make any corrections needed before trying it, like to the fPath variable, yes? ;)
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

feetimo

New Member
Joined
Mar 14, 2010
Messages
18
It works! What's the required code to except a specific worksheet...all my workbooks have a "LOOKUP" sheet that contains lookup-type information. It would be good if the formula left this sheet alone.
 

jbeaucaire

Well-known Member
Joined
May 8, 2002
Messages
6,012
Add this and edit to suit:
Rich (BB code):
        'Copy in the formulas into each sheet
            For Each ws In ActiveWorkbook.Worksheets
                If ws.Name <> "Lookup" Then
                    LR = ws.Range("A" & ws.Rows.Count).End(xlUp).Row
                    NewFormulaRNG.Copy ws.Range("E2:G" & LR)
                End If
            Next ws
 

Watch MrExcel Video

Forum statistics

Threads
1,089,760
Messages
5,410,270
Members
403,305
Latest member
tray2014

This Week's Hot Topics

Top