|
How do I move deleted items to another spreadsheet?
I am tracking dealer inventory. Dealer will add & delete units almost daily.
I don't want to allow the possibility of a unit being paid off now, and then in a few days, be added back on. Can I move deleted (paid off) items to a place where I can keep the VIN numbers for comparison to current units being added? I'm already checking my existing spreadsheet for duplications and I'm also stopping with an error message if I try to add a new VIN that's already on my sheet. |
How do I move deleted items to another spreadsheet?
Easy enough to do with a macro but DETAILS would be needed.
-- Don Guillett Microsoft MVP Excel SalesAid Software "Statesman" wrote in message ... I am tracking dealer inventory. Dealer will add & delete units almost daily. I don't want to allow the possibility of a unit being paid off now, and then in a few days, be added back on. Can I move deleted (paid off) items to a place where I can keep the VIN numbers for comparison to current units being added? I'm already checking my existing spreadsheet for duplications and I'm also stopping with an error message if I try to add a new VIN that's already on my sheet. |
How do I move deleted items to another spreadsheet?
My recommendation is to not remove the VIN numbers but rather to add fields
such as "paid off" that you can filter by. That way if someone tries to add a duplicate VIN number you can use simple validation to indicate the error and allow the uer to look up the exisitng VIN. Simple sorting and filtering should take care of what you want to do. A better solution still might be to use a database with the VIN number as the key but that is up to you... -- HTH... Jim Thomlinson "Statesman" wrote: I am tracking dealer inventory. Dealer will add & delete units almost daily. I don't want to allow the possibility of a unit being paid off now, and then in a few days, be added back on. Can I move deleted (paid off) items to a place where I can keep the VIN numbers for comparison to current units being added? I'm already checking my existing spreadsheet for duplications and I'm also stopping with an error message if I try to add a new VIN that's already on my sheet. |
How do I move deleted items to another spreadsheet?
Great!! What kind of details?
"Don Guillett" wrote: Easy enough to do with a macro but DETAILS would be needed. -- Don Guillett Microsoft MVP Excel SalesAid Software "Statesman" wrote in message ... I am tracking dealer inventory. Dealer will add & delete units almost daily. I don't want to allow the possibility of a unit being paid off now, and then in a few days, be added back on. Can I move deleted (paid off) items to a place where I can keep the VIN numbers for comparison to current units being added? I'm already checking my existing spreadsheet for duplications and I'm also stopping with an error message if I try to add a new VIN that's already on my sheet. |
How do I move deleted items to another spreadsheet?
Thanks Jim. I don't deal with this everyday...could you point me in the right
direction with the database approach? Best regards... "Jim Thomlinson" wrote: My recommendation is to not remove the VIN numbers but rather to add fields such as "paid off" that you can filter by. That way if someone tries to add a duplicate VIN number you can use simple validation to indicate the error and allow the uer to look up the exisitng VIN. Simple sorting and filtering should take care of what you want to do. A better solution still might be to use a database with the VIN number as the key but that is up to you... -- HTH... Jim Thomlinson "Statesman" wrote: I am tracking dealer inventory. Dealer will add & delete units almost daily. I don't want to allow the possibility of a unit being paid off now, and then in a few days, be added back on. Can I move deleted (paid off) items to a place where I can keep the VIN numbers for comparison to current units being added? I'm already checking my existing spreadsheet for duplications and I'm also stopping with an error message if I try to add a new VIN that's already on my sheet. |
How do I move deleted items to another spreadsheet?
Using MS Access or some other database set up tables to hold the vehicles and
the transactions associated with those vehicles. Create forms to allow the users to intract with the tables where by they can create and edit the vehicles and the transactions associated with them. You can also create reports dealing the the transactions and the vehicles. The benefits of this system is that there is only one database that holds all of the transactions and each user can log into the database... If you want you can use XL as the front end of the database but it does require a failry sophisticated knowledge of XL and databases along with VBA... -- HTH... Jim Thomlinson "Statesman" wrote: Thanks Jim. I don't deal with this everyday...could you point me in the right direction with the database approach? Best regards... "Jim Thomlinson" wrote: My recommendation is to not remove the VIN numbers but rather to add fields such as "paid off" that you can filter by. That way if someone tries to add a duplicate VIN number you can use simple validation to indicate the error and allow the uer to look up the exisitng VIN. Simple sorting and filtering should take care of what you want to do. A better solution still might be to use a database with the VIN number as the key but that is up to you... -- HTH... Jim Thomlinson "Statesman" wrote: I am tracking dealer inventory. Dealer will add & delete units almost daily. I don't want to allow the possibility of a unit being paid off now, and then in a few days, be added back on. Can I move deleted (paid off) items to a place where I can keep the VIN numbers for comparison to current units being added? I'm already checking my existing spreadsheet for duplications and I'm also stopping with an error message if I try to add a new VIN that's already on my sheet. |
| All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com