Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Worksheet Merging Macro | New Users to Excel | |||
Merging from one worksheet to another | Excel Discussion (Misc queries) | |||
Merging cells in the center of a worksheet | Excel Worksheet Functions | |||
merging two worksheet | Excel Worksheet Functions | |||
Merging worksheet data | Excel Discussion (Misc queries) |