Hello,

I have a Master Sales spreadsheet which gets updated when 10 of my users update their individual spreadsheet. This is done in the most simple way – Copy >> Paste Special >> Paste Link from the Individual to Master.

I have allocated 60 rows each to my sales team – such as Rows 1 to 60 to Mr. A, Rows 61 to 120 to Mr. B and like, for each month. The problem is that Mr. A may not use all the 60 rows in a particular month or may also exceed 60 rows in some months. If they do not use all the rows, my master sheet will have blank rows in the middle, but if they exceed 60 rows, row 61 and over does not show up in my Master list.

Is there a solution that my Master sheet updates the first empty row from any of the individual sheets? For example if Mr. A completes his row 7, my fist empty row should get updated and when Mr. B updates one of his rows, my next available empty row should get updated, and the like.

Is this possible ?

Thank you for your help.