how to remove a record

[gleamng]

Good day all, Please i need your collective help with this small excel database which i created. I have an excel workbook with lot of worksheets linked to one sheet in the workbook and also linked to other workbook, but whenever i delete a record by deleting the whole row, it affects all linked sheets and workbook from the row i delete downwards. My question now is how do i delete a row from the record without it affecting linked sheets and workbooks??? Thank you all for your anticipated help/contributions.

 

[Roderick_E]

linked how? As in referencing it? =sheetX!A1

 

[gleamng]

Good day all,
Please i need your collective help with this small excel database which i created. I have an excel workbook with lot of worksheets refrencing to one sheet in the workbook and also referenced to other workbook, but whenever i delete a record by deleting the whole row, it affects all referenced sheets and workbook from the row i delete downwards. My question now is how do i delete a row from the record without it affecting referenced sheets and workbooks??? Thank you all for your anticipated help/contributions.

 

[gleamng]

Good day all,
Please i need your collective help with this small excel database which i created. I have an excel workbook with lot of worksheets referencing to one sheet in the workbook and also referenced to other workbook, but whenever i delete a record by deleting the whole row, it affects all referenced sheets and workbook from the row i delete downwards. My question now is how do i delete a row from the record without it affecting referenced sheets and workbooks???
Thank you all for your anticipated help/contributions.

 

[gleamng]

yes, referencing