Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009

    Unanswered: Copy, Find, Paste Macro - Urgent

    Hi sir.

    I’ve been searching the internet for a macro that can help with my excel workbook example (see attached example “MY CUSTOMERS”).

    I’ve got a workbook with four worksheets.

    Worksheet 1 = “account payment”
    Worksheet 2 = “add account”
    Worksheet 3 = “customers”
    Worksheet 4 = “paid up accounts”

    See my attached example
    Can you please help me solve my workbook. I’m stuck!!

    1) On worksheet2 ("add account") I would like it if the sheet could automatically show the next new account number to be used (after the first one was entered manually).
    And when I add a customer, it should automatically copy the formuls as in existing customer’s rows

    2) on worksheet1 ("account payment") is where I’m actually stuck!! How do I update my worksheet3 ("customers") after worksheet1 (“account payments”) process button is pressed.

    3) And maybe if it is possible, if a customers account balance is zero, to remove that customer from worksheet3 ("customers") and add it to worksheet4 ("paid up accounts")

    I don’t know.the above is just what i'm thinking of. Maybe there is a whole other and better way to solve my workbook.

    The help would be greatly appreciated.

    Thank you sir
    Attached Files Attached Files
    Last edited by wegkruip; 04-21-09 at 02:27.

  2. #2
    Join Date
    Sep 2008
    London, UK

    You can do all of this in MS Excel.. but really it's the wrong tool for the job. How about giving it a go in MS Access?

Posting Permissions

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