Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data as string and paste into web form | Excel Programming | |||
How to take chart and paste into Access form | Excel Programming | |||
HOW DO I PASTE DATA INTO WEB FORM? | Excel Discussion (Misc queries) | |||
paste image into a form | Excel Programming | |||
Paste a file short cut in VB form | Excel Programming |