G
Guest
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.
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.