Excel 2007

Hi Claire

Thanks for your post

The way to do this is by using a copy paste special procedure as follows: copy the cells you want to copy then copy - from there go to the workbook you need them in then click the cell and go to the edit paste special then click formulas and click OK if you need anymore help on this reply to this post

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn