Export to new workbook

S

Supe

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.
 
M

Marcelo

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Sorting and grouping using multiple tables 0
Access Access variable string for export 0
Basic file, data only once to summary? 2
Filter All Tabs 4
How to print vendor file lables from an excell file 2
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
In WORKDAY function, how to exclude multiple/variable holiday rang 4
separate data into mulitple workbooks 1

Top