#1
|
||||
|
||||
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 |
#2
|
||||
|
||||
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
__________________
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 |
#3
|
||||
|
||||
Title change
I have tried to change the title But I couldn't do it
|
#4
|
||||
|
||||
Title change
I have tried to change the title But I couldn't do it
|
#5
|
||||
|
||||
Which title would you suggest?
Did you click the " Go advanced" button to change your title ?
__________________
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 |
#6
|
||||
|
||||
Please cancel this thread
Peter Last edited by Potholes; 08-20-2019 at 09:54 PM. |
#7
|
||||
|
||||
Thread closed as per OP request
__________________
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 |
|