Fast Solution to Problem: Dynamically replicating formualas across multiple worksheets |
Dynamically replicating formualas across multiple worksheets
I have set up multiple (12) worksheets which should have the same structure in terms of formulae, but which will each contain different data.
Although I can use Copy and paste special to copy the formulae to each of the worksheets, it would be much easier to have a TEMPLATE worksheet which holds the formulae, with a dynamic link to each of the other worksheets, so that the formuale in the other
worksheets are automatically updated when I make a change to the formulae in the TEMPLATE worksheet.
Could you point me in the right direction for setting up dynamic formulae links, please?
Alan Hilliar
Bovis LendLease
Harrow, England.
Keys to the Problem Dynamically replicating formualas across multiple worksheets
Hi Alan
Seeing that "magic number" 12, makes me think you are creating 1 sheet for each month.
Why not have all the data in one sheet, with an extra column denoting Month?
That way, there would only be one set of formulae to maintain (and protect via locked cells), and you can gain a "view" of any particular Month's data with Filters and / or Pivot Tables.
Having all data in one sheet is so much more useful when it comes to making any subsequent analysis.
Regards
Roger Govier
"Alan Hilliar - Bovis LendLease UK" wrote in message news:*** Email address is removed for privacy ***...
I have set up multiple (12) worksheets which should have the same structure in terms of formulae, but which will each contain different data.
Although I can use Copy and paste special to copy the formulae to each of the worksheets, it would be much easier to have a TEMPLATE worksheet which holds the formulae, with a dynamic link to each of the other worksheets, so that the formuale in the other worksheets
are automatically updated when I make a change to the formulae in the TEMPLATE worksheet.
Could you point me in the right direction for setting up dynamic formulae links, please?
Alan Hilliar
Bovis LendLease
Harrow, England.
________ Information from ESET Smart Security, version of virus signature database 5430 (20100907)________
The message was checked by ESET Smart Security.
http://www.eset.com
________ Information from ESET Smart Security, version of virus signature database 5430 (20100907)________
The message was checked by ESET Smart Security.
http://www.eset.com
Roger Govier Microsoft Excel MVP
Make Sure that your System Meets the System Requirements
Microsoft Windows Requirements :
- 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
- 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
- 16 GB available hard disk space (32-bit) or 20 GB (64-bit)
This error can be due to some configuration requirements for you system. If your PC hardware is not up to par, then make sure you update where necessary before continuing.
Recommended Method to Fix the Problem: Dynamically replicating formualas across multiple worksheets:
How to Fix Dynamically replicating formualas across multiple worksheets with SmartPCFixer?
1. Download Error Fixer . Install it on your computer. Click Scan, and it will perform a scan for your computer. The errors will be shown in the scan result.
2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.
3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.
Related: Changing Thing On My Site - Cannot Visit My Site To Change Things,Cant Access Wireless Manager Through Computer? Laptops All Working Fine. The Service State Is Highlighting STOPPED When It Should Read RUNNING__,Changing Default Font In Comments,Cell Formula To Check If Sheet Exists In Workbook,CD\DVD Drive Not Enabled,Computer Runs Slowly For 10+ Min At Startup - Is DWM The Culprit?,Computer Takes Approx. 15-20mins To Start Up. Slow When Actually Running Programs Such As Word Etc,Conditional Formtting 2007 If Statement,Conditional Format Vlookup,Computer Lags When Internet Gets Low,Customer Experience Improvement Program Upload,Defrag Not Running Because Of Chkdsk,Delete Windows Off Spare Drive,Data Card Not Getting Detected,Dell Inspiron 1545 And Windows 7,Mapping The United States - Mexican Border,Sourcing Home Remedies For Yeast Infection Problems,Is Liposuction Surgery For Me? 16 Points To Note,Various Ways You Can Make Money Writing Articles From Articles Directories,Compliments - A Very Powerful Dating Tool!
Read More: Fast Solution to Problem: Double clicking .xlsm files open in Excel 2003 even though Excel 2010 is installed - Citrix,How to Fix - Display All Data with using a data validation?,Fast Solution to Error: drive will not defragment - stops analysing at 61% and will not go any further,Troubleshoot:DRIVER IRQL NOT LESS OR EQUAL (igdkmd64.sys) Help please Error,How to Fix - during indexing i had a power failure.now programs are gone or won't work?,Dell stages not working, -will play 3 songs and stop, will not allow set up for playlist... goes to not responding. Doing the same in Picture file. How do I fix this problem?,Deleting empty cells with a for loop,Do I need Microsoft Silverlight?,Doubt with WebService,Driver irql not less than or equal tcpip.sys