Hello. I have a worksheet that is linked from A1 to J400 to corresponding cells of another worksheet. The originating worksheet has formulas that produce blanks in several rows throughout the data. I would like to know how I can have the linked worksheet ignore the empty rows and stack the data together?
Thank you
Thank you
