<font size="2">I'm trying to formulate the following in Excel: - </font></p> <font size="2">If A1(tab1) = yes then</font></p> <font size="2"> copy A2(tab1) to A1(tab2)</font></p> <font size="2">Else</font></p> <font size="2"> nothing</font> </p> <font size="2"></font></p> <font size="2">Anyone know how this would be done?</font></p> <font size="2">Cheers,</font></p>
Sounds like a circular reference problem Yopu are using A1 twice - is this correct?</p> Or am I talking ******.</p>
RE: Sounds like a circular reference problem <font size="2">I got the circular reference error but no idea what the hell it means. I am using A1 twice but they are on different tabs or worksheets as Excel calls them. Basically need to know if there is a 'copy' feature within Excel. I.e. copy a1(worksheet1) to a1(worksheet2).</font></p> <font size="2">Think i'm talking ****** now, I need a drink!</font></p>
If it helps There is a way to do it, but my Sams guide to Excel is currently in a packing crate - have you tried the microsoft excel support site from microsoft.com?</p>
something along the lines of this.... =IF(Sheet1!A1="YES","=Sheet1!A2"," ") To test this out, open an excel sheet, in A1 (Sheet1) put - YES A2 (Sheet1) put - 50 A1 (Sheet2) put - the above formula... It displays nothing if A1 is anything other than "YES", but for some reason, displays the formula rather than 50 if it does say yes. So nearly their!!!! I'll keep trying
revised formula the above formula has too many "" it should be =IF(Sheet1!A1="YES",Sheet1!A2,"") This will make the cell on sheet 2 always update to the reference on sheet 1 A2. Is this what you want i.e. a dynamic reference that changes whenever the source cell changes.
RE: revised formula well done lad.... I knew what was wrong, I used the formual wizzard, and it kept putting in the extra "", so, I was 90% right, but never thought of just amedning it without using the wizzard DOH!!! anyway, got their in the end
