+ Reply to Thread
Results 1 to 3 of 3

Send and Search button's

  1. #1
    Registered User
    Join Date
    02-23-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    23

    Send and Search button's

    Hi

    I am pretty new at this, so i have tried to modify code i have found online, and it works ok.
    But i would like to make it a bit more advanced.
    I want the data in the summary sheet to be moved to specific sheets based on the row cell, so if the value in the row cell is 1 its send to the row1 sheet and so on, and at the same time if the value in the Pre,cam,scan,An cells is set to ok, the data is to be copied to the Pre,Cam,Scan,An shetts.

    I also want the search button to be able to fetch data from the different sheets based on the item number entered, and when fetched i want to be able to change the value in the Row,Pre,Cam,Scan,An cells press send and the item is send to the new sheets, and cleared from the old sheets.

    Also when you press send the cells in the summary sheet should be cleared.

    Thanks in advance
    Last edited by Jayzon; 03-01-2013 at 08:02 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,872

    Re: Send and Search button's

    This should take you to the correct worksheet.
    Please Login or Register  to view this content.
    Your example does not have the other sheets you mention

  3. #3
    Registered User
    Join Date
    02-23-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Send and Search button's

    Oups, sorry it does now

    I have added a couple of other small changes. Timestamp and user info.

    and thanks for the help, works like a charm.
    Last edited by Jayzon; 02-23-2013 at 10:15 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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