+ Reply to Thread
Results 1 to 3 of 3

I need VBA code to update log worksheet and maintain a history of all orders.

Hybrid View

  1. #1
    Registered User
    Join Date
    06-02-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    80

    Talking I need VBA code to update log worksheet and maintain a history of all orders.

    I have a table that includes list of clients, products they order, and requested delivery date. When the client calls in to place an order, I pull up the excel table (orders worksheet) and fill in the items quantities and the required delivery date for the client who called. Once I fill the information for the client who called in, I need to update a "log" worksheet with the information that I just entered. The log worksheet will eventually contains history of all the orders which I received in the past. I appreciate if somebody can provide VBA code to do the job. I attached the excel file.. thanks a lot! Order Log.xlsx

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: I need VBA code to update log worksheet and maintain a history of all orders.

    You should use only two sheets.
    One would be the Orders data and the other the Clients data
    Use data validation for the client's name and Vlookup formula for the account number and salesman name.
    You add new lines as needed for new order. You can manage to create the same cells format with some conditional formatting.

    You'll have a big data base and you'll even be able to use Pivot table to create all kind of reports.
    What do you say?
    I could help you design it if you want.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: I need VBA code to update log worksheet and maintain a history of all orders.

    Try this code.
    Attached Files Attached Files
    David
    (*) Reputation points appreciated.

+ 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