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
26 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.
HI, I work on excel..I have more then 3 year experience in this field..I will give you best services ..Please contact with me for your job..Thank you.. Sincerely juwel
Dear sir, I will give you the best result on your project. you can chat with me and let's get started project. I am ready to show you samples of similar project, I have completed thanks.
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!