Data arranging as per FIFO using macro

[djwaz69]

Hey guys

i request your expertise help, i am unable to solve this. The requirements are mentioned in excel sheet 1 , request you kindly help me with this with macro.

Table 1 : This table will say no of total products (count of product code) by different source (Coloumn E)

Table 2 : this will say day wise and source wise no of producs (product code count)

Table 3 : Table 3 should contain a button and a input cell to ask till which data all product should be manufactured. Once date entered in that input cell ; all work shall be divided equaly to all machines mentioned in sheet "machine" in the ratio in the capacity A 1.2; B 1.2; C 1, D 0.8 and E 0.8
Incase any extra product is left out it should be allocated to A (the most powerful machine

[djwaz69]

I am not able to edit now, the page gets stuck , however fifo is first in first out. please help

[Winon]

Hello djwaz69,

99.99% of this Forum knows what "FIFO" means, no need to explain that, thank you.

Please keep on trying to change your Thread Title, and once done, you may receive a response.

Regards

[FDibbins]

If you are unable to change your thread title. PM me with what you want it to be (or just post it here) and i will change it for you

[djwaz69]

Thanks for the gude guys, i tried previewing and savings it worked, however there seems some problem in directly saving after changing.

Dear Experts please help

[Winon]

@ FDibbins,

As usual, to the rescue!

Baie dankie my maat.

Kind Regards