Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Daily Update/Database

  1. #1
    Board Regular
    Join Date
    May 2002
    Posts
    290
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On a daily basis, I track and record sales of different products at different prices and at different geographic locations. On any given day, there may be "multiple" sales (of different volumes of each good) at different prices. For example, on day 1, there may be 3 sales (100 units, 200 units and 300 units) of product A at Point One at $3.50, $3.25 and $3.00, respectively, and 2 sales (400 units and 450 units) of product B at Point Two at $4.75 and $5.00.

    What I would like to do is create an "Input Sheet" wherein I would record daily these sales, and the "program" would automatically transfer the daily data over to another worksheet where it would be "posted" by day, and the daily and month-to-date (and year-to-date, if possible) weighted average would be calculated, by product by day.

    Any suggestions?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm not being a smart @$%, but
    you either need to break up this project and
    post several smaller topics as you go or hire a consultant. There are several well qualified members of this board who do this professionally.
    Tom

  3. #3
    Board Regular
    Join Date
    May 2002
    Posts
    290
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    TsTom,
    What is it about this "project" that would require I do as you say? it seems to me to be a fairly straight-forward project-it's just that I don't know VBA!
    Thanks for your response,
    Jeff

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Jeff
    The project may be straight-forward to you because your workbook is on your desktop.
    My previous point being, this is not a copy and paste project. It will be difficult to get some code examples without being specific. Before it's said and done, you may not need any code written at all. You will need to take this in bites and specify specific ranges, results expected, ect...
    Your topic is way too broad.
    I'm not trying to be critical, just helpful.
    The benefit of supplying details usually lead to some very good, well thought out, replies from various perspectives.
    Remember that it will cost someone time to help you. They may not want to risk wasting their time to provide a non-solution.
    Catch my drift?
    Thanks,
    Tom

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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