Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating a macro to save only partial data
Help please-
I am attempting to create a macro that will only save a partial area of my excel spreadsheet. It is an excel quote package that was customised for me- It contains 3 sheets. The front sheet contains many pages, but this is the only area that I want to have as a macro. The two other sheets contain part numbers, pricing and calculations. Therefore I will save one copy for me- the one with all the data remaining, but then I would like to somehow be able to just save approximately 6 pages from the first sheet to e-mail to my customers- thats the macro part. I have created a macro button in the toolbar, if i hit that, I would like an area on the front page to highlight that when I hit 'save as' it will only save that highlighted area. Thanks. J. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to save a file as | Excel Discussion (Misc queries) | |||
Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
Deleting excess data in a macro | Excel Discussion (Misc queries) | |||
Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |