I have a database in a workbook which is increasing on a daily basis. the column consiste of e.g Date country T.operators Rm Type Qty Amount etc I have a...

I'll try this again as I accidentally hit the enter key after typing the subject. In a spreadsheet I have all of my staff listed by their abbreviated names...

I am creating a 'Parent' Workbook which lists a whole load of documents which are hyperlinked to PDF files of the actual document. I need to create a few...

I am developing a tracking calculator for an overall process. Within the overall process, there are 3 steps which are completed. These steps can be completed...

I have some strings like this (some are as long as 4000 separated values): A;AA;AAI;AAP;AAPL I am looking for a way to convert these strings into column data...

In worksheet I want to insert more column, but I can't do d same beyond grid IV (Ato IV). Is there any way? so that I can insert more columns as I...

I am trying to put together a spread sheet that will allow me to type a specific letter and a 9 digit code will appear once I enter the letter.

-- John

I was attempting to share a workbook. I added a password to protect locked cells. The system somehow made me an exclusive user and even i am unable to...

How do I sort the pivot table field list? It looks like the soft order is always the order of the data source. The related radio-buttons in the...

End result is to compare prior year numbers to current year to date sheet 1 has the following columns-- sheet 2 has history-each month totals for a number of...

How do I get the dimension names in the "pivot table field list" sorted by the translated names? The pivot table field list contains: - one measure-node -...

Hi When i paste special from one cell into another, it advances the cell reference and i just want an exact match i.e. A1 formula ='Feb 2010'!C18 but when i...

Hello, I have a sheet with date (some have the same date), order# (6 numeric digits, etc.. I want to add another column to look if there are more than one...

I need to track turn-around-times, date & time, excluding Sunday. The end result needs to be the number of dates to completion. In this case the result...

excel currently sorting numerical info into numerical/alphabetical order as 1,10,100 etc. instead of 1,2,3 etc. Anyone know how can set to resort as 123?

Dear Experts I have following code,i need to copy desirde rows to new file (r.xls) on sheet 1. This code is able to copy desired rows from active sheet to...

Dear experts I have following code which Mike has wroted, i need to change this macro, this code is able to copy several rows (based on values on CoLG) to...

Dear experts I have following code which Mike has wroted, i need to change this macro, this code is able to copy several rows (based on values on CoLG) to...

I have a worksheet for a meeting that I am trying to get to where I can use the formula's and it will calculate as soon as the data is pasted from another...