Special Paste Add Link to Formula?

**mdeisen** · 09-13-2010, 07:23 PM

I have created a very large Excel Workbook with many worksheets and many cells of information.

I have recently added a new worksheet called "Adjustments" to the workbook, it is laid out in the same fashion as the other worksheets in the book. Currently in the same workbook I have another spreadsheet called "Sales". I want to add information I have in "Adjustments" spreadsheet to the formula I have in "Sales" spreadsheet.

For example, currently in Sales I have a cell that reads "=DEP!C3-NEP!C3" I want it to read "=DEP!C3-NEP!C3+'Adjustments'!C3"

I have 1000s of cells so I don't want to go through each individually to link them all. I've tried paste special addition, but all this does is just add the raw number from "Adjustments" tab. I need adjustments to be dynamic not a static number.

Any suggestions on how to easily add a cell link to the end of a formula?

Thanks!

**teylyn** · 09-13-2010, 08:03 PM

Hi,

For formulas that are structurally the same, you can copy and paste the cells.

For example, if you copy the above formula down, it will adjust from

=DEP!C3-NEP!C3+'Adjustments'!C3

to

=DEP!C4-NEP!C4+'Adjustments'!C4

If all formulas are fundamentally different, I don't really see a way to change them automatically. VBA might be a way to go, but it would still be a piece of work.