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
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
Just placing the case little infront , yes clear know , wait time is 24 hours
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
Anyone for this one , I have data that is too big,
I fully depend on this answer
Someone please
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
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
This than if I drag downwards and rightwards ,
it should fill up all supplies for all codes for the project
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
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
TX...
I'm looking into this now. Hopefully I can make sense of it
Hi,
Here is the Project Tracker with macro....
I trust it meets your requirements.
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?
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 ?
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...
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks