Im looking to create count sheets from a list of data that I have. I have about 15,000 locations that have stock in and I want to create count sheets that have around 100 records in. Is there any way of doing a drop down menu and selecting a count sheet number and it brings up that information?
This is what the raw Data will look like
<colgroup><col width="182" style="width: 137pt; mso-width-source: userset; mso-width-alt: 6656;">
<col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;">
<col width="357" style="width: 268pt; mso-width-source: userset; mso-width-alt: 13056;">
<col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;">
<col width="64" style="width: 48pt;">
<tbody>
</tbody>
Thank you in advance
Stuart
This is what the raw Data will look like
SKU | Location | Description | Qty On Hand | |
S17W-1300001324-BCK-14 | Z1-AA-01-A | PONTE MIDI DRESS | 1 | |
S17W-1800000838-KKI-14 | Z1-AA-01-A | Khaki Contrast Trim Runner Shorts In Khaki | 1 | |
S17W-4100003318-SNE-S/M | Z1-AA-01-A | CUFF DRAWSTRING BOTTOMS | 1 | |
S17W-3700003692-CAM-L | Z1-AA-01-A | Cream Bib Front Frill Shirt | 1 | |
S17W-1000000729-SND-14 | Z1-AA-01-C | Black Sport Elastic Back Crop Vest In Sand | 1 | |
S17W-1300002427-CLT-14 | Z1-AA-01-C | Cobalt Scoop Neck Maxi Dress | 1 | |
S17W-1000003813-WUE-10 | Z1-AA-01-C | Blue Loose Fit V Neck Top | 1 | |
A17W-1000008673-GEY-8 | Z1-AA-01-C | Cold Shoulder Sweat Top Grey-8 | 1 | |
A17W-1000008651-OVE-12 | Z1-AA-01-C | Cropped Wide Sleeve Sweat Top Olive-12 | 1 | |
S17W-1000001839-CAM-14 | Z1-AA-03-A | Tie Front Cap Sleeve Top | 1 | |
S17W-1900002235-SNE-10 | Z1-AA-03-A | BASIC MIDI SKIRT | 1 | |
S17W-1400001875-BCK-10 | Z1-AA-03-B | Black Short Sleeve Basic Bodysuit | 1 | |
S17W-1000001838-GRL-10 | Z1-AA-03-B | Tie Front Cap Sleeve Top | 1 | |
A17W-3300008835-WNE-14 | Z1-AA-05-A | Cross Detail T Shirt Wine-14 | 1 | |
S17W-3400002094-WTE-10 | Z1-AA-05-B | White Scuba Plunge Bralet | 1 | |
A17W-3000010389-BCK-4 | Z1-AA-05-C | STUDDED BUCKLE BOOT | 1 | |
S17W-1400001937-GRL-8 | Z1-AA-07-A | Grey Marl V Neck Thong Bodysuit | 1 | |
S17W-1000002450-GRL-8 | Z1-AA-07-B | BASIC WIDE STRAP VEST TOP | 1 | |
S17W-4100006910-BCK-10 | Z1-AA-07-B | PAPER BACK TIE TROUSER | 1 | |
A17W-4100006604-BCK-12 | Z1-AA-07-C | Eyelet Trousers Black-12 | 1 | |
S17W-1200003753-DUE-10 | Z1-AA-09-A | Denim High Waisted Ripped Mom Jeans | 1 | |
S17W-1100007164-NVY-L | Z1-AA-09-A | RAIN MAC NEON ZIP | 1 | |
S17W-1200009462-BUE-XL | Z1-AA-09-B | Basic Skinny Jean Blue-Xl | 1 | |
S17W-1300003038-MTI-8 | Z1-AA-09-B | White Floral Wrap Front Mini Dress | 1 | |
S17W-1800000472-NVY-14 | Z1-AA-11-A | Navy Capri Shorts | 1 | |
A17W-2700007260-WTE-M/L | Z1-AA-11-B | Ruffle Edge Crop Jumper White-L | 1 | |
A17W-4100006604-BCK-6 | Z1-AA-11-C | Eyelet Trousers Black-6 | 1 | |
A17W-1000008611-BRY-12 | Z1-AA-11-C | Cropped Elasticated Hem Sweat Top Berry-12 | 1 | |
S17W-1000001821-BCK-12 | Z1-AA-11-C | Black Bardot Crop Top | 1 | |
S17W-1300004849-PUM-12 | Z1-AA-13-A | BANDEAU FRILL MIDI DRESS | 1 | |
S17W-1100007039-BCK-14 | Z1-AA-13-A | ZIP WET LOOK SLEEVE JACKET | 1 | |
S17W-1300001176-NDE-8 | Z1-AA-13-C | Strappy Wrap Front Midi Dress In Nude | 1 | |
S17W-1300002141-ESE-14 | Z1-AA-15-C | Electric Cerise Plunge Maxi Dress | 1 | |
S17W-1300004081-NVY-16 | Z1-AA-15-C | Floral Print High Neck Mini Dress | 1 | |
S17W-4100008967-RED-14 | Z1-AA-17-A | Gingham Fit & Flared Trousers Red-14 | 1 | |
A17W-1300010028-WNE-8 | Z1-AA-17-A | MESH WITH FRILL DRESS | 1 | |
S17W-1400001991-BCK-14 | Z1-AA-17-B | Black Mesh Turtle Neck Body | 1 | |
S17W-1300002508-ERY-14 | Z1-AA-17-C | Bandeau Skater Dress | 1 |
Thank you in advance
Stuart