Saving multiple worksheets

Hi everyone!

I have a macro that saves the first worksheet of a workbook based on specific cell information.

Please Login or Register  to view this content.

I would like to expand this macro to save the first and second worksheet, if there is data in a specific cell of the second worksheet.

Any suggestions would be greatly appreciated.

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

The highlighted values can be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi Greg,

It worked, but now I have a new issue caused by adding the new code. Should I start a new post or continue on this one.

Thank you for your help

Hi again,

Many thanks for your feedback - glad I was able to help.

If the new issue has been caused by adding the above code then I imagine it's quite in order to ask the question in this thread.

Regards,

Greg M

Thanks Greg. I enjoy this site because it helps me a lot and I don't want to do anything frowned upon

I was writing the explanation and the solution was right there in front of me!! I fixed the second issue.

Your code has saved me so much time!!!

Thank you! Thank you! Thank you!!

Hi again,

Thanks for your latest post, and well done on fixing the second issue yourself!

You're very welcome - I'm delighted that I was able to help.

Regards,

Greg M