transfer datas into different sheet using macro?

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.
 
S

Sagar

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for Copying pasting between different spreadsheets 4
Loop ? 6
Loop ? again 11
Send multiple emails based on employee using Microsoft Access 2007and Outlook 1
Send multiple emails based on employee using Microsoft Access 2007 and Outlookþ 4
Transpose columns to rows using first columns repeated. 7
Charting 3
Line Charts or ? 2

Top