Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Question 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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
order form Abe Excel Worksheet Functions 3 January 30th 07 02:40 AM
order form Abe Excel Discussion (Misc queries) 3 January 30th 07 02:29 AM
i want a order form lindum services Excel Discussion (Misc queries) 1 January 23rd 07 12:07 AM
Order form to BOL? jpletting New Users to Excel 3 September 12th 05 02:35 PM
Order Form Scott MacLellan Excel Discussion (Misc queries) 1 April 28th 05 01:52 PM


All times are GMT +1. The time now is 04:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"