Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Need help on Excel function
Name: Green32 Date: April 15, 2009 at 11:44:01 Pacific OS: Windows XP Subcategory: General
Comment:
Is there a excel function that I can use to solve my problem? Help!
In sheet 1 I have the follow data:
Line No Amount MaturityDate 790 500 12/31/10 790 350 10/8/15 790 65 9/6/09 1230 135 6/30/11 3265 653 7/4/12
I want to pick all the data with line No. 790 from sheet 1 to sheet2. I know that I can use filter function and copy paste to sheet 2. But is there a function I can use in this scenario? Thanks!!
Name: DerbyDad03 Date: April 15, 2009 at 12:52:25 Pacific
Reply:
Is the data sorted just like your example or would the 790 be mixed in all over the place?
Is 790 the only number you are looking for or will you be puliing in data from the other numbers at various times?
Would you be willing to use a macro instead of an Excel function?
0
Response Number 2
Name: Green32 Date: April 15, 2009 at 18:33:20 Pacific
Reply:
The No.790 is in the Line No. column, and that is the only number that I'm looking for. If you can show me how to use macro in this scenario, that would be great. Thanks for your help!
0
Response Number 3
Name: DerbyDad03 Date: April 15, 2009 at 21:17:40 Pacific
Reply:
I guess that means that the answer to my first question is "No".
Maybe this will get you started:
Sub Copy790()
For sht1Row = 1 To 1000
If Sheets(1).Range("A" & sht1Row) = 790 Then
sht2Row = sht2Row + 1
Sheets(1).Range("A" & sht1Row).EntireRow.Copy _
Destination:=Sheets(2).Range("A" & sht2Row)
End If
Next
End Sub
0
Response Number 4
Name: Green32 Date: April 16, 2009 at 10:59:03 Pacific
Summary: Excel Formula help I am trying to create a spread sheet for Employees ID with their names. 1) I am creating "sheet1" for New Employees and have to allot them New Employees ID's but while alloting ID's...
Summary: I need help on EXCEL!! When i go to send an email on excel it uses the default email i want to change it so it uses outlook. I need this for work, other computers in my office connected via a lan netw...
Summary: Hi, I need help on excel WHat i really need is to get a Date on a list with a reference date. Below is my example. A- B - C April 19 - March 20 - ...
0 
