Hi guys,
I have a pivot table where I use code to break out several files based on a certain category. I created some more code that will highlight any cell that is changed. My question is... How do I transfer this code to these new files I created? Basically, the pivot table creates a new sheet and then I move that sheet to a new book and save it? Unfortunately, the code is not moved to the new sheet.
Thanks for any help
I have a pivot table where I use code to break out several files based on a certain category. I created some more code that will highlight any cell that is changed. My question is... How do I transfer this code to these new files I created? Basically, the pivot table creates a new sheet and then I move that sheet to a new book and save it? Unfortunately, the code is not moved to the new sheet.
Thanks for any help
