+ Reply to Thread
Results 1 to 1 of 1

VBA: Submit Excel Data to Another Excel with condition.

  1. #1
    Registered User
    Join Date
    01-21-2019
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    9

    VBA: Submit Excel Data to Another Excel with condition.

    Hello Everyone,

    Im currently struggling to solve this simple problem. So basically,

    I have a time and motion study tracker with start, end and submit button button. I managed to worked on start and end.

    But I am struggling to submit an specific data to my masterfile. In my workbook, I have a dropdown selection of status.. If the value of the dropdown is Pending, then those cases should be submitted in my Archive workbook when I hit the Submit button and the status in my last column will be updated to Submitted. So it will exclude those cases on my next submission and should not overlap the data in my master file.

    Below is my current code.

    Im having an error that destination not found.
    Im pretty sure my path is correct =(

    Please Login or Register  to view this content.
    I also attached the image of my source and masterfile.

    Source.jpg
    masterfile.png

    Thank you In Advance guys for your help.. =)

    I;m not sure if Loop is reqd for this code. Just wanted to ask someone who c an fix this =(
    Last edited by Chrislacs; 05-09-2022 at 02:04 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel VBA automatic fill and submit web forms from excel data
    By ruznemat in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-25-2016, 06:57 PM
  2. can i store my submit data from excel to mysql database
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-06-2014, 02:03 AM
  3. Replies: 0
    Last Post: 09-04-2014, 02:07 AM
  4. how can submit data from one excel sheet to another excel sheet
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-04-2014, 01:29 AM
  5. how to submit a data in excel vba in different workbook or sheet
    By UAZHAR in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2013, 04:40 AM
  6. "Submit" Macro - Word form data to Excel
    By Greed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2011, 10:19 AM
  7. Replies: 0
    Last Post: 04-26-2005, 01:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1