I have two spreadsheets with data I need to combine parts of both sheet to a third workshe

[JACKNOT]

I have two spreadsheets with data I need to combine parts of both sheet to a third worksheet; I would like to use a macro if possible, the Sheet “Ship To” has 7 columns of data A2 to G2 87000 rows that needs to be filtered by column A and B and Sheet “FS Unit Table” column A and B to find matches if there is a match the results need to be copied the sheet “Ship to SN”

So if the sheet “Ship To” Column A2 has data of 1 and B2 has data of 0 and has a matching 1 and 0 in columns A and B in Sheet “FS Unit Table” then from sheet “Ship To” columns A-G need to be copied to the sheet “Ship to SN” column A – G then the matching data from sheet “FS Unit Table” column C D Q Z need to be copied to sheet “Ship to SN” columns H I J K, there will only be one row of data from sheet “Ship To” and a number of rows in sheet “FS Unit Table” that match.

[jraj1106]

Hi.

Post a sample data file.

[JACKNOT]

Hi,

Here is a sample file

[jraj1106]

Check this out:

Sample.xlsm

[JACKNOT]

Thanks for the code it works on the sample data, but when i run it on a copy of the live data it fills 9 rows and just sits there it has been running for about 2 hours. the live data has about 90000 rows on each sheet

[JACKNOT]

Thanks for the code it works on the sample data, but when i run it on a copy of the live data it fills 9 rows and just sits there it has been running for about 2 hours. the live data has about 90000 rows on each sheet

It just needed time to run the data I had was large and it took 4 hours to crunch,

Thanks agian for the code and you expertise.

[mike7952]

Give this a try, Might speed things up.

Please Login or Register  to view this content.

[JACKNOT]

Mike,

Thanks for the code it worked a lot faster; I did have to change a line of the code

aArrSN(n, 10) = aArr(i, 15) column o
to
aArrSN(n, 10) = aArr(i, 17) column q

Other than that it worked great,

Thanks again
Jack

[mike7952]

Ah ok. Glad its working!