Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save only edited sheet within a workbook (Excel 2003)? | Excel Programming | |||
Macro to save excel sheet in a workbook | Excel Discussion (Misc queries) | |||
Button To Sort Sheet Contents On Column? | Excel Programming | |||
Save workbook via Command Button???? | Excel Programming | |||
Command Button to Save As Workbook... | Excel Programming |