Please can someone help in providing vba code to extract data from sheet1 and sheet2 and populate the desired output as mentioned below in sheet3?
Your help will be much appreciated.
Sheet 1
Column1 Column2 John MS Access John MS Word John MS Excel Smith MS Paint ..... .....
Sheet 2
Column1 Column2 John HR John Finance John IT Smith Finance ..... .....
Desired Output in Sheet3
Column1 Column2 Column3 John MS Access HR John MS Word HR John MS Excel HR John MS Access Finance John MS Excel Finance John MS Word Finance John MS Access IT ... ...... .....
Bookmarks