Hello,
I would like to complete your project as your requirement like need to get the following data:
Rows 2-780
Columns A, C, H, I, J, K, L, M, N, O, P, Q, R, S
into the same Columns for Rows 783-2495
You will create a script or macro that will look at Column D, from Rows 2-780, and if the first 8 characters of the data in Cell D2:D780 match D783:D2495, then you will paste the data from the previously mentioned Columns, and leave the other Columns untouched.
Example -
Cell D2 contains 10040970-00. The first 8 characters are 10040970. Cell D802, D803, D804 contains 10040970, therefore the data from Row 2, Columns A, C, H, I, J, K, L, M, N, O, P, Q, R, S, should be pasted into Rows 802, 803 & 804.
You must not overwrite Columns B, D, E, F, G, T, U, V, W, X, Y, Z, AA, AB, AC, AD whilst doing that.
I hope i will do your task as your satisfaction.
Thanks