Hello, I have moved from excel 2003 to 2007 and come with a question regarding the way pivot tables refresh is handled. I have several pivot tables in...

I have a userform that is called from inside a sub in a module of a workbook. In order to keep most of the code inside the module, the userform only sets...

hello, I have a large (26 * 750 cells) complex sheet which I want to copy to another sheet in the same workbook. I want to copy everything, formats, values,...

am new to excel &very fascinated about it and would like to learn more about it,discover more secrets about it.my new job demands me to take control&manage...

I have a spreadsheet (.csv) with 1600 products/rows and several columns. One of the columns that has the product descriptions also contains 1600 rows. In...

I have a list of values that have been generated by a formula (IMSUB). I want to be able to show the minimum of these values in a cell but using the MIN and...

Could someone tell me how to make an Excel spreadsheet to track intermittent FMLA? I do not know very much about Excel, so any help would be...

I have several macros they will run from tools, macro, run but not from the short cut keys. I look in the macro editor and the keyboard short cut is listed....

Using excel - a column that have different values. how can count all the values (valvue are numbers such; 16,17 or 18)

hi, in Column M i have a list of results that will go on down the page as values are entered elsewhere, these results will be both negative and positive, i...

I have 2 sheets. They both contain a list of Account Numbers. What I want to do is to have a 3rd sheet created containing only those account numbers that are...

I have a table of data for my Scheduled cutting list that is exported from another program into an Excel Spreadsheet and from this table I would like to be...

That sort of says it. I need to create a list, probably on the same sheet, with the names & birthdays of everybody whose birthday, e.g., falls in October....

I've got a sheet with columns at work date text (sometimes multi-line wrapped) $ nnnn.nn I can wrap text no problem but I hope approximate double...

Please can someone help. I insert a Header in Excel 2007 (it is a one page document with no page/section breaks), type the actual header in, click back on the...

Can anyone assist me please. I was using Lotus script in Lotus 123 but wish to change to using Excel Lotus I was using was :- Sub Click(Source As...

I am using a ledger for simple accounts, Date, Name, Service, Amount and Total. The far right column keeps a running total. I have however omitted some data...

I am using Excel 2002. I have a macro which sends a file to an email address. I have it in the PERSONAL.XLS tool bar with it's own icon so when I export a...

I need to know if there is a way to create a formula that will allow me to enter multiple values in a cell at different times and this formula will sum there...