Export to new workbook

  • Thread starter Thread starter Supe
  • Start date Start date
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.
 
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:
 
You must log in or register to reply here.

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 Access variable string for export 0
Access Sorting and grouping using multiple tables 0
How to print vendor file lables from an excell file 2
Basic file, data only once to summary? 2
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
Filter All Tabs 4
Display a list in one column 1
separate data into mulitple workbooks 1

Back
Top