Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 08-19-2019, 06:41 PM
Potholes's Avatar
Potholes Potholes is offline VBA Help Please Windows 7 64bit VBA Help Please Office 2016
Novice
VBA Help Please
 
Join Date: Aug 2019
Location: Brisbane QLD
Posts: 7
Potholes is on a distinguished road
Default 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.
Attached Files
File Type: xlsm Enduro_3.xlsm (90.8 KB, 5 views)
File Type: xlsx Book2.xlsx (17.7 KB, 6 views)

Last edited by Potholes; 08-19-2019 at 11:17 PM. Reason: adding more information
  #2  
Old 08-19-2019, 11:27 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline VBA Help Please Windows 7 64bit VBA Help Please Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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  
Old 08-19-2019, 11:34 PM
Potholes's Avatar
Potholes Potholes is offline VBA Help Please Windows 7 64bit VBA Help Please Office 2016
Novice
VBA Help Please
 
Join Date: Aug 2019
Location: Brisbane QLD
Posts: 7
Potholes is on a distinguished road
Default Title change

I have tried to change the title But I couldn't do it
  #4  
Old 08-19-2019, 11:39 PM
Potholes's Avatar
Potholes Potholes is offline VBA Help Please Windows 7 64bit VBA Help Please Office 2016
Novice
VBA Help Please
 
Join Date: Aug 2019
Location: Brisbane QLD
Posts: 7
Potholes is on a distinguished road
Default Title change

I have tried to change the title But I couldn't do it
  #5  
Old 08-20-2019, 03:20 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline VBA Help Please Windows 7 64bit VBA Help Please Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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  
Old 08-20-2019, 05:33 AM
Potholes's Avatar
Potholes Potholes is offline VBA Help Please Windows 7 64bit VBA Help Please Office 2016
Novice
VBA Help Please
 
Join Date: Aug 2019
Location: Brisbane QLD
Posts: 7
Potholes is on a distinguished road
Default

Please cancel this thread

Peter

Last edited by Potholes; 08-20-2019 at 09:54 PM.
  #7  
Old 08-20-2019, 11:22 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline VBA Help Please Windows 7 64bit VBA Help Please Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Closed Thread

Thread Tools
Display Modes


Other Forums: Access Forums

All times are GMT -7. The time now is 11:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft