From Andy McNicol@21:1/5 to All on Tue Jan 19 05:06:49 2021
Hoping one of you Excel Guru's will be able to help with the following problem;
I have a spreadsheet with around 500 rows of that can over time be populated with data. Each row contains a mix of formulas, lists and free text. What I want to do is only show those rows that have data in them and maybe an additional 10 empty rows. Now
I can hide the excess rows by using the Hide function which is easy enough, however want the 10 empty rows to be a constant as such how do i get it to automatically un-hide the next row once data is entered into the first of the 10 so that I keep the
formulas and such intact.
Anyway any help would be appreciated as having a mind melt here.