Need your help with a Formula to calculate month on hand
as follows:
Current total November inventory is 1000
Demand remaining in Nov 500
Demand Dec 400
Demand Jan 300
So with 1000 we cover all Nov remain inventory 1000-500, remaining 500
With 500 we cover December demand 500-400, remaining 100...
HOLA, I BUILD A DASHBOARD THAT HAS A MENU (TAB TTITLED HOME), FROM HERE I HAVE A LINK TO TABS ;DASHBOARD, IN THE DASHBOARD YOU CLICK A GRAPH AND IT TAKES TO TO CHART 1 OR CHART 2 DEPENDING ON YOUR SELECTION . HOW CAN I MAKE THE HOME TAB THE ONE THAT OPENS WHEN YOU OPEN THE FILE ?,
ALSO ....HOW...
Thank you for your quick reply this is what I need;Copy document number to each line, as the document that I have shows it as a heather for each document
2000 7000270431 $
199983 7000270431 10.19
410100 7000270431 -4.41
410200 7000270431 -5.78
199983 7000270431 -10.19
123000 7000270431...
Need macro to copy the document number to each line and then continue with the next document and copy, and so on...please help
2000 7000270431 $
199983 $10.19
410100 $(4.41)
410200 $(5.78)
199983 $(10.19)
123000 $10.19
2000 7000270432 $
199983 $49.20
410100 $(26.20)
410200...