Excel first timer Macro user

[ZaXaZ]

Hi, this is my first time having the need of a macro and it´s a bit overwhelming.
i started a new work and lets just say that no on here is very sharp when it comes to pc or what you can do with it most of the times.

so i get a list of car Models and types of the model in a txt doc witch most of the time is very long 100+ sometimes 10+ or 1000+. but it´s given to me in a very bad form and takes quite some time to do manual ea time..

and any one here help me with making a macro?

here is a very short example, of what i get to work with, and what i need to end up with
Model: Type
405: 101 103 121 123 201 221
900: 911 912 913 917 918 919 922 934 936 937 938
list goes one feels like its endless..

i need it to be made to
type Model
405 101
405 102
405 121
405 123
405 201
405 221

900 911
900 912
900 913
900 917
900 918
900 919
900 922
900 934
900 936
900 937
900 938

 

[Michael M]

They seem to work as required, what is the issue you are having ??
I used this file, and placed it in Column "B" of the workbook

https://www.dropbox.com/s/56mcptu16f...once..txt?dl=0

You are using Columns "B" and "C" as per your image in post #7, aren't you ???

 

[ZaXaZ]

They seem to work as required, what is the issue you are having ??
I used this file, and placed it in Column "B" of the workbook

https://www.dropbox.com/s/56mcptu16f...once..txt?dl=0

You are using Columns "B" and "C" as per your image in post #7, aren't you ???

Getting file not found on your drop box link.

i start with B2 and C2 sins i used that on the pic. and it seems that the macro was made for that?..
do the start include or exclude the text Model Type

 

[Michael M]

The dropbox link was the one YOU provided, and as I said, that was the file I used to test the code !!
No they don't include the text !

 

[ZaXaZ]

The dropbox link was the one YOU provided, and as I said, that was the file I used to test the code !!
No they don't include the text !

My bad i hoped copy/pasting the links would work aperently it dit nok..
here is the full link hope thos works.
Excel doc link
https://www.dropbox.com/s/gsvgq1r07lcxqxb/My macro.xlsx?dl=0 (dropbox.com/s/gsvgq1r07lcxqxb/My%20macro.xlsx?dl=0)
.txt link
https://www.dropbox.com/s/56mcptu16f0rxch/One%20of%20the%20big%20once..txt?dl= (dropbox.com/s/56mcptu16f0rxch/One%20of%20the%20big%20once..txt?dl=0)


when i meant more printer friendly i was thinking of have the macro stop posting in the D+E line and more on to F+G and so on when it hit cell 50, and also do all thin in a new sheet in the same doc?

where can i read a little up on this macro code? would love to be able to under stand it a bit..

 

[hiker95]

ZaXaZ,

Excel doc link
https://www.dropbox.com/s/gsvgq1r07l...acro.xlsx?dl=0 (dropbox.com/s/gsvgq1r07lcxqxb/My%20macro.xlsx?dl=0)

Your posted link (above) shows that my macro is working correctly.

You are very welcome. Glad I could help.

And, come back anytime.

 

[hiker95]

ZaXaZ,

where can i read a little up on this macro code? would love to be able to under stand it a bit..

See if something, in the below link, of my most up to date list will help you:

Training / Books / Sites as of 1/17/2015

http://www.mrexcel.com/forum/excel-questions/829893-macros.html#post4048295

 

[ZaXaZ]

ZaXaZ,



Your posted link (above) shows that my macro is working correctly.

You are very welcome. Glad I could help.

And, come back anytime.

Yes it´working good.

is there any way to add in the few things i talk about in the same post?

would be so cool a macro then

would love to be able to read up on this stuff also but i do not know what to read up on??

 

[ZaXaZ]

BIG BIG Thanks to hiker95, Michael M and jolivanes for the help and time.

 

[hiker95]

ZaXaZ,

BIG BIG Thanks to hiker95, Michael M and jolivanes for the help and time.

Thanks for the feedback.

You are very welcome. Glad we could help.

And, come back anytime.

Excel doc link
https://www.dropbox.com/s/gsvgq1r07l...acro.xlsx?dl=0 (dropbox.com/s/gsvgq1r07lcxqxb/My%20macro.xlsx?dl=0)

Can we have another link, like the one above, where you manually format the results, in the correct locations/columns/new worksheet?


After you do the above, I would be happy to insert comment lines in the final macro code, so that you would be able to understand/follow what is going on.

 

[ZaXaZ]

ZaXaZ,



Can we have another link, like the one above, where you manually format the results, in the correct locations/columns/new worksheet?


After you do the above, I would be happy to insert comment lines in the final macro code, so that you would be able to understand/follow what is going on.

Yes sure.. give me 5 min it will be there.