Hi, Does anyone know why either of my Row or Column Autofit selection (in Format)does not work. I have to individually set all the row heights manually. Any...

when getting the dropdown menu from filter I sometimes would like to make more than one selection or even exclude just one kind. I thought this could be...

my source of the pivot table has a data field with 81 words, yet only 44 words show up in the results table. How can I get the entire 81 words in the pivot...

Hi! I really need help to arrange this formula!! I work with students in a school and need to count a certain value if a different cell has a certain...

how do i set up in my database that when a user is entering infor in a column in excel, it will tell if there is a duplicate number. I do not want duplicates.

I have 3 columns that have date/time on the first column and device status on the 2nd column and calculated Time difference on the third column. I have ...

How do I create a new toolbar with different tickmark buttoms? I want to create a tool bar wherein several different buttoms would be tickmarks. Then I would...

I have a excel model that runs company scenarios. It currently has about 90 sheets and I am hitting the difficultly of calculations not updating. ...

I have a macro that inserts a line, how can i modify it to insert a line by a number in a cell corresponding to the row number? ex: J8: "22" Inserts a new...

Good afternoon! I have a macro that refers to multiple sheets. As it goes along in the process, the sheets flash on the screen. This has caused some of the...

Has anyone run across an instance of the auto recovery function running twice in a row? It is set to recover every 30 minutes, but appears to run again after...

Hi, I need to transform a date to week date , for example: 10/11/05 to Tuesday Is there any formula can do this transform? Thanks in advance -- Meme

I need a help with formula to detect duplicate invoices (payments) listed in my column I2 through I8317. In a separate column (next to it) I want the computer...

I have a multiple worksheet workbook that pulls data in from several other worksheets in workbooks. Each worksheet in my workbook is consistent in look and...

I have pivot tables that I update weekly with new data. Unfortunately, the prior week's options are included in the updated drop down lists. The old data is...

I've got a sheet, in which column "D" is just numbers, fed real-time by mulitple other sheets in the same workbook. Is there a way so that at say 5am every...

I need to filter out information from 1 sheet to another to take out duplication. Does anyone have a formula that I can use?? I need it to sort out 2 columns...

Is there a way to highlight certain words or sentences within Excel. I don't want to hightlight the entire cell 9I know how to do that, I just want...

I have a workbook with 3 sheets. Sheet 1 is the design and dimensions where the information is gathered. Sheet 2 is a complete material list with...

my code is: Sheets("Sheet 1 (2)").Select ActiveWindow.SelectedSheets.Delete How can i hace it delete the seleted sheet, not always 'Sheet 1...