Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to build a dynamic array and search it for a value
Hi All,
What l want to do is to copy rows from 'source' workbooks and append to a 'master' workbook but only rows where the unique reference does not already exist in the 'master' workbook. The source & master workbooks are identical in layout and the unique identifier is in column A. I have used the code generously given by Ron De Bruin to loop through all the source workbooks and all works fine but l am stumped as to the best way to achieve the above efficiently without going down the Access / SQL route. My thoughts were to build an array from column A of the 'master' workbook and then loop through each row of column A of the 'source' workbook copying the data if the cell(r,"A").Value was in the array. Can anybody point me in the right direction with some sample code to: 1) Build the 'master' workbook array 2) Check that the current 'source' record idnetifier exists in the array Alternatively suggest a better / quicker method with some example code. There is likely to be approx 12 workbooks with 300 rows / records in each. VBA code needs to be compatible with XL2003 & XL2007. TIA All help suggestions greatly appreciated. Regards Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to build a dynamic array and search it for a value
Hello Michael,
Maybe my UDF's at http://www.sulprobil.com/html/listfreq.html can help you. Lfreq, for example. Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build and execute dynamic instructions | Excel Discussion (Misc queries) | |||
ASP.NET - can i use it to build dynamic Excel forms? | Excel Programming | |||
Build a search tool in excel | Excel Worksheet Functions | |||
build a word search puzzle | Excel Programming | |||
build dynamic table | Excel Programming |