Auto delete rows based on scan

Hi,

I’m trying to create a spreadsheet for the following: at start of day colleagues are given 2 pieces of kit which are scanned onto sheet 1 together with their name. End of day the kit is scanned back in and I need for the spreadsheet to delete any rows that are scanned. However I also need sheet 2 to contain all that information permanently.

.
Define "scanned" ... how is the data entered into the sheet ?

Providing a copy of your workbook would be preferred for a better understanding of your layout / logic.

I've attached the spreadsheet. At the end of the day the first sheet should be completely empty as the kit is returned and the data should now lie on second sheet. The Kit is barcoded so serial number are scanned to the spreadsheet

.
Here is a small project that is almost identical to yours, except new data is entered by keyboard. I'm not
familiar with the use of a scanner ... but I surmise you have a macro that transferred the data to the sheet ?

You can place a version of this macro at the beginning of your scan macro so it transfers the data to sheet 2 prior to entering
the new data. Let me know if you have issues with this code (you'll need to edit the ranges / sheet names ) :

Please Login or Register  to view this content.

Hi Logit
I've managed to get a VBA that hides a row of my choosing based on changing data in a column, in this case column D. Once I change the data in the cell it hides that entire row. The problem I now have is I want to change the data in D based on the data in B1 so I have put a formula to that effect. Unfortunately my VBA still sees this as unchanged data, please help

.
Take a different approach for a solution. You state you want to locate the data and change it to something else.

Paste this macro into a module - paste a Command Button on the sheet. The macro will ask for two terms ... First, what term to search for (the number you are seeking) then
what should that number be changed to.

Please Login or Register  to view this content.