hello,
I have 8 separate worksheets that have data and once every month i send each sheet to a separate person. Is there an easy way to export the information sheet by sheet to new individual workbooks as I don't want them seeing each others information?
Please see post#3 for a better version...
Hi stdar2 - Try this:Obviously, you'll have to adjust all the names, as well as the destination.
Please Login or Register to view this content.
Last edited by leelnich; 10-25-2023 at 02:37 PM. Reason: Wrote better version (Post#3)
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
After further testing: this example overwrites old versions of each workbook automatically (if such exist).Please Login or Register to view this content.
Last edited by leelnich; 10-25-2023 at 03:56 PM. Reason: Added comments
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks