Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003
I am trying to get data from one sheet to another in the same workbook. I
want the numbers to go to a summary worksheet and nothing is telling me thats right. I tried to link them but that is not working. HELP PLEASE!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003
What did you expect as opposed to what did happened?
If you want a link you can copy and paste special as link -- Regards, Peo Sjoblom "Attendance Calendar 2005" <Attendance Calendar wrote in message ... I am trying to get data from one sheet to another in the same workbook. I want the numbers to go to a summary worksheet and nothing is telling me thats right. I tried to link them but that is not working. HELP PLEASE!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003
Well all the information transfered the whole spreadsheet to the summary
worksheet. I just want it to look like this if I type in one worksheet i want it to show up in the summary worksheet Joe Shmoe Numbers of days missed 0 numbers of days missed 7 Holidays 4 Hoilidays 8 Little girl Numbers of days missed 7 Holidays 4 Do you get what I want to do? "Peo Sjoblom" wrote: What did you expect as opposed to what did happened? If you want a link you can copy and paste special as link -- Regards, Peo Sjoblom "Attendance Calendar 2005" <Attendance Calendar wrote in message ... I am trying to get data from one sheet to another in the same workbook. I want the numbers to go to a summary worksheet and nothing is telling me thats right. I tried to link them but that is not working. HELP PLEASE!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003
Assuming you use 2 columns so that you have numbers of days missed and
Holidays in one column and the numbers in another like column A and B and have the same in the summary sheet? If so let's assume that Joe Shmoe and little Girl are in Sheet3 with Numbers of days missed and Holidays in Sheet3!A:A and the number in Sheet3!B:B and in the summary sheet Numbers of days missed is in A2 and Holidays in A3 now in B2 in the summary sheet (the adjacent cell to "Numbers of days missed ") =COUNTIF(Sheet3!A:A,A2) copy down -- Regards, Peo Sjoblom "Attendance Calendar 2005" m wrote in message ... Well all the information transfered the whole spreadsheet to the summary worksheet. I just want it to look like this if I type in one worksheet i want it to show up in the summary worksheet Joe Shmoe Numbers of days missed 0 numbers of days missed 7 Holidays 4 Hoilidays 8 Little girl Numbers of days missed 7 Holidays 4 Do you get what I want to do? "Peo Sjoblom" wrote: What did you expect as opposed to what did happened? If you want a link you can copy and paste special as link -- Regards, Peo Sjoblom "Attendance Calendar 2005" <Attendance Calendar wrote in message ... I am trying to get data from one sheet to another in the same workbook. I want the numbers to go to a summary worksheet and nothing is telling me thats right. I tried to link them but that is not working. HELP PLEASE!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |