Hello,
I hope someone could help me here... :-) I have problem which needs an instant resolution.. :-(
I have an excel workbook say -sample.xls. In it I have the ff:
Worksheet 1: (sorting: Ascending orderSampleB)
SampleA Sample B
A1 B1
A2 B1
A3 B2
A4 B3
A5 B4
Worksheet 2: (sorting: Ascending order SampleB)
SampleB SampleC
B1 C1
B1 C2
B2 C3
B3 C2
B3 C4
B4 C1
What i want to do is to somehow merge the two tables by inserting rows (probably in a new worksheet) wherein it will display all possible Sample C and Sample A combination for the specific values in my SampleB.
SampleA SampleB SampleC
A1 B1 C1
A1 B1 C2
A2 B1 C1
A2 B1 C2
Should I be creating a macro??? please please help! thanks much!!
Last edited by newbie_25; 10-21-2010 at 09:14 PM.
Please attach a dummy sheet, so we can see what you can.
Is the data in col b the same across both, sheet 1 and 2?
Regards
Peter
Please see attached file! :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks