Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro needed
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Macro help needed | Excel Programming | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro needed to set macro security in Excel to minimum | Excel Programming | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |