How do I take info from 2 spreadsheets and create a third using only specific data from the first 2?

Question

I am trying to run a query and am not knowledgeable enough with excel or access to complete. What I have is a master spreadsheet with thousands of rows and columns and I am trying to run a query so that I am only extracting some of the data. Right now I am searching the spreadsheet manually and copy and pasting each individual row. I know there is an easier way! Any advice is appreciated. Thanks

garbo7441 · Accepted Answer

Can you be more specific about your process?  

Do you wish to input a search criteria, have Excel search a specific column, and if the search 'data' is found copy the entire row to the next available row in a 3rd spreadsheet?

Or, do you want Excel to search ALL columns and copy the entire row to the next available row in a 3rd spreadsheet?

Or, ???

Anonymous · Answer

This would require you to have some knowledge of VBA.

Check out "Excel VBA Programming for Dummies" at your local bookstore or Amazon.com, it will help you do what you want.

Trending News

How do I take info from 2 spreadsheets and create a third using only specific data from the first 2?

2 Answers