can one excelworksheet address update a different box on 2nd w/s

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to put data into one excel worksheet box at say A1
and for it to appear at a different address say D2 on a second worksheet. At
school we have class lists for pupils and set lists with the same names. I
need to enter data by set whereas the school wants records kept by form.
This means I have to hunt around which takes forever. Is there a quick way
of entering say 78% for a child in set 2 and it appear on another page in
the right place?
 
In cell D2 on your second sheet, type an equals sign, then go to your first
sheet and click in A1. Then Enter.
That will give you the formula =Sheet1!A1
If you want the second sheet cell to remain blank when the first sheet cell
is blank, try
=IF(Sheet1!A1="","",Sheet1!A1)
 

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

Need Simple List...Multiple Columns and Multiple Worksheets 6
Vlookup v. drop down box for mailing addresses 1
excel 2003 drop-down box color changes how 2
How do i create a drop down list from information on another works 2
Filtering failed moving on...HELP 2
Copy rows between different sheets if condition met 5
Vlookup using a dropdwn list, check different tables based on drop 2
Can I Open a list box at a Specific Location on Form? 1

Back
Top