JoeDogs
07-18-2017, 03:53 AM
Hi everyone,
i am am new to this forum and VBA or the VLOOKUP method and wondering if you could help me out.
I have 2 sections of data in 2 separate sheets and need to sort them. They each have cells filled from A1:Q300
From the data in the second sheet (A2), it references a product in the first sheet and I'd like to move all the data from the second sheet to be in line with the same product from the first sheet.
for example:
sheet1:
A1 to Q300 has data on different products (labelled by product #)
sheet 2:
A1 to P120 has additional data on the products mentioned in sheet1 (also labelled by most of the same numbers in sheet1)
i want to:
Sort the products in sheet2 to align with that corresponding product in sheet 1
so now sheet 1 would be A1 to Q300 + corresponding data from sheet 2
essentially want to combine the 2 sheets together but have the data organized by line for that product number
im sorry if this is confusing, it was hard to word and i am frustrated as I've been working on this on and off for a couple weeks now. Just can't seem to figure it out! Any help would be appreciated! Thanks
i am am new to this forum and VBA or the VLOOKUP method and wondering if you could help me out.
I have 2 sections of data in 2 separate sheets and need to sort them. They each have cells filled from A1:Q300
From the data in the second sheet (A2), it references a product in the first sheet and I'd like to move all the data from the second sheet to be in line with the same product from the first sheet.
for example:
sheet1:
A1 to Q300 has data on different products (labelled by product #)
sheet 2:
A1 to P120 has additional data on the products mentioned in sheet1 (also labelled by most of the same numbers in sheet1)
i want to:
Sort the products in sheet2 to align with that corresponding product in sheet 1
so now sheet 1 would be A1 to Q300 + corresponding data from sheet 2
essentially want to combine the 2 sheets together but have the data organized by line for that product number
im sorry if this is confusing, it was hard to word and i am frustrated as I've been working on this on and off for a couple weeks now. Just can't seem to figure it out! Any help would be appreciated! Thanks