create excel files on excel data

[m_vishal_c]

hi I have 2 Excel files. 1 Source and 2nd Destination. There are some columns in Source file like
[TABLE="width: 403"]
<tbody>[TR]
[TD]Sr No[/TD]
[TD]Name[/TD]
[TD]Address[/TD]
[TD]Contact no[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Abc[/TD]
[TD]xxxx[/TD]
[TD]123[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Xyz[/TD]
[TD]xxxx[/TD]
[TD]345[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Mno[/TD]
[TD]xxxx[/TD]
[TD]567[/TD]
[/TR]
</tbody>[/TABLE]
and in Destination there are below fields
[TABLE="width: 75"]
<tbody>[TR]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD]A1 Sr No[/TD]
[/TR]
[TR]
[TD]A2 Name[/TD]
[/TR]
[TR]
[TD]A3 Address[/TD]
[/TR]
[TR]
[TD]A4 Contact NO[/TD]
[/TR]
[TR]
[TD]A5 and other stuff[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I need vba code which create new excel file on each row and copy relevant information and save as Name data

if anyone can help then it will be great.
Heaps thanks in advance

 

[oldbrewer]

the information in source and destination appears to be the same - show us a few lines of your desired output, please.

 

[m_vishal_c]

the information in source and destination appears to be the same - show us a few lines of your desired output, please.

hi Thanks for replying. in source file, there are all user's information all together but in destination file, there must be one record (one user information). concept is Mail Merge, we use in word documents.

if you required more information then please let me know

thanks

 

[My Aswer Is This]

See we need exact details.
In source file is this columns A B C D
You said: "I need vba code which create new excel file"
And you want a new Sheet or a new workbook for each row.

You really want a new Workbook for each row of data??

 

[m_vishal_c]

See we need exact details.
In source file is this columns A B C D
You said: "I need vba code which create new excel file"
And you want a new Sheet or a new workbook for each row.

You really want a new Workbook for each row of data??

Sorry for making confusing . you are right I need to create new workbook for each row of data and save as A2 Name

Thanks

 

[My Aswer Is This]

You still did not answer this question:
In source file is this columns A B C D

Are we only dealing with four columns

 

[m_vishal_c]

You still did not answer this question:
In source file is this columns A B C D

Are we only dealing with four columns

Yes Please

 

[oldbrewer]

I cannot see why you need a new workbook for each row, how about putting the whole row into one single cell, ie the cell could be "1 fred 33 hight street anytown 01563456789"

 

[m_vishal_c]

I cannot see why you need a new workbook for each row, how about putting the whole row into one single cell, ie the cell could be "1 fred 33 hight street anytown 01563456789"

Sorry mate. but I need it. I do have several records and want to make separate Excel workbook on each row and in that new workbook I need to add those row details in each new workbook, separately . Hope you can understand me

thanks

 

[My Aswer Is This]

So you already have: Two workbooks. You said:
"hi I have 2 Excel files. 1 Source and 2nd Destination. There are some columns in Source file like"
We need the full exact names of these two Workbooks and what the sheet names are in each of these workbooks.

I believe your going to Email out these files you want to create.
Why can we not create a new sheet for each row and not a new workbook?

If you have 500 rows then you want 500 new Workbooks doing things the way you seem to want.