Link rows to duplicate on other tabs

[ellbeardo]

Hi,

I have a problem which is probably simple to solve but I have looked for a solution that I have been unable to find.

I will attach an example workbook.

So, I am putting together a work programme to show what work we have on currently, this work is shown in its total on the first tab.

Each piece of work falls into a certain type of work, in the workbook I have shown as type A, type B & type C.

Is there a way of me completing all my work through the Work Programme tab, which is linked to its relevant tab and updated automatically without the need to copy and paste each row when updated?

Thanks

[ellbeardo]

I've now found a very simple solution, all it takes is copying the row from the main tab, and then using paste options: Paste Link (N) to duplicate.

Thanks

[Pete_UK]

You will need a column in the Work programme sheet to identify which type of work each record applies to, and then you could use a couple of formulae to automatically copy the data across to the appropriate sheet once the Cleared column has a date in it.

Hope this helps.

Pete