I need to know is there a easy way to create a cycle count schedule. This is what I started with COL A - how I want to count the item (monthly, weekly, bi-yearly etc). COL B - the class and item #, example 050-6125, and I need to count around 35 items a day Monday thru Friday. Last year was the 1st time we setup a complete schedule for the year and it was a pain. I used the spreadsheet that list how I want each item and then I set up a spreadsheet like this.
TAB - 1ST QTR
COL A,
Fri 1/2
050-6125
050-6124
030-7711
COL B
MON 1/12
050-8132
050-5555
030-4411
It took me awhile and this year I'm trying to delete items that we no longer have and add the new items. Any suggestions would greatly be appreciated.
Thanks.
TAB - 1ST QTR
COL A,
Fri 1/2
050-6125
050-6124
030-7711
COL B
MON 1/12
050-8132
050-5555
030-4411
It took me awhile and this year I'm trying to delete items that we no longer have and add the new items. Any suggestions would greatly be appreciated.
Thanks.