Hello. I need assistance with an issue that I’ve just not been able to figure out.
I am currently working on attempting to copy entire rows from a master worksheet in a workbook and then pasting them to new worksheets inside of a new workbook and saving automatically with a new name to a folder on a network drive. I do not want all of the workbooks open at once because we could end up with 100 workbooks.
What I have is a list of data like what follows:
What I need to do is have a Macro read from the first column the Value of the Cell, copy all of the rows which relate to said value, and then create a new worksheet named with the value and paste said rows into the sheet along with the header column in a new workbook with the same name and add totals to some columns.
The end result wanted would be a workbook with the master sheet and then many workbooks saved to the network drive.
If you need further details please let me know.
Thanks!
I am currently working on attempting to copy entire rows from a master worksheet in a workbook and then pasting them to new worksheets inside of a new workbook and saving automatically with a new name to a folder on a network drive. I do not want all of the workbooks open at once because we could end up with 100 workbooks.
What I have is a list of data like what follows:
What I need to do is have a Macro read from the first column the Value of the Cell, copy all of the rows which relate to said value, and then create a new worksheet named with the value and paste said rows into the sheet along with the header column in a new workbook with the same name and add totals to some columns.
The end result wanted would be a workbook with the master sheet and then many workbooks saved to the network drive.
If you need further details please let me know.
Thanks!
