| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export to new workbook
I have an Excel sheet that I have set up so it will filter by the vendor.
I'll need to send this information by the specific vendor per their request. Is there a way if I select the vendor from the filter that it can export just that vendors data to a new sheet so that none of the other vendor information can be viewed? Then I can just send that new workbook to the vendor. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Export to new workbook
Hi Supe,
select the entire range (after filter), press F5, click on Special botton, then slected Visible cells only. copy and past to another sheet. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Supe" escreveu: I have an Excel sheet that I have set up so it will filter by the vendor. I'll need to send this information by the specific vendor per their request. Is there a way if I select the vendor from the filter that it can export just that vendors data to a new sheet so that none of the other vendor information can be viewed? Then I can just send that new workbook to the vendor. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| export worksheets to other workbook | Excel Discussion (Misc queries) | |||
| Automate export to a new workbook | Excel Discussion (Misc queries) | |||
| import/export data from a workbook | Excel Discussion (Misc queries) | |||
| is there a way to export just 1 worksheet of an entire workbook | Excel Worksheet Functions | |||
| Export TextBox contents to new workbook. | Excel Discussion (Misc queries) | |||
Linear Mode
