quoted

Hello, I want to create a spreadsheet where I start with a fixed value, say £100,000 which will grow at a rate of (say) 4%pa for 10 years when I will start drawing down capital at 10%pa. This part of the calculation is easy but what I then want to do is to apply the original 4% growth to the...

Hi, I am trying to automate a way of searching through my bank statement and returning a reference number based on the narrative that appears on the statement (sample data attached). We get hundreds of items every day and the narrative that is quoted on the bank statement is always different...

Have Column P that contains amounts from .01 to 20000 but also can contain blanks, 0, $-, # N/A, possibly others If a cell in Column P has a value of .01 higher, I would like nothing to happen and then review the next cell in P. If it doesn't contain a value of .01 or higher, I would like to...

Hello, I'm really struggling with this one. I believe I need to use an index match lookup combo. The goal is to pull information from sheet 1 into other "forms" (pre-populated sheets) in a workbook. I would like to return all information from column C that has the correct text in columns A...

Hi Gents, Hopefully this is pretty self-explanatory, If you see my code below, I want to only change the Font Color to the text within "societyname" not the actual text quoted before it. How can I do this? This is in MSWord. Hopefully you can help. Cheers Chris objTable.Cell(1, 1).Range =...