How do you import data from one Excel document to another?
 

Hey everyone,

I work at a school and I'm trying to update their attendance reports from
hand written to excel, but I'm running into several problems. For one, I need
it to be able to calculate how many "Ab"s (absents) there are in the
worksheet (for the individual student's attendance page). And THEN, I need to
have the sum show up on a completely new document (for the overall attendance
report). Is that possible? I've fooled around with data importing and several
other things, but I'm just too new at this. If what I'm asking is possible,
can anyone help me figure this out?

Thanks,
Tiffany

Hi Tiffany

be able to calculate how many "Ab"s
=COUNTIF(A1:A30,"Ab")

Do you have a sheet for each student ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tiff1618" wrote in message ...
Hey everyone,

I work at a school and I'm trying to update their attendance reports from
hand written to excel, but I'm running into several problems. For one, I need
it to be able to calculate how many "Ab"s (absents) there are in the
worksheet (for the individual student's attendance page). And THEN, I need to
have the sum show up on a completely new document (for the overall attendance
report). Is that possible? I've fooled around with data importing and several
other things, but I'm just too new at this. If what I'm asking is possible,
can anyone help me figure this out?

Thanks,
Tiffany

Tiff1618 Wrote:
Hey everyone,

I work at a school and I'm trying to update their attendance reports
from
hand written to excel, but I'm running into several problems. For one,
I need
it to be able to calculate how many "Ab"s (absents) there are in the
worksheet (for the individual student's attendance page). And THEN, I
need to
have the sum show up on a completely new document (for the overall
attendance
report). Is that possible? I've fooled around with data importing and
several
other things, but I'm just too new at this. If what I'm asking is
possible,
can anyone help me figure this out?

Thanks,
Tiffany

Hi Tiffany

In a cell not included in your range of data, you can count the Ab's
with this formula =COUNTIF(A1:A6,"Ab"), change the A1:A6 to suit your
range of data

To get the Ab's count to show on a different document, open that
document and the one with the Abs total, on the "different document go
to the cell where you want the abs total, type in the cell =, go to the
file with the abs total and click on the cell with the abs total, then
press enter, the total for abs will appear in the cell you typed = on
the different file


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399801

Yeah, I'm going to have one for each student, but I don't yet. Thanks for
your help guys, but it's still giving me error messages when I type that.
"You've entered too few arguments for this function". Am I doing something
wrong?

"Ron de Bruin" wrote:

Hi Tiffany

be able to calculate how many "Ab"s
=COUNTIF(A1:A30,"Ab")

Do you have a sheet for each student ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tiff1618" wrote in message ...
Hey everyone,

I work at a school and I'm trying to update their attendance reports from
hand written to excel, but I'm running into several problems. For one, I need
it to be able to calculate how many "Ab"s (absents) there are in the
worksheet (for the individual student's attendance page). And THEN, I need to
have the sum show up on a completely new document (for the overall attendance
report). Is that possible? I've fooled around with data importing and several
other things, but I'm just too new at this. If what I'm asking is possible,
can anyone help me figure this out?

Thanks,
Tiffany

That sounds pretty simple, thanks :) But I'm still having problems with it.
It's giving me an error message saying "You've entered too few arguments for
this function". What can I do to fix it?

"Paul Sheppard" wrote:


Tiff1618 Wrote:
Hey everyone,

I work at a school and I'm trying to update their attendance reports
from
hand written to excel, but I'm running into several problems. For one,
I need
it to be able to calculate how many "Ab"s (absents) there are in the
worksheet (for the individual student's attendance page). And THEN, I
need to
have the sum show up on a completely new document (for the overall
attendance
report). Is that possible? I've fooled around with data importing and
several
other things, but I'm just too new at this. If what I'm asking is
possible,
can anyone help me figure this out?

Thanks,
Tiffany

Hi Tiffany

In a cell not included in your range of data, you can count the Ab's
with this formula =COUNTIF(A1:A6,"Ab"), change the A1:A6 to suit your
range of data

To get the Ab's count to show on a different document, open that
document and the one with the Abs total, on the "different document go
to the cell where you want the abs total, type in the cell =, go to the
file with the abs total and click on the cell with the abs total, then
press enter, the total for abs will appear in the cell you typed = on
the different file


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399801

Nevermind, I figured it out. I guess I was just typing it wrong, because it's
working now :) Thanks!

"Paul Sheppard" wrote:


Tiff1618 Wrote:
Hey everyone,

I work at a school and I'm trying to update their attendance reports
from
hand written to excel, but I'm running into several problems. For one,
I need
it to be able to calculate how many "Ab"s (absents) there are in the
worksheet (for the individual student's attendance page). And THEN, I
need to
have the sum show up on a completely new document (for the overall
attendance
report). Is that possible? I've fooled around with data importing and
several
other things, but I'm just too new at this. If what I'm asking is
possible,
can anyone help me figure this out?

Thanks,
Tiffany

Hi Tiffany

In a cell not included in your range of data, you can count the Ab's
with this formula =COUNTIF(A1:A6,"Ab"), change the A1:A6 to suit your
range of data

To get the Ab's count to show on a different document, open that
document and the one with the Abs total, on the "different document go
to the cell where you want the abs total, type in the cell =, go to the
file with the abs total and click on the cell with the abs total, then
press enter, the total for abs will appear in the cell you typed = on
the different file


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399801