Hi everyone, would like to seek your advice. So far the macro codes I read here has similar functions however instead of excluding certain worksheets, I want to include selected worksheets.
I am looking to copy paste several worksheets say sheet1,sheet2, sheet3 from column O to U into one worksheet name scenario. Row starts from row 3 onwards. So O3:U? ( depending what is the last row)
The data from sheet 1 sheet 2 and sheet 3 has formulas, hence I would like to paste special values.
Others:
1.For sheet1 sheet2 and sheet , copy until the last row data only.
2. Append data to the last empty row.
Thank you
I am looking to copy paste several worksheets say sheet1,sheet2, sheet3 from column O to U into one worksheet name scenario. Row starts from row 3 onwards. So O3:U? ( depending what is the last row)
The data from sheet 1 sheet 2 and sheet 3 has formulas, hence I would like to paste special values.
Others:
1.For sheet1 sheet2 and sheet , copy until the last row data only.
2. Append data to the last empty row.
Thank you
