Forum Discussion
JackypHC
Jun 13, 2024Copper Contributor
How can I autogenerate cells from one sheet to another ONLY if it's filled out?
I am trying to auto generate sales orders from an order submission. So, I want the cells to only be filled out if that product is selected and the way I know the product is selected is if there's a quantity on it. So, I only want the items that have a quantity be autogenerated to the sales order. I REALLY hope I make sense.
So for example, if a customer only wants two items, those will get filled out with a quantity on the order submission then on the second sheet (sales order) I want those items to generate automatically. I would only want the product, price and quantity to fill out.
Is there an IF formula that I can do to help with this?
- Tejas_shahBrass Contributor
- JackypHCCopper ContributorThank you so much!! I appreciate your help.