automate formula
 

Hello everybody. This is the formula that I am working with which is on
sheet 3 of a workbook. Homepage is on sheet 1.

"=IF(MONTH(D1)=MONTH(homepage1!H2),homepage!A2,IF( MONTH(D1)=MONTH(homepage1!H36),homepage1!A36,IF(MO NTH(D1)=MONTH(homepage1!H64),homepage1!A64,IF(MONT H(D1)=MONTH(homepage1!H107),homepage1!A107,IF(MONT H(D1)=MONTH(homepage1!H144),homepage1!A144,IF(MONT H(D1)=MONTH(homepage1!H188),homepage1!A188,IF(MONT H(D1)=MONTH(homepage1!H433),homepage1!A433,703)))) )))"



This works, but when the information on the homepage gets readjusted,
then this formula doesn't work as well. Is there a way to have the
cells be automated where if the information does get readjusted, the
formula will still work?


--
pboost1
------------------------------------------------------------------------
pboost1's Profile: http://www.excelforum.com/member.php...o&userid=11895
View this thread: http://www.excelforum.com/showthread...hreadid=517529

automate formula
 

In A1:B4 enter some numbers
IN C1 enter =A1+B1
Copy this down to C4
In A5 and B5 enter two numbers; C5 should automatically get a formula

You need to have at least three previous entries of the same formula
If the formula changes, it seems you need to have a blank line before the
new formula's first occurrence.

hope this helps
tell us more about your layout
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"pboost1" wrote in
message ...

Hello everybody. This is the formula that I am working with which is on
sheet 3 of a workbook. Homepage is on sheet 1.

"=IF(MONTH(D1)=MONTH(homepage1!H2),homepage!A2,IF( MONTH(D1)=MONTH(homepage1!H36),homepage1!A36,IF(MO NTH(D1)=MONTH(homepage1!H64),homepage1!A64,IF(MONT H(D1)=MONTH(homepage1!H107),homepage1!A107,IF(MONT H(D1)=MONTH(homepage1!H144),homepage1!A144,IF(MONT H(D1)=MONTH(homepage1!H188),homepage1!A188,IF(MONT H(D1)=MONTH(homepage1!H433),homepage1!A433,703)))) )))"



This works, but when the information on the homepage gets readjusted,
then this formula doesn't work as well. Is there a way to have the
cells be automated where if the information does get readjusted, the
formula will still work?


--
pboost1
------------------------------------------------------------------------
pboost1's Profile:
http://www.excelforum.com/member.php...o&userid=11895
View this thread: http://www.excelforum.com/showthread...hreadid=517529

automate formula
 

Thank you for the help you have provided. Unfortunately that is not
what I was looking for. In the workbook, there are several worksheets,
and the formula I have written down is on sheet 6. It refrences the
homepage which is sheet one. I need the automation be when the month
changes it will pull the necessary info from the home page.

The formula again is:

=IF(MONTH(D1)=MONTH(homepage!H2),homepage!A2,IF(MO NTH(D1)=MONTH(homepage!H36),homepage!A36,IF(MONTH( D1)=MONTH(homepage!H64),homepage!A64,IF(MONTH(D1)= MONTH(homepage!H107),homepage!A107,IF(MONTH(D1)=MO NTH(homepage!H144),homepage!A144,IF(MONTH(D1)=MONT H(homepage!H188),homepage!A188,IF(MONTH(D1)=MONTH( homepage!H433),homepage!A433,703)))))))

month(D1) is on sheet 6, the homepage is on sheet 1. Any help would be
appreciated.


--
pboost1
------------------------------------------------------------------------
pboost1's Profile: http://www.excelforum.com/member.php...o&userid=11895
View this thread: http://www.excelforum.com/showthread...hreadid=517529