I am not very well versed in excel, so go easy with the jargon and if solution is something more complex than pretty much copy/paste pls explain for dummies.
OK, so I have a workbook to this description;
Sheet 1: Over 3,000 names with contact details
Column B Column C Column D Column E Column F Column G Column H
Title First name Surname Position Organisation Email Category
Sorted by
1 - Organisation
2 - Surname
3 - First name
Sheets 2 - 9: Are partial lists of Sheet 1 (respective of category) that are linked to Sheet 1.
Obviously sorted same as Sheet 1.
I WANT TO
Be able to insert a new row in Sheet 1, without it affecting Sheets 2 - 9, and then insert the new row into the appropriate Sheet (category) with a link back to Sheet 1.
Is there a way of doing this?
The main priority is to be able to edit info in cells in Sheet 1 with the info updating automatically in respective sheets - which has been done by linking using paste special.
I want to be able to insert a new row in case extra contacts are needing to be added, without having to copy and paste special each sheet again. At the moment that is the best solution I have and would prove time consuming to do every time I add a new contact.
Bookmarks