Hi Bob - that looks interesting in terms of setting fonts and formats to the worksheet - I shall take a closer look and see how useful this is to me.
Still looking for something that will allow me to add predefined 'boilerplate' sections which could include text and formulas etc...
Thanks...
Hi
In word I have an option to use something called quick parts which is a effectively a powerful version of the clip board in that I can store text and formatting as well as data that is relevant to the document (page numbers, authors etc.)
Is there something like this in Excel?
I know I...
Thanks for clearing that up Luke - I was starting to panic there!
SirJB7 - jury is out on that one.
Luke M - thanks for the list - never used DOLLAR, and I know of FV, PF and NPR - but generally never use them, so would need to refresh my memory before using them in anger - otherwise you...
Well that's encouraging as a straw poll taken of my work colleagues seemed to show most were in the 1-10 mark that they could use without thinking.
My guess is that as this is an excel forum most people should know quite a few, but they are keen users of excel, where as my colleagues are just...
I was pondering the meaning of life the other day (OK I was bored), and got around eventually to listing how many Excel functions I knew, and how many I could type in without reference to the help system (e.g. could type them in off of the top of my head, including all options - eg...
Hayden - I have to say I am not sure what you are trying to do exactly, as you seem to be selecting or already have the country and state information and only need to look up the capital of the state - assuming that you don't have two capitals of the same name, in different countries or states...