Excel Sheet

Frequent Visitor

I have a "master" worksheet in excel. When I type in the first sheet, there is a formula that makes it show up in the other sheets. However, when I add lines to the bottom of the spreadsheet, they are not showing up in the other sheets. I have tried to play around with it and cannot figure it out. Any help is appreciated!





1 Reply


Use a formula such as


=IF('Master Worksheet'!A2=", "", 'Master Worksheet'!A2)


and fill it down as far as you need.