Feb 21 2023 07:55 AM
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!
Feb 21 2023 08:19 AM
Use a formula such as
=IF('Master Worksheet'!A2=", "", 'Master Worksheet'!A2)
and fill it down as far as you need.