Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can one excelworksheet address update a different box on 2nd w/s
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can one excelworksheet address update a different box on 2nd w/s
"celia ellis" wrote: 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? Celia Select d2 on sheet2 and type = click on sheet1 tab and click say A1 and press enter Your formula will be Sheet1!A1 and whatever is in that cell will be displayed. Copy the cormula as required. Regards Peter |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can one excelworksheet address update a different box on 2nd w/s
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) -- David Biddulph "celia ellis" <celia wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do update inventory | Excel Discussion (Misc queries) | |||
How do I manipulate a string to collect the address from it? | Excel Discussion (Misc queries) | |||
how can i convert an email address to a web address | Excel Worksheet Functions | |||
Excel email address hyperlink does not update | Excel Discussion (Misc queries) | |||
?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) |