+ Reply to Thread
Results 1 to 3 of 3

How to check existence & copy and paste cell value to external workbook

  1. #1
    Registered User
    Join Date
    04-17-2020
    Location
    North Dakota, USA
    MS-Off Ver
    Office 2013
    Posts
    12

    How to check existence & copy and paste cell value to external workbook

    I have some VBA that I cobbled together some years ago with much help, needless to say, I vaguely remember what is what. It's an asset management sheet that has a button (Check OUT) function that I would like to check for the existence of the user input provided in TextBox2 in this workbook and if a match is found, return a message stating "Equipment already out" and do nothing else.

    If using Check IN Check for the presence of the user input and if found it's supposed 'to copy all of the row associated (except the column D "Location" data) with the found entry as well as TextBox1 input. This would result in the backup sheet containing the original date/time stamp from column A, original name from column B, original equipment ID from column C, the name that is "Checking IN", and generate another date/time stamp.

    As of right now, it copies the entire row to the external workbook you'll see cited as AssetBKUP.xls. I tried tweaking it on my own to add the extra date stamp but I'm fumbling at best I think and I am not just trying to minimize the damage. Attached is a screenshot of what it should look like in the bk-up workbook and the file itself.

    P.S. when opening type "open" in the name box to make the sheet visible.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: How to check existence & copy and paste cell value to external workbook

    Please Login or Register  to view this content.
    PS...Why remove the Userform X button only to add your own?

    I would...personally...make use of comboboxes so that once the equipment is initially booked out, only that is available to book back in...
    Last edited by sintek; 10-07-2021 at 03:26 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    04-17-2020
    Location
    North Dakota, USA
    MS-Off Ver
    Office 2013
    Posts
    12

    Re: How to check existence & copy and paste cell value to external workbook

    *this was a mistake post*
    Last edited by LeeRedBeard; 10-09-2021 at 06:48 PM. Reason: cant delete.

+ 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. [SOLVED] Creating loop check cell value if so copy some cells to a external program
    By dutchmaste in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-04-2017, 05:54 AM
  2. [SOLVED] Open external workbook and copy paste from it
    By colin.dickson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2015, 10:12 AM
  3. [SOLVED] Macro to copy cell contents (a website) -> paste in exctract external data url address box
    By kak0 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-31-2014, 05:20 PM
  4. [SOLVED] copy from external file, paste in current workbook
    By rodich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2012, 04:29 AM
  5. Replies: 0
    Last Post: 05-24-2011, 12:33 AM
  6. Copy data against each checked check box and paste in a new excel workbook
    By rnd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-28-2010, 06:04 AM
  7. [SOLVED] Check for existence
    By CWillis in forum Excel General
    Replies: 3
    Last Post: 05-31-2006, 08:25 AM

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