VBA code to Transfer specific data from sheet1 to Sheet2

[xlhelp7]

Hi All,

Required your Expert help!

In sheet1 i have raw data and in sheet2 in Column C i want values from sheet1.

Please find the attached sample file.

Regards,

Xlhelp7

[dflak]

You have provided insufficient information.

We need a "map" to figure out where you want to put the pieces on sheet 1 on sheet 2. For example on sheet 2 under labels, you have "Configuration". Where is this on sheet 1? This is somehow associated with "4 bedrooms, 4 Bathrooms, 3+ Balconies." Where is this information and how does it get associated with sequence 3 and Configuration.

You will find that people are more likely to work on a project when they do not have to reverse engineer it, especially with a sample of one or with incomplete data. You need to provide the logic or business rules you use.

[xlhelp7]

Hi dflak,
Thank you for your reply.

Sorry for delay,Actually i was out of my office.

Please find the attached updated workbook.In attached updated workbook sheet1 having the raw data which i copied from website and in sheet2 in column c i require
specific values from sheet1.

Please let me know if you require more information.

Regards,

Xlhelp7

[dflak]

I see that on Sheet 2 in Cell C2 you have "Residential Apartment for Sale in Bestech Park View City, Sector-48 Gurgaon" but I don't see this anywhere on Sheet 1. I'm not going to look for where you may or may not have stuff on sheet 1 to figure out where you want it on sheet 2. You have failed to give me the map to do this.

You did not define the requirement well enough.

[xlhelp7]

Hi dflak,
Thank you for your reply.

Sorry for Mistake,Actually it was Residential Apartment for Rent in Bestech Park View City, Sector-48 Gurgaon.

You can see this in sheet1 in A1 and A2.

Please find the attached.

Regrads,

Xlhelp7

[dflak]

I'm sorry, I still do not understand the requirement. Maybe someone else can help you.