Summary: how can i increase a cell reference by one row automatically. The summary worksheet references individual worksheets. I need the summary worksheet to...
Summary: I have an extremely simple Excel spreadsheet that I use to keep track of my running. It's columns are: Date, time to run a mile, time to run 2 miles, ...
Summary: I have an Excel 2007 document with values on one sheet that I need to insert into an existing Word 2007 document into different places. I would like t...
Summary: Hi Guys - Is it possible to utilise the indirect function or a means using VBA to populate the listfill range of a combobox - this is also referred to...
Summary: In column A I have a list of items that all start with an A (a1 a2 a3 etc) In column B I want to use “lookup” to generate a sales report from anot...
Summary: I am a novice excel user, I have a spreadsheet that can be updated at any time by hitting an update button. I want to capture data that was created o...
Summary: Is there any way to assign a comment to a value instead of a cell? for instance have a name from a drop down list but when you hover over the name sho...
Summary: I am pretty new to IF statements in the context of excel and have no idea how to complete the latest one I need. Basically Its like this: The are thre...
Summary: Hiya, I'm trying to colour a cell when a different cell meets a certain criteria eg. a girl is in the school house called Aidan which is yellow her na...
Summary: Dear Gentleperson: I have exported data -- dates in particular -- from a source that has the date format as M/D/yyyy (e.g.. 11/12/1987) as shown in th...
Summary: I have an excel list. There are different categories of business types. total of 17 different category. Problem is that most of the categories have fe...
Summary: I need to have the value of one cell change depending on the value of a second cell. I figured this one out a few months ago, and I know it is not bra...
Summary: I understand the rank formula and i have that in my worksheet. What I am trying to do is break the tie using a different column. is there a way to d...
Summary: I am using the Data-filter-Auto filter function to filter data based on 3 different criteria in Excel. Then I need to summarize one row of data. Thi...
Summary: I am trying to figure out how to change the language of Office 2007. Here is the setup All desktops/laptops are XP They are running Office 2007 The de...
Summary: I have created the excel file in excel 2003 and transfered it to excel 1997 in my 2nd computer. However when i tried to save the file in excel 1997, i...
Summary: I need to input a negative time value into a time formatted cell in excel. I have a cutom cell format: [hh]:mm;[Red] -[hh]:mm This works perfectly for...
Summary: hi guys, i have this problem while doing excel. im not sure if this is do able, but if anyone got the solutions, i would be greatfull I need to copy s...
Summary: I am using Microsoft Word 2007 and every time I open a new document the cursor is centre justified. From a search on the Internet I gather this has s...
Summary: I have a client that needs a formula to calculate the total cost of meals on monday thru friday... easy enuff =(a2+b2+c2+d2+e2) however, on certain da...
Summary: I need to take time from a stopwatch (00:00:00 = min:sec:hundreths) and divide it into an hour. Cell F8 (load time - 04:56:10), Cell F10 (run time - ...
Summary: Is it possible to search appointments by category in Microsoft Outlook 2007? For example, if I wanted to find all appointments on a calendar that are ...
Summary: I have a user who was using Outlook 2003 on Windows XP SP3. She has some distribution lists (DL) in her Contacts folder with a lot of entries. Most ...