I am working on a cycle count program. What I am looking to achieve is that when my count status goes from 'Do Not Count' to 'Count', that another sheet will be populated by the new items to be counted. I have tried some vlookup and if statements which I have not been successful. On the first sheet:Item Code Item Description Material Type Count Frequency Last counted Date Next count date Count Status. On the second sheet I would like to see the same information so that it can easily be supplied to inventory to then count. If anyone has some advice, possibly I am using the wrong statements I would appreciate the help.
Attachments
Last edited: