Hello I am trying to see if there is a way to create a new workbook within the workbook i am working on.
in the workbook i am working from i would like to Then copy a range of values (the formulas and hard coded values) and paste them into a sheet in the new created workbook, this will be for 3 sheets so creating three sheets in the new workbook so is it also possible to bring the sheet name too? And also see if if the format can be pasted as well.
The range is from C8:W4205 That the values/formulas and the format would like to copy and paste from and the name of the sheet to match, thank you!
in the workbook i am working from i would like to Then copy a range of values (the formulas and hard coded values) and paste them into a sheet in the new created workbook, this will be for 3 sheets so creating three sheets in the new workbook so is it also possible to bring the sheet name too? And also see if if the format can be pasted as well.
The range is from C8:W4205 That the values/formulas and the format would like to copy and paste from and the name of the sheet to match, thank you!