Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strategy Query
I have two .xlS files: - one has 300 (variable #) records with each record consisting o two rows of mostly numerical data over 10 columns and a blank ro between each record; - the other has 20 (variable #) records with each record consistin of one row in one column (same column for all records); the one cel for each record is an alphanumeric string consisting of 16 - 2 characters - this string type is also the first column of the firs spreadsheet. There are no blank rows between records. I want to use the second file as an index for the first one, in that want to use the second file to capture two rows of data for record that have matching alphanumeric strings. Or in other words, I want t use the second file to eliminate all "non-matching string" records fro the first file. Does anyone have any tips on how I might proceed using VBA code? Thanks in advance, Chuckles12 -- Chuckles12 ----------------------------------------------------------------------- Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494 View this thread: http://www.excelforum.com/showthread.php?threadid=31998 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strategy Needed for storing data in these fields | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Help creating a summary tab (strategy) | Excel Discussion (Misc queries) | |||
Strategy Needed | Excel Discussion (Misc queries) | |||
building invoice - strategy advice | Excel Discussion (Misc queries) |