I am sure people on here will know a better way, but until then....... If the number of Funding Sources is unlimited then i think you will need to ...
Hi Sholtan I am happy to help but my time is limited, i have started you off with the automated import into Excel. Can you figure out the logic to ...
hmmm, it created 6 for me - do you know what one is missing?
Hi Sholtan This is quite simular the last few questions you have posted in the forum - have you tried to create it yourself? While the actual pr...
I thought that is what i done, except the total showed where there was any number (so 2645903 showed at 1 & 2 (rows 2 & 5). If you only wan...
Hi Jason Do you have a currency column? then you could do and if formula so GBX/100 Can you attach an example workbook so we can take a look? ...
So you want column W to display the total of column O multiplied by the number in V? If so try =IF($V2<>"",SUMPRODUCT(--($V$2:$V$16<>""...
Its not perfect or the most efficent as i have tried to keep your formating and i dont want to break anything else, but i have made a loop on the unsu...
Please up load an example workbook rather than paste in text, it makes it much easier to review Purfleet
Sounds like you have the data setup as a proper excel table Purfleet
So the supplier is at the top row and the Maker of the product is to the left of the price? Personally i would recommend changing the layout of the...
Pretty much anything can be automated in Excel. To make things easier can you mock up a workbook of what you are after can post it on here and i wi...
Much better if you add a workbook as an example rather than text. I assume the letters are the supplier? This will get the letter (you could use a ...
Hi Kev You can wrap what you are looking for in * (wild card) Index & match - =INDEX($B$2:$B$14,MATCH("*"&E2&"*",$A$2:$A$14,0)) O...
Hello Are the emails saved as seperate .msg in a folder on your harddrive or are they still in outlook?