I have 1 master sheet with a list of projects. On other sheets, I use the same list of projects and add on other columns of data. Can I automatically add a new row (project) to all the sheets by just adding once on the Master Project sheet? I would also sometimes delete rows (projects) from the Master list and need that reflected in the other sheets.



Thanks.

Hi,
if you try Googling around you will find lots of answers.

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Is it a 1:1?

i.e. if project xyz is on row 12 of the Master, is it also on the same row and only the same row on the other sheets? Is the project ID always in column A?

If that's the case, you can just select all the tabs, insert the row, and type in the project ID.