I have a range of cells in a column in excel, that have some number in them along with text. For Example:
TA_47 TA_48 TA_49 TA_50 TA_51 TA_52 TA_53 TA_54 TA_55 TA_56 TA_57 TA_58 TA_59 TA_60
Now I apply bookmarks to some cells on other sheets, and delete one or two rows, such that the numbering gets disturbed. Then, i drag and fill the series and find that the bookmark information with the selected cells gets vanished. Is there any way to avoid this? Such that numbering can be adjusted and the bookmarks can be retained as they were.