hi there,

newbie here and stuck with a macro problem. i have a column in sheet(1) with some data. this sheet performs some calculations and then I want to transfer the data to a master sheet (sheet2) through a macro. I only want to transfer the column data. But I want to update the master sheet everytime i do a new calculation. this should be reflected as a new column beside the previous one in the master sheet. any ideas?