excel button to save sheet contents to new workbook

D

Don

I have an excel workbook where on Sheet1, I can input some data in column A
and the embedded lookups show data relevant to my input value in columns B
through U. Sometimes, I may input as many as 7000 rows of data in column A.
Can a "Button" in the workbook be programmed such that it will save the
contents of Sheet1 A1:U7000 to a new workbook and prompt me to name it and
save to a location of my choice? Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save and closed excel workbook from the sheet 1
Shared Workbooks & Code 1
VBA code for pasting links -- modifying RDB code for summary workbook 11
Excel data vs Access database 3
copying to new workbook 0
Pasting a cell into bookmarked table from excel vba 1
Need to create an excel template with many dependencies between columns and some prog 0
Import sheets with picture 0

Top