Complex Excel Formula & Organization -- 2
Budget: ₹600 – ₹1,500 INR
Summary
I have a excel project need to generate a formula with following:
Base of Story:
I m Handle a client who is steel coil distuributor and processor
The steel coil will be converted to sheet and some each product is identified with seperate Batch Numbers. The Batch number will be changed in followin circumstance.
1. When the Coil is convertied to cut sheets
2. When the Coil is Shifted from GOdown to Godown
3. Sheet is Shifted from Godown to Godown
From initial Purhase coil to final sheet there ill be multiple Batch numbers need to find the initial Batch number from the for Each Sheet and every conversion is identified by voucher number
I have a excel project need to generate a formula with following:
Base of Story:
I m Handle a client who is steel coil distuributor and processor
The steel coil will be converted to sheet and some each product is identified with seperate Batch Numbers. The Batch number will be changed in followin circumstance.
1. When the Coil is convertied to cut sheets
2. When the Coil is Shifted from GOdown to Godown
3. Sheet is Shifted from Godown to Godown
From initial Purhase coil to final sheet there ill be multiple Batch numbers need to find the initial Batch number from the for Each Sheet and every conversion is identified by voucher number