Hi,

i need a macro that will run automatically whenever a sheet's records will
be updated to copy data from that sheet (sheet1) to another sheet (sheet2,
overwriting the existing records).
I also want the new the records on sheet 2 to be grouped on "category" and
"product" fields and have some formula fields too.

I tried to achieve this by suing pivot table but it is not working for me
since I want each Category and Product to work as a hyperlink for navigating
the records of another table on sheet 2. (Master / Detail logic).

Plz help as I'm on a deadline.