Transfer cell value from sheet to sheet based on user input (SOLVED)

**Terrydorset** · 02-18-2013, 11:26 AM

Hi
i have two sheets in a workbook one called Quote and the other Price, the formula i am trying to achieve is

On the quote sheet if the drop down box in A4 says 1 then the total at the bottom of the page in L66 gets placed in G41 on the price sheet, the 1 in A4 is a reference number not an adding number so cant be added to the L66 number

thanks

**jeffreybrown** · 02-18-2013, 11:30 AM

Administrative Note:

We would love to help you with your query, but first, before we can proceed…
Please see Forum Rule #1 about proper thread titles and adjust accordingly...

**Terrydorset** · 02-18-2013, 11:37 AM

Jeffrey
thanks for pointing this out to me, but i might add that not everyone that posts here is as well versed in excel terminology, as you and many others here, and sometimes finding the right terminology to put in a title is not easy,
i will try harder next time

Bebo
thanks for your reply, very much appreciated

**Terrydorset** · 02-18-2013, 12:00 PM

Thankyou Jeffery

**jeffreybrown** · 02-18-2013, 12:16 PM

You're welcome

**bebo021999** · 02-18-2013, 01:28 PM

Originally Posted by Terrydorset

Hi
i have two sheets in a workbook one called Quote and the other Price, the formula i am trying to achieve is
On the quote sheet if the drop down box in A4 says 1 then the total at the bottom of the page in L66 gets placed in G41 on the price sheet, the 1 in A4 is a reference number not an adding number so cant be added to the L66 number
thanks

How about in G41:
=IF('QUOTE'!A1=1,'QUOTE'!L66,"")