I have a table with some data.
In my sheet, boxes have been created of two cells each with border only around group of two cells.
I need to drag and drop a box from one location to another location within table.
Now when I drag and drop for example I11 and I12 cell to L9 and L10 then right border around I11 and I12 box is removed.
I know that there is no solution to preserve border while drag and drop.
Many times drag and drop is required to be done.
So, is it possible to write a macro that will select outline border from font menu and apply it on old location (e.g. I11 and I12) as well as on new location (e.g. L9 and L10).
Whenever such drag and drop is used, it must apply outline border on old box and new box.
Note: Drag and drop is most convenient and faster way to shift data for me and other users using this sheet.
Thanks.
In my sheet, boxes have been created of two cells each with border only around group of two cells.
I need to drag and drop a box from one location to another location within table.
Now when I drag and drop for example I11 and I12 cell to L9 and L10 then right border around I11 and I12 box is removed.
I know that there is no solution to preserve border while drag and drop.
Many times drag and drop is required to be done.
So, is it possible to write a macro that will select outline border from font menu and apply it on old location (e.g. I11 and I12) as well as on new location (e.g. L9 and L10).
Whenever such drag and drop is used, it must apply outline border on old box and new box.
Note: Drag and drop is most convenient and faster way to shift data for me and other users using this sheet.
Thanks.