Read data on Sheet3 copy to Matching cells on Sheet1
Good Morning all
I have a program for use on Endurance Horse races, I am requesting some VBA to help here.
On the " Front Sheet 3 " they enter some data this then needs to be assigned to that rider on the " Open Sheet 1 ",
Scenario 1 " Sheet 3 " If Q6="",and L6="" select( D2, F2, J6,) vlookup "Sheet 1" (Cells A1:Z107 ) paste data from ( D2, F2, J6,) then run clear open macro select "Sheet 3 " D6 OR
Scenario 2 " Sheet 3 " If Q6="",and L6," V or W " select( D2, F2, L6,)(in this scenario ignore J6) vlookup "Sheet 1" (Cells A1:Z107 ) paste data from ( D2, F2, L6,) then run clear open macro select "Sheet 3 " D6 OR
Scenario 3 " Sheet 3 " If Q6>"", select D6 & Q6, for pasting (Timeout column on sheet 1)" (refer structure on "Sheet 7" L8-L30) then on "Sheet 1 "(In this case Column "J",(Cells A1:Z107 Paste Q6),then run clear open macro select "Sheet 3 " D6
The " Lookups" above ONLY for an indication,
The Book2.xlsx shows the before and after.
Any thing that is not clear or problems please contact me
There is 2 sample files
Please be advised of cross posting
https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1222068-read-data-on-sheet3-copy-to-matching-cells-on-sheet1
https://www.excelforum.com/excel-programming-vba-macros/1286282-read-front-page-data-then-transfer-that-data-to-the-main-data-sheet-open.html#post5181070
EF also advised of this and other posting
Last edited by Potholes; 08-21-2019 at 11:52 PM.
|