Main sheet + sub sheets / reports


Hi there

We have our master sheet set up but I want to pull information in to separate forms or reports.

We have a dropdown on the report that selects which team is doing the work- we need the information for this team to be displayed on its own for that particular team without them seeing the others teams work. With a report I have managed this but they have to have access to the main sheet which we don't like.

We could also do with each team being able to select a job complete box and that feeding back to the main sheet. They would also need access to upload photos for each job.

I have just tried sheet linking but I don't seem to be able to get the work displayed separately for each team.

Any pointers would be greatly appreciated.

Best Answer