I am great full for all the help so far. Now I have another issue which is beyond my understanding. I was given a formula
=IF(INDIRECT("Sheet1!E"&ROW(A15))="y",INDIRECT("Sheet1!F"&ROW(A15)),0)
This is located in a secondary sheet and references a master sheet. It allows me to add a row on the master and have the correlating data in the second sheet move accordingly.
My problem now is the inability to remove excess blank rows on the secondary sheet
Example. I place a “Y” in the relative master cells E14, E15, E17. This is then referenced on the second sheet in rows 14, 15, 17. Now I need to shorten the second sheet for printing by removing all blank rows (in this case being row 16). I am dealing with over 1000 lines of data which is why I am after help
Unfortunately due to the data involved I am unable to currently supply a sample
Can someone help.
Thanks once again
=IF(INDIRECT("Sheet1!E"&ROW(A15))="y",INDIRECT("Sheet1!F"&ROW(A15)),0)
This is located in a secondary sheet and references a master sheet. It allows me to add a row on the master and have the correlating data in the second sheet move accordingly.
My problem now is the inability to remove excess blank rows on the secondary sheet
Example. I place a “Y” in the relative master cells E14, E15, E17. This is then referenced on the second sheet in rows 14, 15, 17. Now I need to shorten the second sheet for printing by removing all blank rows (in this case being row 16). I am dealing with over 1000 lines of data which is why I am after help
Unfortunately due to the data involved I am unable to currently supply a sample
Can someone help.
Thanks once again