Hi
but this would create a lot of blank rows? Why not use 'Data - Filter -
Advanced Filter' for creating a snapshot on a separate sheet or 'Data -
Filter - Autoflilter' to show only the relevant rows.

Another approach would be to put this data in a database and create a
query for this. You may then import this query in Excel. Also consider
using pivot tables for aggregations


--
Regards
Frank Kabel
Frankfurt, Germany


choice wrote:
column A = date of purchase
column b = name of customer
column c = phone number
...
column GC = discounts

the range is from A2:GC(count of transactions)

basically now im using =if(a2=today(),b2,"")
same equation for column c,d,e...out to GC

then that equation goes down about 10000 rows to cover all the
possible trasanactions