reza_doang
05-25-2010, 09:16 PM
dear all,
i have 1 file excel with many sheets, more than 10. with the same column and header. Now i want to create master sheet by combining all sheet become one.
Actually i can manually use copy-paste but the problem if i should edit/update one of sheet i should update to master sheet.
using macro, how to create master sheet and if there are a changed in one or more sheet, the master sheet will change automatically.
thanks for ur kind : pray2:
reza
i have 1 file excel with many sheets, more than 10. with the same column and header. Now i want to create master sheet by combining all sheet become one.
Actually i can manually use copy-paste but the problem if i should edit/update one of sheet i should update to master sheet.
using macro, how to create master sheet and if there are a changed in one or more sheet, the master sheet will change automatically.
thanks for ur kind : pray2:
reza