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

Attached Files

	Book2.xlsx (17.7 KB, 9 views)
	Enduro_3.xlsm (91.8 KB, 9 views)