ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Order Form Consolidation Help (https://www.excelbanter.com/excel-discussion-misc-queries/192432-order-form-consolidation-help.html)

Sarah H.

Order Form Consolidation Help
 
I'm making order forms for my company that have part numbers in columns and then sizes in rows. So the customer inserts a qty in the box under the size they want for that part number. In order to upload this into our online system, all the quantities and part numbers need to be in a 2-column list (with one column being quanties and one column being part numbers with sizes). Last year I went through and did an "=" for each cell, but that took forever and this year I'm in a time crunch. Does anyone know a quick way for me to convert my data into a list like this? Thanks!


All times are GMT +1. The time now is 01:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com