Hi - I have an action tracker; actions are split across 7 action owners. I want to create a tab per action owner, which i can then use another macro to export into a separate workbook and send out to them.
I managed to do this, but as the action tracker itself contains formulas, when it copied and pasted over into the new workbook, a lot didn't make sense. When I have changed the code to use .PasteSpecial, it seems to bypass the IF formula and now just copies all actions into all tabs.
NB This is the code for 1 of 7 of the action owners, but in the interests in keeping the code as short as poss, i have just pasted the first 1.
If i write the final section as:
It copies over as you would expect, but the formulas come through as formulas not values, and therefore some cells don't make sense.
Any help would be greatly appreciated!
Bookmarks