J
joana0907
Hello,
Im new in using excel macro. Im familiar with Visual Basic 6.But not in
VBA. Im on my intern right now. My boss ask me to make a program using
macro that will transfer data into different sheets. There are thousand
of records and they really need a program for transferring automatically
with one click.
SAMPLE DATA:
columns A-I...
No. of columns (A-I)
10flr M.Door 4/15/2009 1431 29159 Banania, Nelson M. 29159 FUSE
Employee 0
10flr M.Door 4/15/2009 1434 29159 Banania, Nelson M. 29159 FUSE
Employee 9
10flr M.Door 4/16/2009 1158 29159 Banania, Nelson M. 29159 FUSE
Employee 9
11Flr.M.Door 4/16/2009 1651 29159 Banania, Nelson M. 29159 FUSE
Employee 9
10flr M.Door 4/17/2009 1032 29159 Banania, Nelson M. 29159 FUSE
Employee 0
11Flr.M.Door 4/17/2009 1635 29159 Banania, Nelson M. 29159 FUSE
Employee 9
10flr M.Door 4/18/2009 1257 29159 Banania, Nelson M. 29159 FUSE
Employee 0
10flr M.Door 4/18/2009 1300 29159 Banania, Nelson M. 29159 FUSE
Employee 9
10flr M.Door 4/15/2009 1012 63493 Capuyan, Marvin 63493 FUSE
Employee 0
10flr M.Door 4/15/2009 1014 63493 Capuyan, Marvin 63493 FUSE
Employee 9
10flr M.Door 4/16/2009 1225 63493 Capuyan, Marvin 63493 FUSE
Employee 0
11Flr.M.Door 4/16/2009 1911 63493 Capuyan, Marvin 63493 FUSE
Employee 9
Output when run:
1st sheet.
A B C
D
Card No. Name Department Position
29159 Banania, Nelson M. FUSE Employee
Floor Date Time
10flr M.Door 4/15/2009 1431
10flr M.Door 4/15/2009 1434
10flr M.Door 4/16/2009 1158
11Flr.M.Door 4/16/2009 1651
10flr M.Door 4/17/2009 1032
11Flr.M.Door 4/17/2009 1635
10flr M.Door 4/18/2009 1257
10flr M.Door 4/18/2009 1300
sheet 2...
Card No. Name Department Position
63493 Capuyan, Marvin FUSE Employee
Floor Date Time
10flr M.Door 4/15/2009 1012
10flr M.Door 4/15/2009 1014
10flr M.Door 4/16/2009 1225
11Flr.M.Door 4/16/2009 1911
1 sheet per person...Is this possible in macro?
please help me.I really find a hard time thinking on how can I do
this.
Any help would be so much appreciated.
Im new in using excel macro. Im familiar with Visual Basic 6.But not in
VBA. Im on my intern right now. My boss ask me to make a program using
macro that will transfer data into different sheets. There are thousand
of records and they really need a program for transferring automatically
with one click.
SAMPLE DATA:
columns A-I...
No. of columns (A-I)
10flr M.Door 4/15/2009 1431 29159 Banania, Nelson M. 29159 FUSE
Employee 0
10flr M.Door 4/15/2009 1434 29159 Banania, Nelson M. 29159 FUSE
Employee 9
10flr M.Door 4/16/2009 1158 29159 Banania, Nelson M. 29159 FUSE
Employee 9
11Flr.M.Door 4/16/2009 1651 29159 Banania, Nelson M. 29159 FUSE
Employee 9
10flr M.Door 4/17/2009 1032 29159 Banania, Nelson M. 29159 FUSE
Employee 0
11Flr.M.Door 4/17/2009 1635 29159 Banania, Nelson M. 29159 FUSE
Employee 9
10flr M.Door 4/18/2009 1257 29159 Banania, Nelson M. 29159 FUSE
Employee 0
10flr M.Door 4/18/2009 1300 29159 Banania, Nelson M. 29159 FUSE
Employee 9
10flr M.Door 4/15/2009 1012 63493 Capuyan, Marvin 63493 FUSE
Employee 0
10flr M.Door 4/15/2009 1014 63493 Capuyan, Marvin 63493 FUSE
Employee 9
10flr M.Door 4/16/2009 1225 63493 Capuyan, Marvin 63493 FUSE
Employee 0
11Flr.M.Door 4/16/2009 1911 63493 Capuyan, Marvin 63493 FUSE
Employee 9
Output when run:
1st sheet.
A B C
D
Card No. Name Department Position
29159 Banania, Nelson M. FUSE Employee
Floor Date Time
10flr M.Door 4/15/2009 1431
10flr M.Door 4/15/2009 1434
10flr M.Door 4/16/2009 1158
11Flr.M.Door 4/16/2009 1651
10flr M.Door 4/17/2009 1032
11Flr.M.Door 4/17/2009 1635
10flr M.Door 4/18/2009 1257
10flr M.Door 4/18/2009 1300
sheet 2...
Card No. Name Department Position
63493 Capuyan, Marvin FUSE Employee
Floor Date Time
10flr M.Door 4/15/2009 1012
10flr M.Door 4/15/2009 1014
10flr M.Door 4/16/2009 1225
11Flr.M.Door 4/16/2009 1911
1 sheet per person...Is this possible in macro?
please help me.I really find a hard time thinking on how can I do
this.
Any help would be so much appreciated.