I have a Macro that copies and pastes lines of data from one workbook page to
another (first page is an Active Page for data still being worked on and the
second is a Historical page that archives inactive data). Once a line has
become inactive, I use my Macro and move it to the Historical Page. What I
am left with is a page with gaps that have several blank rows above other
lines of active data.

I'm looking for a way to create a Macro that pulls up all the remaining
lines of data on the Active Page without compromising the original Macro
settings. Since the original Macro is set for certain ranges, most tend to
collapse data and along with that - change the settings of the original lines
(meaning line A1 through D1 would no longer exist if I use a standard Macro
row collapse).

Any thoughts on how this could be done great. I really appreciate all of
the wonderful tips and advice I've gotten from this site in the past.

Thank you so much - Jenny B.