I have two worksheets which both have a variable # of rows with a total row
at the end. I have a macro that merges these two worksheets together into
one sheet. Currently, it is including the blank row after the last row of
data and the row with the formula to total Column "F". This is the only info
on this line. When the merge occurs, it includes these two lines from the
first worksheet and this messes up the subsequent code that copies the
formulas in Columns "G" and "H". The formulas stop at the blank row and does
not continue to the last row of data. Also, the total in the middle of the
data is skewing my final total. What code can I include that will delete
these total lines from both worksheets prior to the merge?

thanks bunches

What code do you have that merges them?

--
__________________________________
HTH

Bob

"marcia2026" wrote in message
...
I have two worksheets which both have a variable # of rows with a total row
at the end. I have a macro that merges these two worksheets together into
one sheet. Currently, it is including the blank row after the last row of
data and the row with the formula to total Column "F". This is the only
info
on this line. When the merge occurs, it includes these two lines from the
first worksheet and this messes up the subsequent code that copies the
formulas in Columns "G" and "H". The formulas stop at the blank row and
does
not continue to the last row of data. Also, the total in the middle of
the
data is skewing my final total. What code can I include that will delete
these total lines from both worksheets prior to the merge?

thanks bunches

Bob de Bruin's Merge Sheets to one master. That part works perfectly except
for merging those totals lines

"Bob Phillips" wrote:

What code do you have that merges them?

--
__________________________________
HTH

Bob

"marcia2026" wrote in message
...
I have two worksheets which both have a variable # of rows with a total row
at the end. I have a macro that merges these two worksheets together into
one sheet. Currently, it is including the blank row after the last row of
data and the row with the formula to total Column "F". This is the only
info
on this line. When the merge occurs, it includes these two lines from the
first worksheet and this messes up the subsequent code that copies the
formulas in Columns "G" and "H". The formulas stop at the blank row and
does
not continue to the last row of data. Also, the total in the middle of
the
data is skewing my final total. What code can I include that will delete
these total lines from both worksheets prior to the merge?

thanks bunches