Hi I would like to be able to highlight a cell to show if a start time in column a and a finish time in column f was over 1 hour. The highlighted cell could...

I want a macro to work for a worksheet name which will always be the same directory and file name but the data inside worksheet will periodically change -...

Hello, I ahve a list of names, with middle initials, that I need to break up. For example the names are formatted like the following: Bayer, Daniel E. I...

I have a column with numbers that represent seconds, for example 109. How can I change this number (109) to this format, 0:01:49

Hi all, I need some help on the following. Assuming on sheet 1 in a workbook, in column A2 to A30, i have the sheet names listed in each cell, how am i able...

I have a pivot table based on an excel worksheet with five columns - Date, Call From (Names), To, Time, and Type. In the pivot table, i am using From for the...

Hi all, Ik column K there will be a continuous range of which all cells have a certain fontcolor, the font color code is, say, 5. The range can be 1 cell up...

I need help with a VBA for creating NON-REPEATING random numbers between 0-9 in Col B4:B13 and Row C3:L3 Bob

I have multiple sheets in my workbook. On the first sheet, I am pulling data from all the other sheets for a comparison. I need to pull in a commission level...

I would like to attach small hand-drawn graphs or formulas to particular cells in Excel. I notice that if you copy an image to Excel, it's not attached to...

Hello, I have created a Pivot Table in a Excel 2007 Template which uses the data from an Access 2007 table. In my Connection Properties I have all the...

Hi All, I have a pivot table which has a "Sum of Amount Authorised" in the data area which is formatted as a number with 2 decimal places. When I double...

I am trying to enter a vlookup function into a cell to look at data in another work book, but after entering the initial lookup reference followed by the...

I still cannot understand why I am the only person on this whole planet who seems to have problems sorting Excel spreadsheets. I simply cannot imagine what it...

I have searched this forum and Excel help and cannot find the answer to my seemingly simple question. How does a user take a file out of exclusive use? We...

I been using excel 2000 for many years now. I have searched the forums and the internet about the other versions I know I do not want to upgrade to 2007. I...

I have a set of data x, y and want to find regions (or ranges) of "constant" slope and I want the value of the slope and range x of that "constant" slope....

I got this message while trying to create a huge workbook. Basically I had an array of 33,000 rows and 60 columns. 50 of the columns were calculationg all...

I need to merge two or more contiguous cells without lossing the data. Also I have cells that I copied & pasted into cells and I am unable to add data to...

I have a series of identical sheets mapping out employee holidays on an individual basis and I want to map them on to a summary sheet. I have posted a simple...