Copying formulas

**Vetequk** · 03-17-2009, 01:39 AM

Hi again, I was wondering if there is some kind of code that could be made up to copy formulas. I have 2 sheets in a workbook where i would like cell G8 on sheet 1 to equal the value on A11 sheet 2 & G9 to equal A12 and so on down the sheet. The problem is that G8 are 3 merged cell so every time I try to use autofill the reference number jumps by 3.
The formula in cell G8 is

Please Login or Register  to view this content.

I have attached a copy of the sheet.

Thanks

Vetequk

**royUK** · 03-17-2009, 02:45 AM

That's one of the reasons not to use Merged Cells. Why do you need merged cells, use

**DonkeyOte** · 03-17-2009, 02:52 AM

Not sure I follow entirely, perhaps the below is along the right lines ?

Please Login or Register  to view this content.

**Vetequk** · 03-18-2009, 12:07 AM

DonkeyOte
That has done the job, I do not understand how the code achieved it so I will be doing some reading tonight.

RoyUk
The reason for using merge cells is because this is not a calculation only sheet it is also a user form with elements of data that the user inputs into the form.

Thanks

Vetequk