-
Sorry for the delayed response, I've been fairly busy this week.
I think if I summarise what we do in the operation, then it might help clarify what I need the spreadsheet to acheive or maybe it may just confuse it more?
We pull data from the same table as the pickers receive data to their guns, this accompanies it as a verification of tasks - They then wrap their pallets and send them direct to the customer, so they're fully accountble. The old working practice was removed with no phase in/out period - I took it upon myself to devise a spreadsheet that could be used for this function, hence why it's poorly structured/coded (this is my first ever project) --
Anyway, sorry to go off on a tangent.
We pull the data used in the curent order
Load Reference | Walk Sequence | Product Code | Location | Pallet # | QTY | Consignment | Destination
All fields are required for the final spreadsheet, with the exception of walk sequence, but we have to pull this to sort by. The data is varying in ize, from one line to 200+ lines.
I've built a basic template of a sheet, which has the Macro above recorded. It pulls data from the output file from the RDS task table (which isn't natively saved as .xls)
***Row 13 is now the first row of the variable pick task data***
As you can see, the loop is used to copy the data until the cell is blank, I copy over 6 blank cells too just so I can draw a boarder around them on import to create "check boxes" I then hide 3 columns which data is only required for the header of the document and simply remap the data using an =H13 forumla in the header....
Customers are in a large cell at the top, which has 2 VLOOKUP's played against it to pull customer specific information. We select the customer from a predefined list and it then pulls the required data via the VLOOKUP into the header.
I know it's long winded, but being very new to VBA, I didn't require a complex function, I needed something to work, and quick - this sheet was born (I can provide the templates and dummy data, if it makes things easier to understand)
Soin short, I'd love to structure the code better, but to be perfectly honest, I wouldn't know where to start,but I am willing to learn and can usually pick things up fairly fast. The current spreadsheet does work in practice now.
Also, FYI, your footer code worked fine to place it at the base of the document, sadly, it's cell width is (obviously) predefined byt the cells above it, is it possible to make it a bit more complex and have it merge a certain cell number wide?
Thank you again for your time and assistance, and thanks everyone else for looking.
Regards
Steven
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules