Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy all records matching "Text" criteria to new worksheet
I am trying to avoid having to learn Visual Basic to perform the following:
Scenario: I am building a tool for "sales people" that are not very familiar with Excel. Through an excel connector program I am able extract data from an external database. Unfortunately, this query program is not able to get it to the level that the user needs. The average amount of records on a query is about 1,500. This is a complete data dump of all the records of a user. I am trying to create a new worksheet that contains only those records of a selected Industry. Industry is one of the fields that are downloaded from the database dump. I have played with the following functions: VLOOKUP, INDEX, MATCH, OFFSET, etc. I have also tried Pivot Tables and Advanced Filters. These are not working. The first row of the data dump is above the header columns. This is a limitation of the query program which requires that the query command be on the first row. Therefore, the Header Columns are in the second row. I think that is why Pivot Tables and Advanced Filters are not working. When I use various combinations of the aforementioned functions, I can find the first record of the occurance, but do not know how to incorporate an offset variable from the first match into a function to locate the next match. Is it possible to do the following? * In the first cell of the target sheet, enter a function to locate the first occurance and return the associated record/row (This is the easy part that I have already done) * Have a function in each following cell locate the next occurance and copy the row over. Thanks for any help or advise on this. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy all records matching "Text" criteria to new worksheet
Does it need to be a new worksheet? If the only requirement is to view
the data you want, then data, filter, autofilter would do it |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy all records matching "Text" criteria to new worksheet
Automatic/Advanced filter is the evident solution.
Column headers may reside on any row. I can't understand why this does not work by you. Could you post sample data (or upload on http://cjoint.com and post the link) HTH -- AP |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy all records matching "Text" criteria to new worksheet
Ardus and Aidan,
Thank you both for your responses. I am sorry it took so long to respond to your advice. I have been away from my computer for a while. I will retry the auto and advanced filter functions. If these don't work, I'll post sample to the url that Ardus recommended. Thanks. "Ardus Petus" wrote: Automatic/Advanced filter is the evident solution. Column headers may reside on any row. I can't understand why this does not work by you. Could you post sample data (or upload on http://cjoint.com and post the link) HTH -- AP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
copy rows meeting criteria to another worksheet | Excel Worksheet Functions | |||
copy formatted (red font) cells from one worksheet to another | Excel Discussion (Misc queries) | |||
Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
macro to copy and edit then delete a worksheet | Excel Discussion (Misc queries) |