Hello all,
I am not a very experienced excel user, so im not sure if what im trying to accomplish is possible. If it is im not quite sure what the function would be called. A point in the right direction would be helpful. Im happy to read and teach myself but currently im not sure where to begin.
I work in the construction field and would like to make a sheet that can be used to cost our jobs up; then generate purchase orders from the information already entered. Currently we have 2 forms doing this and the redundancy is slowing productivity.
My first step is as follows. Our costing typically consists of 5-20 line items. Some of those line items will be purchased from the same vendor; often there are 3-5 different vendors per project. What im hoping to do is have a way to send the info on each line to another tab in my sheet (which would be my purchase order form). Perhaps this could be done via a drop down menu? This would be a great step in the right direction.
Again im not sure excel is the right program to do this as its very difficult to know the capabilities without knowing what the function i am actually looking for would be called. Any help is greatly appreciated. Thank you!
RFS
I am not a very experienced excel user, so im not sure if what im trying to accomplish is possible. If it is im not quite sure what the function would be called. A point in the right direction would be helpful. Im happy to read and teach myself but currently im not sure where to begin.
I work in the construction field and would like to make a sheet that can be used to cost our jobs up; then generate purchase orders from the information already entered. Currently we have 2 forms doing this and the redundancy is slowing productivity.
My first step is as follows. Our costing typically consists of 5-20 line items. Some of those line items will be purchased from the same vendor; often there are 3-5 different vendors per project. What im hoping to do is have a way to send the info on each line to another tab in my sheet (which would be my purchase order form). Perhaps this could be done via a drop down menu? This would be a great step in the right direction.
Again im not sure excel is the right program to do this as its very difficult to know the capabilities without knowing what the function i am actually looking for would be called. Any help is greatly appreciated. Thank you!
RFS
