Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
|
|||
|
|||
i want to use macro..but i dont know about it.
pls.help me.thanks. Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting datas in one range based on datas in another range | Excel Discussion (Misc queries) | |||
transfer contents from a cell in previous sheet if the sheet is a | New Users to Excel | |||
How can I transfer a required data from sheet 1 to sheet 2 automat | Excel Discussion (Misc queries) | |||
datas of one Excell sheet will automatically updated in other workbook | Excel Worksheet Functions | |||
Transfer/Copy Sheet, Dynamically linked Sheet | Excel Discussion (Misc queries) |