HI, in MS EXCEL 2007 I have a wprkbook with several worksheets pages. I am
creating a summary worksheet page within the multiple worksheet workbook.
Here is what I have entered in the summary worksheet: In cell AB1 I have
entered the following formula =if(sheet1!$A$8=1,sheet1!$D$9)
Copy/paste or copy/paste special/formula doesnt copy and change the formula.
I want to copy the formula =if(sheet1!$A$8=1,sheet1!$D$9) into the following
cells AC1,AD1,AE1,AF1 and have the formula to read as follows:
In cell AC1 =if(sheet1!$A$8=1,sheet1!$E$9)
In cell AD1 =if(sheet1!$A$8=1,sheet1!$F$9)
In cell AE1 =if(sheet1!$A$8=1,sheet1!$G$9)
In cell AF1 =if(sheet1!$A$8=1,sheet1!$H$9)
Is there a way to copy and paste this formula?

--
Thanks

Hi

Try using relative reference in your formula for column D in AB1
=IF(Sheet1!$A$8=1,Sheet1!D$9)

and drag across to AF1


--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis




"Steve" wrote:

HI, in MS EXCEL 2007 I have a wprkbook with several worksheets pages. I am
creating a summary worksheet page within the multiple worksheet workbook.
Here is what I have entered in the summary worksheet: In cell AB1 I have
entered the following formula =if(sheet1!$A$8=1,sheet1!$D$9)
Copy/paste or copy/paste special/formula doesnt copy and change the formula.
I want to copy the formula =if(sheet1!$A$8=1,sheet1!$D$9) into the following
cells AC1,AD1,AE1,AF1 and have the formula to read as follows:
In cell AC1 =if(sheet1!$A$8=1,sheet1!$E$9)
In cell AD1 =if(sheet1!$A$8=1,sheet1!$F$9)
In cell AE1 =if(sheet1!$A$8=1,sheet1!$G$9)
In cell AF1 =if(sheet1!$A$8=1,sheet1!$H$9)
Is there a way to copy and paste this formula?

--
Thanks