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.

Consider using a single block copy/paste to copy ALL the rows from tab1 to
tab2 and then remove the empty rows in tab2 by a macro.
--
Gary's Student
gsnu200710


"mldancing" wrote:

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.

Try this:

(Save your data, first, to another worksheet!!)

Highlight Column A, press the F5 key, Special, Blanks

The blank cells will be highlighted.

Press Ctrl - (Control and the Minus key)
Select Delete Rows

That should do it.

If it works, you could record a macro to use on your saved data.

HTH,

CaroleO

"mldancing" wrote:

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.