RE: Sorting + adding new data issue between sheets
Hi
I have a spreadsheet containing several sheets, one is called "OTR Sites Dashboard" and It has the following columns: -
Country
Site Name
Site Adddress
Site Proposed Go Live
This feeds all the other sheets ='OTR Sites Dashboard'!E16 for example as a formula. However when I sort OTR Sites Dashboard sheet, all the other columns in the remaining sheets that dont directly reference the original sheet gets mixed up. For example, I have a sheet called "Surveys & Checklists", the first 4 columns reference the OTR Sites dashboard for Country, site name, Site address and Site Proposed go live but the other columns are just basic information such as "Is physical site survey completed - yes", so a yes it put in the box. When The original sheet is sorted or a site added, all this information gets mixed up and ends up in the wrong rows. Any ideas how I can solve this as this is a major problem.
thanks
James
Hi
I have a spreadsheet containing several sheets, one is called "OTR Sites Dashboard" and It has the following columns: -
Country
Site Name
Site Adddress
Site Proposed Go Live
This feeds all the other sheets ='OTR Sites Dashboard'!E16 for example as a formula. However when I sort OTR Sites Dashboard sheet, all the other columns in the remaining sheets that dont directly reference the original sheet gets mixed up. For example, I have a sheet called "Surveys & Checklists", the first 4 columns reference the OTR Sites dashboard for Country, site name, Site address and Site Proposed go live but the other columns are just basic information such as "Is physical site survey completed - yes", so a yes it put in the box. When The original sheet is sorted or a site added, all this information gets mixed up and ends up in the wrong rows. Any ideas how I can solve this as this is a major problem.
thanks
James