08-19-2019, 06:41 PM
|
|
Novice
|
|
Join Date: Aug 2019
Location: Brisbane QLD
Posts: 7
|
|
VBA Help Please
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.
Last edited by Potholes; 08-19-2019 at 11:17 PM.
Reason: adding more information
|