LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Don is offline
external usenet poster
 
Posts: 487
Default excel button to save sheet contents to new workbook

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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Save only edited sheet within a workbook (Excel 2003)? Pheng Excel Programming 2 December 7th 08 02:36 AM
Macro to save excel sheet in a workbook [email protected] Excel Discussion (Misc queries) 1 March 7th 07 02:37 PM
Button To Sort Sheet Contents On Column? (PeteCresswell) Excel Programming 6 February 9th 07 03:43 PM
Save workbook via Command Button???? Chris Watson[_5_] Excel Programming 3 March 23rd 06 10:11 AM
Command Button to Save As Workbook... RPIJG[_13_] Excel Programming 1 May 12th 04 08:59 PM


All times are GMT +1. The time now is 08:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"