Put this macro into a regular module in the Bif file to get the number from the
data file
Option Explicit
Sub GetID_SAS()
Dim lr As Long
Dim myid As String
Application.ScreenUpdating = False
Application.DisplayAlerts = False
myid = InputBox("ID to get, ie 1000003")
Workbooks.Open Filename:="Total Order data.xls"
lr = Cells(Rows.Count, 1).End(xlUp).Row
Range("A1:M" & lr).AutoFilter Field:=1, Criteria1:=myid
Range("A2:L" & lr).SpecialCells(xlCellTypeVisible).Copy
ActiveWindow.Close SaveChanges:=False
Range("c4").Select
ActiveSheet.Paste
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
From: Brajesh Kumar Porwal
Sent: Thursday, August 11, 2011 1:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Split data order wise New Excel workbook
Hi Expert,
I urgent need your help, because i want to create macro for split data. I have
more data in excel workbook so I want to split data order wise New Excel
workbook. Please find enclose example file.
--
--
One Team One Dream One Goal
Warm Regards,
Brajesh Kumar Porwal
E-Mail :- brajeshkumarpor...@gmail.com
7503020750,
"We can't Spell S_ccess without U"
Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
