I have 2 reports that are being generated from a system. I need to merge the information in both into one report and unfortunately the system cannot do it...

I’m trying to return a value in cell B2 by matching the values in C2 & D2. The values of C2 & D2 would use a lookup table on a different sheet, named...

The ribbon is a mess. I've tried to embrace the changes but they are just not an improvement. If I could customize the ribbon maybe it wouldn't be so bad....

I went to lunch and when I came back my system was logged off and all of my excel work from this morning was gone.

I am marking learners assignments in excel. Want to know an easier way to check all formatting techniques applied in the worksheet

I have two columns one labeled start date, the other Date Completed. I have a third column where I need to display how many days it took to complete the...

I have a spreadsheet that needs to be converted here at work. The problem is that in a couple of columns such as 'South Dakota 'Illinois 'Nebraska You do...

Hi, i need to write in A1 a number and a macro to search in a folder for a picture with this name and then to display this picture. If i write 22942 and run...

Hi, i need to modify this macro to insert a picture based on a value in cell "A1" Can this be done? Thanks! Sub Add_Picture() '

I have Excel 2003. I have created several drop down boxes. I need to know how to assign a value (ie a dollar amount) to each choice in the list. For...

Hi, i need to open an excel file in html. I have an excel file on my computer that will be updated daily. I have an html file with a link to this file, but...

I would like to enter date in day-month-year in an excel sheet and it should accept accordingly. can anyone please tell me if you know. thanks in advance

Hi, In cell A2, need to take this concatenated text and time string 510n0.240972222222222 and separate it in to cell B2 & C2. The left is the text which I...

The Minimize / Maximize selection which appears top right hand corner when opening Excel has disappeared. If I open a new Workbook the work book has the...

Is there a way to force all cap text within a cell even if the user does not have their cap lock on their computer?

I use a JE template that is linked w/ my SAP software. I recently upgraded to Office 07 and to my surprise, the template doesn't work. My IT dept claims its...

I am using Excel 2007. Many of the cells I am working on are in general format where I store various numbers for analysis. These values change itself to date...

I'm trying to use an advanced filter to eliminate don't care rows from a large data set and the filter is not behaving as I expect. My dataset has 22203 rows...

Hello, I need a formula that looks up a value in row 1 on sheet2 and returns the count of a range in the colmun that matches the lookup in sheet1. For...

Is there a way to make a header in excel run down the side of the spreadsheet (vertical header)?