?
Solved

Intelligent paster2

Posted on 2008-10-16
1
Medium Priority
?
198 Views
Last Modified: 2011-10-19
Actually, your solution is helpful but
I am still unable to adapt it to my problem.
I will upload a new excel sheet which could be more clear.

Basically, I need a macro that creates an output sheet
and then selects using AutoFilter all the entries in List1
relating to category A and paste that in the output sheet.
Then select all entries in List2 relating to catory A (Autofilter again)
and paste those entries after the first batch of info in sheet output.

Please can you use the autofilter to search for the entries needed in both lists.

Thanks
Help333.xls
0
Comment
Question by:hugoohta
1 Comment
 

Accepted Solution

by:
hugoohta earned 0 total points
ID: 22729837
Please ignore the first paragraph... This is the question:

Basically, I need a macro that creates an output sheet (new sheet)
and then selects using AutoFilter all the entries in List1
relating to category A and paste that in the output sheet.
Then select all entries in List2 (except the titles) relating to catory A (Autofilter again)
and paste those entries after the first batch of info in sheet output.

Please can you use the autofilter to search for the entries needed in both lists.

Thanks for the help
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question