Template that can point to different Workbooks

JKBeeman

New Member
Joined
Jun 10, 2014
Messages
2
I am in charge of metrics for my company and we gather a lot of different information from different sources. Currently I have created a workbook that has 5 different data worksheets and 7 worksheets that calculates and displays the information. I am trying to create a Client Template where I can point to our large report and search for just the client specific information without having to dump all of the raw data into the second workbook. The issue I'm running into has to do with the fact that this is a report that is run every month, and is renamed every month. So the Client Template needs to be able to easily point to a different workbook (with the same worksheet names) and calculate the data. Is there an easy way to do this or am I going to need to write a massive VBA macro that manually enters each of the 1200 formulas?
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Forum statistics

Threads
1,223,099
Messages
6,170,108
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top