i am creating a document for work to help things flow faster and easier. This is a shipment plan, it is mainly done but its just the last part which im struggling with and hoping someone will have an answer.
I am trying to summarise 1 sheet with 2 tables (for printing purpose) on another sheet but i only want certain data and columns to be added up and unique to this specific table which im trying to finalise. Products and Quantities. The range of the 2 tables is B5:P16 and B21:P32 and the quantities would come from the 5th column and then every other column. My only hindrance might be is that I have a calculated weight 4/5th, 6/7th, etc.
Hopefully someone can help me with this
I am trying to summarise 1 sheet with 2 tables (for printing purpose) on another sheet but i only want certain data and columns to be added up and unique to this specific table which im trying to finalise. Products and Quantities. The range of the 2 tables is B5:P16 and B21:P32 and the quantities would come from the 5th column and then every other column. My only hindrance might be is that I have a calculated weight 4/5th, 6/7th, etc.
Hopefully someone can help me with this
