Try this. Your attachment is again very different from your previous. Sunny
Hi Erick See if this helps. May I know what you need this for? Sunny
Thanks for your feedback. Glad to know it is finally working for you. Sunny
If that is the case then this should work. It will extract 10 items (you can add more). You will need to adjust the formulas to suit your needs. ...
So you want the last item for OEF 56051 i.e. Mango instead of Banana (1st item) dated 31/12/2017? Give this a try =LOOKUP(2,1/(D6:D12=G3),F6:F12...
Your latest attachment is very different from the first. Please supply the correct info in future. There are two similar OEF no. 56061 with the sam...
Try this formula in cell I3 =VLOOKUP(H3,E6:F12,2,FALSE)
Hi Mitul I have to agree with what Mynda said above. You should learn the basics of VLOOKUP. If you look at your file, the answers you gave in c...
Hi Kenneth You did not specify where the worksheet to be copied is coming from. Same workbook or different workbook? I am assuming it can come f...
Mohamed Saliha Try this in cell H3 =MAX(IF(D8:D14=D3,E8:E14)) This is an array formula so press CTRL+SHIFT+ENTER instead of ENTER Sunny
Hi Carolyn Thank you for your feedback. Glad that we could help. Cheers Sunny
Hi Mitul You can refer toto learn more about VLOOKUP. Sunny
Hi Carolyn I was referring to this (lines 30-32): If InStr(1, AttachFile, "xls", vbTextCompare) Then .Attachments.Add AttachFile End If ...
You could try sending a normal email with an Excel attachment containing the logo plus other graphics and see if they are removed. If they got remo...
Hi David Your description is too brief. If you attach an Excel workbook to an email, there is no reason why any graphic in the file would be rem...