Hi

I'm basically trying to write a macro which looks at a certain range in my spreadsheet (which is a financial Profit and Loss sheet).. the range I could be allowed to name within the macro or something visual that allows me to nominate the on and off border ..)

anyway, basically i'd like the macro to give me the ability to enter a vocabulary of words which when it sees it by running through this range of rows of financial line item labels, it will tag depending on whether its an expense or income item..

so within the vocabulary of this macro i would enter words which are expenses, words which are income related, these are teh two categories..

when it runs and sees a match, alongside the next column it could tag it like "expense2" for when it finds two words which match the expense vocab of the macro.. "expense4" if it matches 4 words within the vocab..

similarly for income.. "income3" for when it finds 3 words matching that in its vocab...

background:


Essentially, in finance, when we often calculate an EBIT or Earnings Before INterest and TAx and as explained earlier, all you do basically is take tne Net Profit Before Tax from the financial statements from companies and you minus non operating income and add back non operating expenses..

This is done to reduce the effect of these income and expenses which are not associated with the ordinary business, ie. interest income is taken out, for expenses it could be expenses relating to a minor part of their business,

any help appreciated.