Posts by pinky2013

    Hi,

    I had posted this questions a few days ago but did not receive a response...can anyone please help me with this query?


    thanks,
    Pinky


    here is the original question:


    I am trying to export values from the same four cells (B3, AF4, AF6, and JJ2) from multiple worksheets into one master sheet with four columns (all B3 values make one column, all AF4 values make the second column, and so on) in the same workbook. The first sheet is named 'Master' and is empty. This is where I want the macro to export the values and create the four columns. The remaining ~70 sheets/tabs in this workbook contains the names of different people (in the format last name, first name) and has information pertaining to each individual. However, I want specific information for each person and want to combine it all into the four columns. What macro can I use?


    Thanks,
    Pinky.

    Hi,


    I am trying to export values from the same four cells (B3, AF4, AF4, and JJ2) from multiple worksheets into one master sheet with four columns (all B3 values make one column, all AF4 values make the second column, and so on) in the same workbook. The first sheet is named 'Master' and is empty. This is where I want the macro to export the values and create the four columns. The remaining ~70 sheets/tabs in this workbook contains the names of different people (in the format last name, first name) and has information pertaining to each individual. However, I want specific information for each person and want to combine it all into the four columns. What macro can I use?


    Thanks,
    Pinky.