Right, maybe this time I'll be more successful :P
First the code:
Now it's time for some adjustments:
1. I had to change Flash Pivot sheet name to FlashPivot (linkedcell doesn't want to accept names with white spaces). This was the first issue I didn't know before: Sheet9 was not a worksheet name but number, while the name was Flash Pivot.
2. I noticed, that there are two hidden worksheets (Dec sold... and dec opport...). I had to move them before CV Revenue sheet, otherwise code was referring to one of them instead of the copied one. And that was the second issue.
Well, at least the code worked for me, although it usually took about 30-60 seconds for comboboxes to be updated.
Hope it will work for you as well.
Bookmarks