excel button to save sheet contents to new workbook
The contents should be pasted into the new workbook as text.
"Don" wrote:
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!
|