I have 2 workbooks - one has the source data sheet and one has destination
sheets for each customer- I have linked the 2, however, the data is all on
one sheet for the source and when i make an adjustment to this ie. insert or
delete a row it affects how the data is seen o the destination sheets
eg source sheet has 3 columns - company name - route - description
destination has a sheet for each company. When i change anything on the
source sheet is shows on the relevant destination worksheet which is great
but when I insert or delete a row it affects the following companies
information on the destination sheet.
I thought a solution would be to insert some sort of page break at the end
of each companies info or to tell the link to only look for company 1 for
sheet 1 and company 2 for sheet 2 etc but the page break is unaffective and
you are unable to add anything to the link formula.
Has anyone any suggestions as i dont really want to split the source data
into a sheet per company as this defeats the need to see all that data
together at times.