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. |
Macro needed
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. |
All times are GMT +1. The time now is 01:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com