+ Reply to Thread
Results 1 to 3 of 3

Lookup and delete

Hybrid View

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    Park Hills, Kentucky
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Lookup and delete

    Here is a sample file. I want to remove the lines under the headings for each item in the list on the right.

    The list on the right will be duplicated and get longer each time a count is completed. After each inventory count, I will re-export the entire item list, add the counted items to the list on the right, and remove the lines under the headings on the left so the items that have already been counted will not be counted again.

    The idea is that I randomize the exported list each time (exported from Quickbooks) , select the first 70 items or so to do a physical inventory cycle count, and the next time I need to count, randomize the new exported list, but not have any repeated items that were already counted.

    The reason I need to re-export the entire list each time is so that the current quantities for each item are correct.

    Thanks for any help.

    Ken
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1