using a form for cut and paste
I have a two-page spreadsheet for active and inactive accounts. I'd like to
create a form just for users to be able to call up an account and cut and paste from the active to the inactive sheet, and back to active if necessary. For now I'd just like to know if this is even possible using a form in Excel? Obviously the paste would have to be on the next blank line of the inactives sheet, and the formerly active line would have to be deleted. I need this because some people are not careful when they cut and paste, and it creates a mess in the data. |
using a form for cut and paste
Hi.
It's a bit too complex to explain here. Have a look at the file at : http://www.filedropper.com/dino_2 -- Regards. Daniel "Dino" a écrit dans le message de news: ... I have a two-page spreadsheet for active and inactive accounts. I'd like to create a form just for users to be able to call up an account and cut and paste from the active to the inactive sheet, and back to active if necessary. For now I'd just like to know if this is even possible using a form in Excel? Obviously the paste would have to be on the next blank line of the inactives sheet, and the formerly active line would have to be deleted. I need this because some people are not careful when they cut and paste, and it creates a mess in the data. |
using a form for cut and paste
Thanks Daniel! I've created forms in Access but never in Excel, needed to
know if I could even do such a thing. I'll need to expand on the form, but your solution will save me some time. "Daniel.C" wrote: Hi. It's a bit too complex to explain here. Have a look at the file at : http://www.filedropper.com/dino_2 -- Regards. Daniel "Dino" a écrit dans le message de news: ... I have a two-page spreadsheet for active and inactive accounts. I'd like to create a form just for users to be able to call up an account and cut and paste from the active to the inactive sheet, and back to active if necessary. For now I'd just like to know if this is even possible using a form in Excel? Obviously the paste would have to be on the next blank line of the inactives sheet, and the formerly active line would have to be deleted. I need this because some people are not careful when they cut and paste, and it creates a mess in the data. |
All times are GMT +1. The time now is 06:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com