If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WickW" wrote in message
...
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.