Excel 2007 : Linking Cell to another containing drop down list

I have two worksheets in the same workbook. I have some data in cell AG7 in worsheet #1. In worksheet #2, I have the following formula entered in cell N7 and it pulls the correct data from AG7 with no problems: =IF(OrderForm!AG7>0,OrderForm!AG7,0)

If I try to do this same exact thing with the cell next to AG7 it does not work and the big difference is in AG6, I have a drop down list with 5 choices in it. Can anyone help me link cell M7 on worksheet 2 to my AG6 on worksheet 1 using the drop down list in AG6? I am totally stuck.

Thank you.

are you changing your formula to
=IF(OrderForm!AG6>0,OrderForm!AG6,0)

Originally Posted by grizzly6969

are you changing your formula to
=IF(OrderForm!AG6>0,OrderForm!AG6,0)

Yes i changed the formula to the correct cell numbers. It just does not work? Still stumped.

Isn't there anybody out there that can tackle this one for me? I am getting desperate for some help Thank you in advance.....

Hi,

i have fixed number of columns and I want to change the number of rows depending on input data available. how can achieve this.

Thnaks in advance