Macro to pull data from sheet1 to sheet2

[rupss01]

Hi freinds,

Attached is excel file.

Sheet1 contains raw data (which needs to be arrange in sheet2)
Sheet2 contains final output (Output will reflect correspondent data from sheet1)

Any macro or formula will be very help full.

Thanks for your views.....and time.

[watersev]

hi rupss01, please check attachment, run code "test"

Please Login or Register  to view this content.

[watersev]

if assume that three row address will look like rows 1-12 sample of the attachment, it might be done like this

Please Login or Register  to view this content.

[rupss01]

@watersev...the code works perfects...thanks for your prompt response.

One query can i pull more than 100 data @ time

[watersev]

the code has no such limitation provided the layout will be the same

[watersev]

if you are happy with the solution provided, please mark the thread as Solved under Forum rules:

If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

[rupss01]

@watersev

Bro can you please check attached file as well, while running macro getting Runtime Error 13 - Type mismatch

Unable to pull more than 12 data...

Surely will follow your's instruction.

[rupss01]

@watersev

Also some instance Runtime Error 9- Subscript out of Range

[rupss01]

Also some instance Runtime Error 9- Subscript out of Range

[watersev]

The example provided originally has not been representative. You have cases without address at all, without end part etc. Try this option, press Start on Sheet 2

[rupss01]

@watersev

thanx a lot for your time and efforts ...instruction followed