+ Reply to Thread
Results 1 to 16 of 16

Project supplies tracker

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,410

    Project supplies tracker

    Shee1 , sheet2 raw data from system extract

    I need the supplies of each code to fall into boxes sup1 sup2 and so

    While I also need when they were supplied created below the qty supplies table
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,410

    Re: Project supplies tracker

    Just placing the case little infront , yes clear know , wait time is 24 hours

  3. #3
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,410

    Re: Project supplies tracker

    Sounds tough not too tough for the experts ,
    It will solve one big headache if I got the answer ,
    I need to be knowing the free stock against project
    goods at live , the person who sells these projects
    could be a busy guy and I can't depend on him

  4. #4
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,410

    Re: Project supplies tracker

    Anyone for this one , I have data that is too big,
    I fully depend on this answer

    Someone please

  5. #5
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Project supplies tracker

    So if I understand correctly, do you want the description on sheet two (E column) to be put into the the correct Sup columns on sheet 1, based on a matching CODE? Please explain clearer what you need if my analogy is wrong.
    Regards,
    Rudi

  6. #6
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,410

    Re: Project supplies tracker

    the quantity supplied on g2 , if the formula is correct

    It should write 4 on g2 supplied on 06/12/2013 , 103.005.03
    and then it should 2 on h2 supplied on 28 / 01 / 2014

    At the bottom of the table on g23 it should pull 06 / 12 / 2013
    and then on h23 it should pull 28 / 01 / 2014

  7. #7
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,410

    Re: Project supplies tracker

    This than if I drag downwards and rightwards ,
    it should fill up all supplies for all codes for the project

  8. #8
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,410

    Re: Project supplies tracker

    In other words you are looking for the code
    when it was supplied first and how much ,
    second time how much and so on , I will put
    sum on column d2 to arrive to balance left
    to supply the F2 will also give details as to %
    supplied

  9. #9
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,410

    Re: Project supplies tracker

    Just in case if this helps ,

    expected results from sheet 2 to 1

    DESCRIPTION CODE QTY supp BAL SUP1 SUP2 SUP3 SUP4 SUP5 SUP6 SUP7 SUP8 SUP9
    100.005.33 33 6 27 18% 4 2

    Raw data on sheet 2

    DATE WARE ACC REF DESCRIPTION REF QTY
    06/12/2013 X X 100.005.33 X X -4
    28/01/2014 X X 100.005.33 X X -2

  10. #10
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Project supplies tracker

    TX...
    I'm looking into this now. Hopefully I can make sense of it

  11. #11
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Project supplies tracker

    Hi,

    Here is the Project Tracker with macro....
    I trust it meets your requirements.
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,410

    Re: Project supplies tracker

    HOT , and delicious , Yes Rudis

    Before I close this string as solved , just a final doubt ,
    because this is beyond delicious , since I am bound to use
    it very commonly , what is the limit of supplies , will it
    pick data that is going more than 9 times , or do I have
    to edit the macro somewhere?

  13. #13
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,410

    Re: Project supplies tracker

    Suppose say if I insert 10 to 20 columns on cell N8 , which is sup 8 before sup 9
    the final column and call it sup 9 sup10 sup11 and so on , will the macro still
    understand fetching as needed ?

  14. #14
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Project supplies tracker

    Hi,

    No need to edit the macro.
    If a code on sheet 2 occurs 100 times, the macro will record them into 100 SUP columns on sheet 1 (Just make sure you have enough SUP headings )
    If your codes in sheet 1 (B column) grow longer, that is also fine. Just make sure you have an empty row separating CODE-V and CODE-D as the macro needs to distinguish where the Values separate from the dates. BTW: That is why I had to name the codes CODE-V and CODE-D.

    So all in all...the macro will automatically adapt to the size and data volume on the sheets...

  15. #15
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,410

    Re: Project supplies tracker

    You have solved me more than one headache on this ,
    the project manager is so busy , I did not like relying on
    him , now I am a free bird , I can know stands without
    contacting him , two I had to drill manually to see into
    accounts to compute what he has supplied , wow now
    I am ONE SECOND TECHNOLOGY , too good RUDIS , thank
    you very much for more than two macros that are just
    working beyond the bar

  16. #16
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Project supplies tracker

    Its a pleasure makinmomb.
    Since the macros are new..please run them and verify that they work accuarately. Macros should be put through trial runs to verify accuracy.
    Glad it will help you.
    Cheers

+ 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. Task \Project Tracker = determine output time based on variable inputs
    By Journeyman3000 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-10-2013, 04:37 PM
  2. [SOLVED] Project Timeline Tracker
    By AnnaG87 in forum Excel General
    Replies: 1
    Last Post: 04-30-2013, 11:39 PM
  3. Replies: 0
    Last Post: 06-14-2012, 02:49 PM
  4. Need help with excel Project tracker Macro
    By david.snellen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2010, 09:47 AM
  5. time tracker-a running tracker date wise
    By arnab0711 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2008, 03:08 PM

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