LinkBack URL
About LinkBacks
Hello all,
here is my scenario. I work on a production line and everyday parts are issued out of our warehouse and stored in a staging area. I have a spreadsheet that my employees use to check in "parts" to the staging location. I have tracking turned on, on the spread sheet to monitor how much work is being done by each person. Well now I want to cross reference what parts they are checking-in, compared to what parts are issued out of the warehouse.
Here is where I run into a problem. The part numbers are prelisted in the first column of the spreadsheet. further down the row my employees enter inforation as to when that part made it into the staging location. Everyday I will need to pull the part numbers that have been checked into the staging location.
Because of the way my spread sheet is set up and the volume of parts that come through each day I need to automate this. Now the change tracking tells me where changes are made but only pulls over the cell that information is changed in.
Pretty much I need a script that will take all cell ranges from the history sheet and pull the whole row over to a new sheet.
since this is probably unclear attached is an example of the set up from my spread sheet
Register To Reply
below the post.
Originally Posted by Leith Ross
Bookmarks