Hi!
I have a master workbook full of formulas and reference worksheets. I had to strip down to attach the example file, here so there won't be any formulas.
I'd like to export and save 3 of the worksheets into a new workbook - keeping the formats and values, only. They are:
"Totals"; "Baked goods"; "Knit goods"
If possible, I'd like to run this in a loop, so that a file is created for each seller in the drop-down selector located on the "Totals" tab of the attached example.
Please let me know if you can help or where I might start. Thank you kindly!
I have a master workbook full of formulas and reference worksheets. I had to strip down to attach the example file, here so there won't be any formulas.
I'd like to export and save 3 of the worksheets into a new workbook - keeping the formats and values, only. They are:
"Totals"; "Baked goods"; "Knit goods"
If possible, I'd like to run this in a loop, so that a file is created for each seller in the drop-down selector located on the "Totals" tab of the attached example.
Please let me know if you can help or where I might start. Thank you kindly!