Results 1 to 2 of 2

Thread: copy & paste

  1. #1
    Join Date
    Apr 2009

    Unanswered: copy & paste

    Hi Sir/Madam

    I’ve got a workbook with two work sheets.

    Worksheet 1 = “PAYMENTS & CHANGE”
    Worksheet 2 = “RECORDS”

    In worksheet 1 I enter the customer name(I will actually use a name and ID number) and payment.

    I want to create a command button on worksheet 1 (lets name it PROCCESS) with a macro that will search through my list of customers in worksheet 2 and paste the payment and change information in the appropriate cells next to the corresponding customer’s name. I am going to have about 2000+ customers. So manually entering the data will take a very long time.

    I have attached an example of the worksheet if it helps. The worksheets are protected so that people can’t change information. The password for both sheets is 1234.

    I will appreciate any help.
    Thank you.
    Attached Files Attached Files

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 17
    Right, what you want is possible, but I'm not sure that it's a good idea. Every time someone makes another payment or other transaction, you'll be over-writing their prior one. Also, if you ever end up with two customers of the same name, you'll only record transactions against the first one.
    If you like, I can knock something up for it.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

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