Glue/Lock cells to external data before refresh
I have a spreadsheet with a table of data which has been imported from an
Access Database. If new records have been added on the database, then when I refresh the data in Excel it will add these new lines onto the spreadsheet. I need to be able to put certain comments in my spreadsheet against lines of data from the database. However, if new lines are inserted when I refresh the data, the comments can end up being next to the wrong record. Is there any way to keep my lines of comments attached to a particular record of external data, so they will move when the record does? |
All times are GMT +1. The time now is 03:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com