I have a problem that I hope someone can help.
I hava a macro that copies data from another spreadsheet into column a,b,&c
of a master spreasheet. Each time the macro is acitvated, the data is
copied onto the next row, a2,b2,c3, a3,b3,c3 etc.
The first row, cell a,b & c contain header names for the data in the
column. The Macro works great unless I use a split screen on the second row
a2. Once I do this, the macro copies data in the wrong cells and is useless.
The split screen is helpful to view the column headers and I would like to
use it if possible.

thanks for any assistance

mike