Home |
Search |
Today's Posts |
#1
|
|||
|
|||
do not allow rows broken
Using Excel 2002 here, anybody know how I can allow a user to move entire
rows around the worksheet, but not let them select only a portion of the row only to move? I'm having trouble with people not selecting the entire row when moving, then I have a mess. Thanks, Paula |
#2
|
|||
|
|||
If your users are "moving entire rows around the worksheet", then that
probably means they are "grouping", or "sorting" the data to their needs.........if that be the case, perhaps you can anticipate how they might want the sorting done and set up macros with pushbuttons to do it for them, thereby insuring the integrity of the data.......... Vaya con Dios, Chuck, CABGx3 "Paula" wrote in message ... Using Excel 2002 here, anybody know how I can allow a user to move entire rows around the worksheet, but not let them select only a portion of the row only to move? I'm having trouble with people not selecting the entire row when moving, then I have a mess. Thanks, Paula |
#3
|
|||
|
|||
They aren't actually sorting the data. They are making groups based on
criteria that I don't have access to. So instead of moving the entire row (which would be what should happen) they are only moving part of the row (like the first 4 cells and accidentally leaving the last 3 cells in the row), and then I don't know where the rest of the row belongs. Do that make sense? Any way to "lock" the row so that it cannot be disasembled? "CLR" wrote: If your users are "moving entire rows around the worksheet", then that probably means they are "grouping", or "sorting" the data to their needs.........if that be the case, perhaps you can anticipate how they might want the sorting done and set up macros with pushbuttons to do it for them, thereby insuring the integrity of the data.......... Vaya con Dios, Chuck, CABGx3 "Paula" wrote in message ... Using Excel 2002 here, anybody know how I can allow a user to move entire rows around the worksheet, but not let them select only a portion of the row only to move? I'm having trouble with people not selecting the entire row when moving, then I have a mess. Thanks, Paula |
#4
|
|||
|
|||
I dunno, this is a weird problem........maybe just CONCATENATE all seven
cells of each row with spaces between, into one cell in column A and hide the other columns and then just let them move those single cells with all the data in them around......... like insert a blank column A and put this in A1 and copy down........then do Copy PasteSpecial Values to get rid of the formulas........ =B1&" "&C1&" "&D1&" "&E1&" "&F1&" "&G1&" "&H1 Then you could separate them out again when they finished, if need be, with Data TextToColumns... hth Vaya con Dios, Chuck, CABGx3 "Paula" wrote in message ... They aren't actually sorting the data. They are making groups based on criteria that I don't have access to. So instead of moving the entire row (which would be what should happen) they are only moving part of the row (like the first 4 cells and accidentally leaving the last 3 cells in the row), and then I don't know where the rest of the row belongs. Do that make sense? Any way to "lock" the row so that it cannot be disasembled? "CLR" wrote: If your users are "moving entire rows around the worksheet", then that probably means they are "grouping", or "sorting" the data to their needs.........if that be the case, perhaps you can anticipate how they might want the sorting done and set up macros with pushbuttons to do it for them, thereby insuring the integrity of the data.......... Vaya con Dios, Chuck, CABGx3 "Paula" wrote in message ... Using Excel 2002 here, anybody know how I can allow a user to move entire rows around the worksheet, but not let them select only a portion of the row only to move? I'm having trouble with people not selecting the entire row when moving, then I have a mess. Thanks, Paula |
#5
|
|||
|
|||
okay, this helps.
Thanks "CLR" wrote: I dunno, this is a weird problem........maybe just CONCATENATE all seven cells of each row with spaces between, into one cell in column A and hide the other columns and then just let them move those single cells with all the data in them around......... like insert a blank column A and put this in A1 and copy down........then do Copy PasteSpecial Values to get rid of the formulas........ =B1&" "&C1&" "&D1&" "&E1&" "&F1&" "&G1&" "&H1 Then you could separate them out again when they finished, if need be, with Data TextToColumns... hth Vaya con Dios, Chuck, CABGx3 "Paula" wrote in message ... They aren't actually sorting the data. They are making groups based on criteria that I don't have access to. So instead of moving the entire row (which would be what should happen) they are only moving part of the row (like the first 4 cells and accidentally leaving the last 3 cells in the row), and then I don't know where the rest of the row belongs. Do that make sense? Any way to "lock" the row so that it cannot be disasembled? "CLR" wrote: If your users are "moving entire rows around the worksheet", then that probably means they are "grouping", or "sorting" the data to their needs.........if that be the case, perhaps you can anticipate how they might want the sorting done and set up macros with pushbuttons to do it for them, thereby insuring the integrity of the data.......... Vaya con Dios, Chuck, CABGx3 "Paula" wrote in message ... Using Excel 2002 here, anybody know how I can allow a user to move entire rows around the worksheet, but not let them select only a portion of the row only to move? I'm having trouble with people not selecting the entire row when moving, then I have a mess. Thanks, Paula |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
Copying Rows when hiding other rows | Excel Worksheet Functions |