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 As and new workbook new name used in existing code 8
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
How to clear contents of multiple cells in Excel simultaneously 1
Import multiple workbooks to current workbook in specified row number 0
Copy from Excel to Word 2
Save workbook button on Userform 2
Button looses Macro setting when running Macro 1
VBA code for pasting links -- modifying RDB code for summary workbook 10

Top