hi,
I'm new to this forum and also new to excel VBA so kindly excuse if my query has been already posted.
I'm looking for a VBA code to copy data from columns C to Q from a particular sheet(say abc) from each workbook(sheet name 'abc' and column references are constant in each workbook) and append the information in a single worksheet in a new workbook(say master). The data needs to be pasted as values because the data being copied has formulas. Since the data is in tabular format, I would like to retain the source formatting too.
Thanks a lot in advance.
Regards,
Chaitanya.
I'm new to this forum and also new to excel VBA so kindly excuse if my query has been already posted.
I'm looking for a VBA code to copy data from columns C to Q from a particular sheet(say abc) from each workbook(sheet name 'abc' and column references are constant in each workbook) and append the information in a single worksheet in a new workbook(say master). The data needs to be pasted as values because the data being copied has formulas. Since the data is in tabular format, I would like to retain the source formatting too.
Thanks a lot in advance.
Regards,
Chaitanya.