How do I transfer data from one worksheet to another? (Excel 2003)

A

Abeba

I've got results form an ongoing survey on several seperate worksheets within
one Excel workbook (i.e resullts from March and September 2004 on one
worksheet, March and September 2005 on a second worksheet and so on). I've
collated the results onto a seperate sheet in two columns (headed Date and
Percent) from which I've created a chart (on another worksheet).

I need to be able to automatically transfer new data (for March and
September in the following years) to the collated results and automatically
update the chart.

This new data appears in four seperate cells in the new worksheet(s) which
are created from a blank results sheet.

Can I do this with Excel 2003, or do I have to do it manually?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Cannot copy worksheet to another file 2
transfer data from worksheet to another 1
Splitting Data from One Worksheet to Many Automatically 3
Excel worksheet moved all data from multipl cells into one 1
How do I move data from one worksheet to another? 1
Copy-Paste Chart into Word from Excel 2007 3
Importing data from Excel worksheet into Excel template 2

Top