need help of vba code to pull data multiple times into master sheet

**johnodys** · 02-20-2014, 07:12 AM

Dear Excel & VBA Experts

I need ur help on data extract from sheet to sheet through column header values, i have set of data on sheet1,2..loop end of sheet

i want pull column data from multiple sheet column values into masterdata sheet depends upon column header values assigned in masterdata sheet.. my code works fine! but i want pull data if column header repeats more than one also

SO_NBR this is one heading in multiple sheets i cant pull col values not more than once under if SO_NBR repeats more than once.

Please Login or Register  to view this content.

find the attachment mentioned as expected result sheets is my requirement

**Naveed Raza** · 02-25-2014, 02:31 AM

Hi John

"3PL_PART_NAME" this name is not avaiable in provide workbook in Sheet1 Worksheet.

**Naveed Raza** · 02-25-2014, 03:11 AM

Hi John

try this attached file and let me know

Hope this will work

**johnodys** · 03-05-2014, 01:48 AM

Nice Sir It working almost 99% One is for H & I columns Heading values not filling...Pls check sir

**Naveed Raza** · 03-05-2014, 03:25 AM

Hi John

as i already informed you at post #2

"3PL_PART_NAME" this name is not avaiable in provide workbook in Sheet1 Worksheet.

dont forget to Click on Add Reputation if you feel the solution good

**johnodys** · 03-06-2014, 12:51 AM

Yes Sir... Really sorry I didnt notice that one where pointed mistake ..I made new attachment proper column header...find it to solve my problem...

thanks alot sir

**Naveed Raza** · 03-07-2014, 08:04 AM

Hi John

where is the attachement ?

**johnodys** · 03-07-2014, 08:38 AM

Sorry sir I though it was uploaded but i missed it out...

**Naveed Raza** · 03-11-2014, 02:51 AM

Hi John

Today or Tmrow EOD i will provide updated file

**johnodys** · 03-12-2014, 05:15 AM

Ok Sir take ur own time...

**Naveed Raza** · 03-13-2014, 02:01 AM

Hi John

have a look to attached version 2 file and let me know

**johnodys** · 03-13-2014, 03:24 AM

Thanks Alot Sir Its works amazing!!!

**Naveed Raza** · 03-13-2014, 03:41 AM

Glad I could help u

1. If the suggestion helps you, then Click * to Add Reputation and give ur valuable comments
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.