Please see attached file.
You need to get the following data:
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.
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.
Please explain your method.
Dear client I have read the specs and have seen the file also when you posted the project for the first time with slightly less budget. I can do this for you using formulas. Please contact me. Roy
24 freelancers are bidding on average £42 for this job
Hi, I am interested in this job. I understand what you required. I will provide you fast,quality and error free work because I am professional and experienced in it. Waiting to discuss with you more. Regards.
Greetings, very simple task. Expert is here. I can do this task with high accuracy I am confident that i can deliver best service for you if i am awarded Thanks in advance!