Hi All,
Hopefully someone will be able to help with this. I have a workbook set up that contains a "master" worksheet where I am inputting sales orders. There are then other worksheets for each factory that we source products from. I have set it up to automatically pull the relevant data from the master worksheet into the sheet for the correct factory. The problem is that there are gaps on the factory sheets as not all rows are relevant for each factory. Is anyone aware of a method that would automatically hide the blank rows and also update which rows are hidden as I change the data in the master worksheet?
Thanks in advance for the help.
Dan
Hopefully someone will be able to help with this. I have a workbook set up that contains a "master" worksheet where I am inputting sales orders. There are then other worksheets for each factory that we source products from. I have set it up to automatically pull the relevant data from the master worksheet into the sheet for the correct factory. The problem is that there are gaps on the factory sheets as not all rows are relevant for each factory. Is anyone aware of a method that would automatically hide the blank rows and also update which rows are hidden as I change the data in the master worksheet?
Thanks in advance for the help.
Dan