Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i move a row of cells when they're fully complete?
Once I've entered all the data to the last cell in the row, I'd like this
"active" sheet to send that row to an "archive" worksheet. Basically I will then only have a live sheet to work from which will only remain live until I've filled in the final cell. Any ideas? Tom. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i move a row of cells when they're fully complete?
On Sun, 22 Oct 2006 09:36:01 -0700, tammas
wrote: Once I've entered all the data to the last cell in the row, I'd like this "active" sheet to send that row to an "archive" worksheet. Basically I will then only have a live sheet to work from which will only remain live until I've filled in the final cell. Any ideas? Tom. Probably through the use of the following worksheet selection change event Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("yourlastcell)) Is Nothing Then 'code which copies the active sheet data to the archive sheet 'and then clears the contents of the active sheet End If End Sub You might need to modify this if cells in the row are completed out of order, and where the last physical cell is not necessarily the last one to be filled in. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
freezing formulas when cells move | Excel Worksheet Functions | |||
In Excel, how do you move the contents of 3 cells into 1 cell? | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Automatic coloring of blank cells when sheet work complete | Excel Worksheet Functions | |||
Paste and automatically move cells | Excel Discussion (Misc queries) |