tendosai
05-18-2020, 06:30 PM
Greeting everyone,
I have a bit of complicated manual work thus i wanna make a VBA to handle the task with a click.
I have one master EXCEL file namely "MASTER.xlsm" it contains many sheet with both value and formula to calculate another table for different sheet. Manually, I would have to create a copy to new workbook then copy/paste value only to remove the formula. This took me a while because i have to make 3 to 4 new workbook with no formula.
The macro i try to config should be able to make new 3 new workbooks (different name / different sheet) base on "MASTER.xlsm" with all format and value intact but no formula in there.
I found out about this
worksheet.UsedRange.Value = worksheet.UsedRange.Value
but does this also copy the format as well?
shall i first make sheet copy to new workbook then use above code or maybe there is a way that both copy sheet to new workbook with all format intact but no formular?
I have a bit of complicated manual work thus i wanna make a VBA to handle the task with a click.
I have one master EXCEL file namely "MASTER.xlsm" it contains many sheet with both value and formula to calculate another table for different sheet. Manually, I would have to create a copy to new workbook then copy/paste value only to remove the formula. This took me a while because i have to make 3 to 4 new workbook with no formula.
The macro i try to config should be able to make new 3 new workbooks (different name / different sheet) base on "MASTER.xlsm" with all format and value intact but no formula in there.
I found out about this
worksheet.UsedRange.Value = worksheet.UsedRange.Value
but does this also copy the format as well?
shall i first make sheet copy to new workbook then use above code or maybe there is a way that both copy sheet to new workbook with all format intact but no formular?