Worksheet Merging
 

Hi guys,

I'm back with a somewhat simple yet complicated problem. I have 2
separate worksheets with different headers but corresponding columns
that I need to merge. They would look something like this.

Sheet1
Part
Description
Last Use
Last Purchase Order
Buyer

Sheet2
Part
Price
Quoted Price
Last Use
Buyer


The corresponding columns that I want are Part, Last Use and Buyer

I've been trying to figure out how to merge these 2 worksheets and can
only come up with a really bad pseudo code for it. =/

Copy entire sheet1 onto sheet3
Delete unwanted column

while loop to count number of rows occupied on sheet3 (Dim x as long)

another while loop with Dim y as long, y=2 for sheet2
x+1
while sheet2!Ay is not null,
sheet3Ax = sheet2!Ay


Thats the best I can come up with. =/ Seems a little troublesome. Can
anyone come up with a better solution?

*Note* I can do a while loop in the beginning to copy over only the
columns I want as well and that will pretty much take the place of the
counting loop/