transfer datas into different sheet using macro?
 

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.

[color:red] SAMPLE DATA: [/color]
[color:blue] columns A-I... [/color]
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

[color:red]Output when run: [/color]
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.

transfer datas into different sheet using macro?
 

did you try using record macro while doing these tasks manually. once you
recrod this you can use the code and modify it to automise the task.

"joana0907" wrote:


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.




--
joana0907

i want to use macro..but i dont know about it.
pls.help me.thanks.