Michelle has attended:
Excel Introduction course
Excel 2003
I'm having difficulty understanding how to copy tables with formulas from one document to another or from a master without losing the formulas. i.e. Opening a master, changing data over three or four sheets, adding, removing columns etc and then the forumlas not working. Help !
RE: Excel 2003
Hello Michelle
Thank you for your question and welcome to the forum.
I'm assuming there are links between the data as you are working over multiple sheets and files.
When you paste data from one sheet to another, then you might find you have errors come up with the formulas when there are links in place.
Try using Edit - Paste Special and clicking the Paste Link button in the bottom left corner when pasting formulas from one sheet to another and see if this helps.
We do cover working with multiple worksheets and linking on our Excel Intermediate course.
Kind regards
Amanda
