Donate SIGN UP

how do i auto transfer data between worksheets in excel

Avatar Image
yellowjohn | 01:15 Tue 29th Mar 2005 | Technology
3 Answers
i am running a fantasy motorcycle dreamteam league at work and would like to know how to update results for several teams across worksheets and workbooks.  I am using excel, would i be better off with access? i want to enter the points for each rider then be able to update each team in one go.if non of the above programmes are  suitable which could i use and how.
Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by yellowjohn. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

For data in one worksheet to be dynamically updated in another worksheet the you must copy the cell in SheetX and use  Paste Special...  ⇒ Paste Link  into the cell in SheetY.

Question Author
thanks kempie i will give it a try.should make things a lot easier and save time as well.
Kempie is right. The only other thing that you should remember is to use multiple worksheets in one workbook. It's much better when the open the file.

1 to 3 of 3rss feed

Do you know the answer?

how do i auto transfer data between worksheets in excel

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.