I have 2 tabs on a spreadsheet. Tab 1 contains a bunch of data with fixed
columns but random # of rows (whenever the data get updated).

Is there a macro script or formula to copy specified range of data in tab 1
to tab 2, and omitting all the blank rows?

I know it's kind of general .. but any advice will be appreciated. Thank you.