I'm not sure I understand. Basically, each day I have a text file that
has a customer with 8 other pieces of data. It all runs horizontally
and the number of customers varies from day to day. I import it into
M1, so if there were 3 cutomers today, it would take up cells M1 thru
M27. I have it setup so A1 thru I1 refers tp M1 thru M9,b2 thru I2
refers to M10 thru M18, etc. I refresh the data automatically each
day, then copy cells A thru I and paste them on another sheet, with
each day being pasted below the previous day. I am just wondering if
this last step of copying and pasting can be automated. You may have
answered this already, but I am new to excel and did not quite get it.
Thanks,
Peter