I have attached my shortened steps to achieve my final outcome

[QUOTE
Step 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





Step 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



Step3 " 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 [/QUOTE]







Cross posted elsewhere

Read ( FRONT ) page data then transfer that data to the main data Sheet (OPEN)



Attached are 2 sample files to assist with writing code.

Attached Files

	Enduro_3.xlsm (90.8 KB, 7 views)
	Book2.xlsx (17.7 KB, 8 views)

Hi and welcome to the board.
Please change your thread title to something descriptive of your problem. (you seem to know that from your experience on EF)

As you have posted on a Help forum, in the VBA section, everybody has understood you are looking for VBA help.
Thanks

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I have tried to change the title But I couldn't do it

I have tried to change the title But I couldn't do it

Which title would you suggest?
Did you click the " Go advanced" button to change your title ?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Please cancel this thread

Peter

Thread closed as per OP request

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post