Importing across Excel files, and using MSQuery?

  • Thread starter Thread starter DLS
  • Start date Start date
D

DLS

I have one master file, which I first update every month with who'
showed up (column A on sample roster file) & add new names, from whic
I then filter, copy, and paste data from about 1600 kids into monthl
sign in sheets for 24 different classrooms. It is quite tedious and ca
take an 8 hour day for the whole thing. I am wondering why I can'
import the updated data from one file (roster) directly to the othe
(sign in sheets). When I tried to create a query, the column with th
X's and single numerals did not show up as valid options to import fro
and I don't know why
 
: I have one master file, which I first update every month with who's
: showed up (column A on sample roster file) & add new names, from which
: I then filter, copy, and paste data from about 1600 kids into monthly
: sign in sheets for 24 different classrooms. It is quite tedious and can
: take an 8 hour day for the whole thing. I am wondering why I can't
: import the updated data from one file (roster) directly to the other
: (sign in sheets). When I tried to create a query, the column with the
: X's and single numerals did not show up as valid options to import from
: and I don't know why.
:
:
: ---
: Message posted
:
 
Back
Top