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" <[email protected]> wrote in message news:[email protected]...
> 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

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" <[email protected]> wrote in message news:[email protected]...
> > 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
>
>