Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fitering/Matching Data based on various Criteria
Hi,
I have to perform the following task on a spreadsheet with more than 9000 records on it. Is it possible to write a macro to do this. I wish to match data from two excel spreadsheets. After matching them I want to try and match the remaining unmatched data with another spreadsheet. This is how it should work. There are two spreadsheets say spreadsheet A (sA) and spreadsheet (sB) Now the date on spredasheet A is in american Date format that is mm/dd/yyyy and in spreadsheet B is in yyyymmdd format. The first thing I want to do is delete all the records from sA and sB which have dates than a particular date that will be stored in another worksheet. Then I want to match Column C in sA with Column E in sB. It should remove all the matching Columns and leave me with the Unmatched columns. Now the remaining Unmatched records need to be matched to another Spreadsheet, say sreadsheet C (sC). So, now sA needs to be matched to sC and sB needs to be matched to sC based on one of the columns. Could anyone help please. Many Thanks and Kind Regards, Hussain |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Totaled based on Matching Identical Criteria in Worksheet | Excel Discussion (Misc queries) | |||
Return Data Matching Criteria in a separate spreadsheet | Excel Worksheet Functions | |||
Sum based upon matching data in different columns | Excel Worksheet Functions | |||
I want to use a link to return all data matching a criteria | Excel Worksheet Functions | |||
Matching data using date criteria... | Excel Worksheet Functions |