Dear All, I am in filter mode while copying and pasting in filter mode generated error cannot paste. In filter mode i have column which consists of numerical...

I have designed a model in Excel 2007 to automatically e-mail excel files (2003) to various e-mail addresses. As the model processes the compatibility...

Hello Everytime I type the time in hours, I get time and date in the cell. And I can not calclulate the difference intime -From to. E.g. 0500 -1400 should...

Hi all please help on this formula the result if false =IF('Daily Report'!F21=VLOOKUP(F21,Stock!A3:C35,1),IF('Daily...

i want to change number formatting from 100,000 to 1,00,000.

Hello, I'm trying to open SAP exported .xls file in the Office 2007 Excel, but I receive warning notification "The file you are trying to open, "test.xls", is...

Column J Column K Project Start Project End 1-Jan-06 5-May-10 I need the percent complete as of todays date. Any Ideas? -- deb

I've following situation (a simplified example): I've information (text) in A2:A10 and B1:G1. For each cell in the range B2:G10 I want to CONCATENATE the...

I am trying to simplify my billing for winter plowing. this is what I am looking to do Sheet 1 Customer Name in cell A1 / Description of service say plow in...

Hi Is there anyway following can be accomplished? If I type the last name, the serial numer that goes with the name will be copied from a drop down list? E....

All, I tried recording a macro that edits a cell and copied the formula from in that cell and pasts it elsewhere. When I record the macro - it doesnt...

I want to create two drop down boxes that are depending on each other. For example I have a datasheet with fields like (customers,date,SKUs). I want to be...

In Office XP - Excel - I want to copy a column from one sheet to another sheet in the same workbook. I want the copied links to recognize row deletions and...

Hi, I want to sort rows of cells that are the result of calculations. I select all the data I want to sort and identify the colums etc, but the sort does...

Is it possible to use wildcard characters in the replace string and have them be treated as wildcards instead of text. I have a large spreadsheet that...

I want to pull some information from our SQL ERP system into a spreadsheet. Our parts table has 1000's of records and I only need approx 100 of the part...

I developed an Excel macro but some people can't use it because they don't have the object libraries needed in their Excel application. How do you add object...

Is there an easier way of writing this code? Private Sub Worksheet_Calculate() Application.ScreenUpdating =...

I am not an excel superuser so I'll try to explain what I'm trying to do as efficiently yet clearly as possible. I have tab in a workbook that is labeled as...

PHARR 75039 LACKEY 75041 McFRAZIER 79064 McCULLOUGH 79069 GILMORE 79073 METCALF-EVANS 80084 SEDA 80091 JACKSON 80098 CRUTCHFIELD 80099