Thanks but I think I tried that. To be clearer:Formula for Cell F9: If contents of cell C9 = contents of cell C8, then copy contents of cell F8 to F9, if not, dont change contents of cell F9. Does that make sense.
Hey you guys are GOOD!! What a great service.
Waiting ... Melb, Aust
didnt understand that at all, didnt understand the download, can you please be clearer
yep did that, how do I put that macro in an excel cell??? Do I type in this below to Cell F9? Then how do I run it? We are dummies out here, not experts, you need to explain specifically. Thanks
If Range("C9") = Range ("C8") Then Range ("F9") = Range ("F8") Else Range ("F9") = "" End If
Terrific Richie, done, it is 527322 Codings May 7.
Column C has a series Customer codes in, repeated a number of times: EG K083, 36, K013.....the top row has - in most cases - an entry in Column F. eg K083 has none, 36 has a B, K013 has a D, A484 has a D....
I simple want to cc the entry eg in F8 to F9 & F10 so all Col C Cust code lines have that B in Col F.
Then copy the formula/macro down the 2754 rows so each Col. C cust code has the same Col F entry in each of its 2 or 3 or 4 rows.
Clear as mud??
well Richie I dont get it, just wont work for me, a waste of my money, goodnight
I appreciate that but I cant get it to work. Why in your sheet you sent back, did you put the formula up in cell D1 ilo correctly into F9? Its weird, in D2 it gives the correct result for cell E18, but if I set it up in F9 - WONT WORK !!!!!
Richie! This is what I downloaded – I downloaded & saved as Codings…-2…. the formula you put is in D1!! F9 is EMPTY. What is going wrong here?
Sorry, it’s a stupid site, sends me round in circles.
Mate I downloaded it three times. On my download believe me, your formulas is sitting up in D1. When I write the formula up in F9 it returns 0. It seems to work in other cells like E18, I don’t get it.
Pls one more time – do it again, save the spreadsheet as CODINGS-10, send it to me with the formula correctly in F9, referring to C8, C9, F8, F9 & I will try one last time to see if it returns value C as it should.
Thanks for your effort but something is haywire, Im not that silly.
I give up, going to bed, not happy, will look at the sheet Codings-10 in the morning, thanks
This is a weird one. I dont thjink your formula works. eg if you cc it down, when it gets to a different entry in Col F, eg a D..., and the Col C condition is not equal, it will override the D with a blank. But in such cases I want the cell entry left unchanged as D - so the cc of theformula to the cell below will then run the D's down until the next time the Col condition changes. I have emailed youy that sheet again, pls study it, run it & see if it can produce the same as the bottom half!!
I dont want to give up but I HAVE to solve this problem tonite. I have emailed you separately with a spreadsheet that clearly explains it. Cant you just email this spreadsheet back with a formula in col F & G that can be cc'd down & does what I want as explained in lower half of my sheet?
ok I just emailed it to you, I will also upload it ... here's hoping
Yep ... file 470160. Richie I really appreciate your efforts, pity we cant do this face to face, Im happy - once we do fix it - to pay you double or whatever for your time. But it has to work!!!
NO ...... If you cc that formula in F5 down, it now works for F6 & F7 ( fixed the blanks, thanks) - but when it hits F8 where the content changes ( AND C8 code changes ), it stuffs up - it overrides the D with a B! & gives a circular ref warning.
It should just return the entry D... then cc further down, D's down to F15 then a series of F ... so that formula does not do the job.
Sorry Richie you just didnt even carefully read what I wanted, & it just doesnt work, so the service is ok but the result is no good. I thought I made it very clear what I wanted. But you have not addressed what I wanted at all, so I give up, I have gone elsewhere. Try what yo usaid yourself! As soon as it gets down a few columns, it produces a wrong resulyt.
Why cant you uunderstand what I want? I sent you a mini spreadsaheet with original PLUS what I want formula to do. Just LOOK at my example! Your formula DOES NOT produce the same. So forget it.
"But type it in F9 yourself Owen=IF(C9=C8,F8,"")Put that in F9, then enter in values in C9 and C8 as the same and you see it work.Let me know if you have any difficulties please"