Planning Board

Dibadawg

New Member
Joined
Jul 25, 2017
Messages
2
Hi there,

I am some what of an amateur excel user, but i am trying to design a packaging planning board for my manufacturing facility.

Basically i am trying to create a front page that my customer relationship managers can use to create a bill of material, bulk issue and reconciliation pages.

I already have the standard format for all 3 documents, but i am trying to populate these documents from one cover page.

basically we manufacture products that all have different components. a CRM should be able to list these on the from page, as well as link a specific system code, which would pull through into a bill of material. sometimes there could be 3/4 components, sometimes there could be up to 10.

is there any way that i will be able to do something like this?
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Hello Dibabawg, welcome on the forum!

If what to know if it's possible in Excel, I can say : Yes!
Would it be hard : it depends.
Is there an easiest way : Access might be better to do that kind of work with forms and giant database.
 
Upvote 0
Unless you already have access, you might need to plan more before getting it. That software is not in every microsoft office bundle and might create extra cost.
 
Upvote 0

Forum statistics

Threads
1,223,886
Messages
6,175,198
Members
452,617
Latest member
Narendra Babu D

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top