If anyone can have a look at this problem and see if there is a possible solution it would be appreciated. Attached you will see a spreadsheet which basically has an extract of a bay set-up for a warehouse(bincodes). The warehouse basically runs alpha/num based on the first 4 digits of the bin-codes (the last 3 digits are the levels and positions within the and are irrelevant).
This runs fine for picking but on the filling side for technical reasons there are various areas which come under certain teams and so ideally they need moving to different positons on the spreadsheet. I have code to select the area. In the code below it will select the area highlighted on the spreadsheet.
but what I am not sure about is how to move them around the spreadsheet so that excel can work with them.
Below is how the teams need to look with the red text(See teams 7&8) being the areas needing to be moved
.
TEAM 1
AD41 TO AH62
TEAM 2
AJ01 TO AK62
TEAM 3
AL01 TO AL75
AM01 TO AM71
TEAM 4
AN01TO AP71
TEAM 5
AR01 TO AR71
AS01 TO AS71
TEAM 6
AT23 TO AT71
AU23 TO AT71
TEAM 7
AV38 TO AX99
AR72 TO AR99
AL76 TO AL99
TEAM 8
AT01 TO AT19
AU01 TO AU19
AY19 TO AY 23
AZ01 TO AZ22
AC01 TO AD40
The end objective is hopefully A) to use on various forms as a print area set-up B) Probaly a much more difficult task is to hopefullly be able to use a pivot table to analyse the numbers for each team.
If any of the above is either unclear or if any of it is impossible please let me know. Please note that the speadsheet is an extract which is why the ranges I state cover some locations not on the spreadsheet.
The other option I can think of is to extract the various bincodes to separate sheets for each team, which is perfectly adequate but I would need to be told how to do this as I haven't attempted this or anything similar before
Bookmarks