Create Count Sheets

Oakey

New Member
Joined
Jan 9, 2017
Messages
49
Office Version
  1. 365
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

[TABLE="width: 573"]
<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>[TR]
[TD="class: xl65, width: 182, bgcolor: transparent"]SKU[/TD]
[TD="class: xl65, width: 77, bgcolor: transparent"]Location[/TD]
[TD="class: xl65, width: 357, bgcolor: transparent"]Description[/TD]
[TD="class: xl65, width: 83, bgcolor: transparent"]Qty On Hand[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1300001324-BCK-14[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-01-A[/TD]
[TD="class: xl66, bgcolor: transparent"]PONTE MIDI DRESS[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1800000838-KKI-14[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-01-A[/TD]
[TD="class: xl66, bgcolor: transparent"]Khaki Contrast Trim Runner Shorts In Khaki[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-4100003318-SNE-S/M[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-01-A[/TD]
[TD="class: xl66, bgcolor: transparent"]CUFF DRAWSTRING BOTTOMS[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-3700003692-CAM-L[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-01-A[/TD]
[TD="class: xl66, bgcolor: transparent"]Cream Bib Front Frill Shirt[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1000000729-SND-14[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-01-C[/TD]
[TD="class: xl66, bgcolor: transparent"]Black Sport Elastic Back Crop Vest In Sand[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1300002427-CLT-14[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-01-C[/TD]
[TD="class: xl66, bgcolor: transparent"]Cobalt Scoop Neck Maxi Dress[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1000003813-WUE-10[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-01-C[/TD]
[TD="class: xl66, bgcolor: transparent"]Blue Loose Fit V Neck Top[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]A17W-1000008673-GEY-8[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-01-C[/TD]
[TD="class: xl66, bgcolor: transparent"]Cold Shoulder Sweat Top Grey-8[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]A17W-1000008651-OVE-12[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-01-C[/TD]
[TD="class: xl66, bgcolor: transparent"]Cropped Wide Sleeve Sweat Top Olive-12[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1000001839-CAM-14[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-03-A[/TD]
[TD="class: xl66, bgcolor: transparent"]Tie Front Cap Sleeve Top[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1900002235-SNE-10[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-03-A[/TD]
[TD="class: xl66, bgcolor: transparent"]BASIC MIDI SKIRT[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1400001875-BCK-10[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-03-B[/TD]
[TD="class: xl66, bgcolor: transparent"]Black Short Sleeve Basic Bodysuit[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1000001838-GRL-10[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-03-B[/TD]
[TD="class: xl66, bgcolor: transparent"]Tie Front Cap Sleeve Top[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]A17W-3300008835-WNE-14[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-05-A[/TD]
[TD="class: xl66, bgcolor: transparent"]Cross Detail T Shirt Wine-14[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-3400002094-WTE-10[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-05-B[/TD]
[TD="class: xl66, bgcolor: transparent"]White Scuba Plunge Bralet[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]A17W-3000010389-BCK-4[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-05-C[/TD]
[TD="class: xl66, bgcolor: transparent"]STUDDED BUCKLE BOOT
[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1400001937-GRL-8[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-07-A[/TD]
[TD="class: xl66, bgcolor: transparent"]Grey Marl V Neck Thong Bodysuit[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1000002450-GRL-8[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-07-B[/TD]
[TD="class: xl66, bgcolor: transparent"]BASIC WIDE STRAP VEST TOP[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-4100006910-BCK-10[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-07-B[/TD]
[TD="class: xl66, bgcolor: transparent"]PAPER BACK TIE TROUSER[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]A17W-4100006604-BCK-12[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-07-C[/TD]
[TD="class: xl66, bgcolor: transparent"]Eyelet Trousers Black-12[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1200003753-DUE-10[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-09-A[/TD]
[TD="class: xl66, bgcolor: transparent"]Denim High Waisted Ripped Mom Jeans[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1100007164-NVY-L[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-09-A[/TD]
[TD="class: xl66, bgcolor: transparent"]RAIN MAC NEON ZIP[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1200009462-BUE-XL[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-09-B[/TD]
[TD="class: xl66, bgcolor: transparent"]Basic Skinny Jean Blue-Xl[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1300003038-MTI-8[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-09-B[/TD]
[TD="class: xl66, bgcolor: transparent"]White Floral Wrap Front Mini Dress[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1800000472-NVY-14[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-11-A[/TD]
[TD="class: xl66, bgcolor: transparent"]Navy Capri Shorts[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]A17W-2700007260-WTE-M/L[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-11-B[/TD]
[TD="class: xl66, bgcolor: transparent"]Ruffle Edge Crop Jumper White-L[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]A17W-4100006604-BCK-6[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-11-C[/TD]
[TD="class: xl66, bgcolor: transparent"]Eyelet Trousers Black-6[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]A17W-1000008611-BRY-12[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-11-C[/TD]
[TD="class: xl66, bgcolor: transparent"]Cropped Elasticated Hem Sweat Top Berry-12[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1000001821-BCK-12[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-11-C[/TD]
[TD="class: xl66, bgcolor: transparent"]Black Bardot Crop Top[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1300004849-PUM-12[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-13-A[/TD]
[TD="class: xl66, bgcolor: transparent"]BANDEAU FRILL MIDI DRESS[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1100007039-BCK-14[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-13-A[/TD]
[TD="class: xl66, bgcolor: transparent"]ZIP WET LOOK SLEEVE JACKET[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1300001176-NDE-8[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-13-C[/TD]
[TD="class: xl66, bgcolor: transparent"]Strappy Wrap Front Midi Dress In Nude[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1300002141-ESE-14[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-15-C[/TD]
[TD="class: xl66, bgcolor: transparent"]Electric Cerise Plunge Maxi Dress[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1300004081-NVY-16[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-15-C[/TD]
[TD="class: xl66, bgcolor: transparent"]Floral Print High Neck Mini Dress[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-4100008967-RED-14[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-17-A[/TD]
[TD="class: xl66, bgcolor: transparent"]Gingham Fit & Flared Trousers Red-14[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]A17W-1300010028-WNE-8[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-17-A[/TD]
[TD="class: xl66, bgcolor: transparent"]MESH WITH FRILL DRESS[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1400001991-BCK-14[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-17-B[/TD]
[TD="class: xl66, bgcolor: transparent"]Black Mesh Turtle Neck Body[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]S17W-1300002508-ERY-14[/TD]
[TD="class: xl66, bgcolor: transparent"]Z1-AA-17-C[/TD]
[TD="class: xl66, bgcolor: transparent"]Bandeau Skater Dress[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

Thank you in advance

Stuart
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Lets talk about what you want.
1. Tell me what a "count sheet" is. Sounds like a financial term we may not all know about.
2. Are you saying you want to create a new sheet for every unique value in Column("B"
3. And then copy the row to the sheet name shown in column "B"
4. Are we dealing with columns A,B,C and "D" in this layout you have shown us?
5. And if that's what you want do you want the header row from the "Master sheet copied into these new sheets.
6. And what is the name of this sheet with all your data?

See when asking for help here we need exact details.

And what does this mean?
"Is there any way of doing a drop down menu and selecting a count sheet number and it brings up that information?"

Do you mean activate that sheet so you can see that sheets information. Or what? Not sure what "bring up that information means"


Or are you just saying you want a filter on the master sheet which when activated by a button script will display the data you want to see?
 
Upvote 0

Forum statistics

Threads
1,223,246
Messages
6,170,996
Members
452,373
Latest member
TimReeks

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top