General

How do i extract worksheet cells with the same contents?
Office Pro Microsoft Excel . I import three separate lists into one worksheet and want to extract only cells with similar contents to a separate worksheet. ... 20 Apr 2010 21:55

repeating number in a data
hiii sir i am working in a excel with 10,000 number of data...... these are the customers numbers and such time it will be repeated like that First Name 9936615220 9336963152 9818141525 9798415632 9838810086---repeated 9026929808 9336931125-- 9838200296 9336931125-- 9838810086---repeated i want to find an... 20 Apr 2010 21:55

Help with setting a "nof found" statement
Hi. I have the following code: Private Sub CommandButton1_Click() Dim myasset As Variant Dim Assettag As Variant Assettag = UserForm1.TextBox1.Value If UserForm1.TextBox1.Value > 0 Then 'Serial # Set myasset = ThisWorkbook.Sheets("Full listing").Columns("a").Find(What:=Assettag, LookAt:=xlWhole) ... 20 Apr 2010 19:42

stike through font
Hi, Is there a way to filter by a strike through font? Thanks, Ray ... 20 Apr 2010 18:34

Macro problems
Hi I am trying to record a simple macro where if I press alt+d the location moves 7 "page down" key strokes - about 100 rows. However when I record the macro it resorts back to the line number that my macro originally ended up at 7 keystrokes from the top., even if I am 1500 lines down. How can I resolve this? ... 20 Apr 2010 18:34

Populate List Based on Cell Value - XL2003
I have a drop down list of different sales managers. I would like to have the cells below the drop down list fill in the accounts assigned to the sales manager selected in the drop down box. Is this possible? ... 20 Apr 2010 18:34

Pie of Pie
Can anyone walk me through how to build a "pie of pie" chart? That is, I need a secondary pie chart to "explode" a slice of the main pie chart. Excel's help was not too helpful on this topic. ... 21 Apr 2010 13:37

Urgent!! compare 2 columns of numbers for duplicates
I have 2 columns of loan numbers, Scheduled Sales and Actual Sales (1 column is considerably shorter than the other), and I need to find which of the scheduled sale loan numbers do not appear in the actual sale list. I've tried multiple formulas and am not having any luck. I'm running out of time and would lo... 20 Apr 2010 16:32

Network days
Please could someone tell me how to add 17 network days to a network day and have the DATE displayed in a cell and not the amount of network days. Lets say. I recieve an order on a specific day and i have to have that order dispatched within 17 network days, is there a formula that can tell me a deadline date... 20 Apr 2010 16:32

letterhead in excel
can letterhead be inserted into excel? ... 21 Apr 2010 09:28