Jump to content

One Button for everything

DerylWingate's Photo
Posted Jan 10 2013 06:51 AM
928 Views

Hello,

How can I get a 2010 Excel workbook to be set. So when a button called End is clicked the sheets 1-3 are printed and saved with the file from 4 different Cells. I have 4 cells: A3 Persons Name, C3 Persons Number, A42 Name of the Voucher, and G36 Voucher number. Is it possible to have those cells as the name of the file to be saved? Also After it iss saved I would like to select the directory to save it to, because at work I work on one drive and have to save it to another drive. Then after it saves, I want it to automaticcally close out the entire worksheet.

Filename: Cells A3, C3, A42 and G36
Saved from a .xlsm to a xlsx.

Also I've attached the file I am working on, I attempted to code it myself, but couldn't get it to work at all. Thank you in advance for any help you can provide.

0 Replies