matrix
New member
Hello Excel World...
I have a problem. I don't know if you can help me. I just don't know.
How to copy and paste data from one worksheet into a new worksheet in the same workbook. "Keeping all formula, drop-down menu and color codes the same which are link with other worksheets of the same workbook".
Currently I have 30 worksheets that have the same data layout. However, I would like to create a new worksheet to copy all 30 worksheet ranges from column A, B, C, D, E & F. and paste into new worksheet.
Please note. I have tried copy and paste, cut and paste and have not worked.
How can I fix this issue?
Thanks in advance
Cheers
https://drive.google.com/file/d/1lcpmWdrmtl_c6tY3PgOQLtlzhgQmQi-k/view?usp=sharing
I have a problem. I don't know if you can help me. I just don't know.
How to copy and paste data from one worksheet into a new worksheet in the same workbook. "Keeping all formula, drop-down menu and color codes the same which are link with other worksheets of the same workbook".
Currently I have 30 worksheets that have the same data layout. However, I would like to create a new worksheet to copy all 30 worksheet ranges from column A, B, C, D, E & F. and paste into new worksheet.
Please note. I have tried copy and paste, cut and paste and have not worked.
How can I fix this issue?
Thanks in advance
Cheers
https://drive.google.com/file/d/1lcpmWdrmtl_c6tY3PgOQLtlzhgQmQi-k/view?usp=sharing