Compare daily data using excel data

Hi Anonymous,

Thanks for the reply.

The columns will not alter but the rows will as more customers are added.  I can see how this would work on the occasional report to display the changes.  However I am looking to do this daily and so the combined excel sheet would become larger and larger after a month or two (I think).

Is there a way that if I drop the raw data for each day into a workbook, I can compare between each and report either numerical or % changes?

I appreciate that I may have got this completely wrong so your advice is really appreciated.

Thanks,

Alan