Copy detail between sheets

[Woody]

Hi - hope someone can help.
I've been asked to set up a master table showing student allocations to
different departments on different dates (e.g. Mon-Fri, Jan1st-Dec31st),
where 1st table acts as master table, copying data to other tables in
workbook, and any changes are driven by front sheet only.

Points to consider:

Separate sheet for each of following:
a) Each student requires copy of only their timetable (date/dept./notes etc.)
b) Each Department requires copy of which students are coming
(date/student/notes etc.)

Plan needs to be adaptable to be copied out for each new yearly intake.
Front sheet to colour highlight different departments, to avoid unnecessary
over allocation of students

Hope someone can help - maybe from existing educational establishment.

I have some ideas as to how I envisage this working, yet am frustrated by
lack of knowledge to put it into practice in spreadsheet.

Regards, in keen anticipation,
Woody

 

[Otto Moehrbach]

Woody
Your description of the problem is too wide open for anyone to be able
to help you, and I think you know that. Your last paragraph is the most
significant one of what you wrote. You have some ideas but you don't have
the knowledge of how to put those ideas into operation. We have the
knowledge but we don't have your ideas.
Let's eat this cow one bite at a time. Post back and describe one of your
ideas. Not the whole cow! Just one bite to get started. A good start would
be for you to describe the layout of what you have. This sheet has this,
that sheet has that. This column has this, that column has that. Then
describe as best you can what you want to have. Try to use generic
terminology. Not everyone is your line of work. HTH Otto

 

[Woody]

Thanks, Otto - sorry for being so 'wide open'
Perhaps the front sheet column (A-E etc.) data headers might help - here
goes..
(A) Date : (B) Student 1 name : (C) Venue : (D) Student 2 name : (E) Venue :
etc..

Row example : = column separator)
1/1/08 : Fred Smith : Room 1 : Susan West : Room 2 : Tom East : Room 3 :
etc..
2/1/08 : Fred Smith : Room 2 : Susan West : Room 1 : Tom East : Room 3 :
etc..

That is the easy bit just to put in dates, names, location etc. Don't
require help in that bit of the puzzle, thanks.

I then want to make separate sheets for each Named person, AND each
department, so that each pupil knows where to go on which date, and the
department knows which students are coming to them on which days.

Is this best tackled using Excel, or is Access the better route - ps I would
need greater assistance if it were in Access, so see the Excel route as the
first step, and may be create a database from the resulting spreadsheet.

Hope this helps, and isn't too much in one go.
Regards,
Davids

 

[Woody]

Thanks, Otto - sorry for being so 'wide open'
Perhaps the front sheet column (A-E etc.) data headers might help - here
goes..
(A) Date : (B) Student 1 name : (C) Venue : (D) Student 2 name : (E) Venue :
etc..

Row example : = column separator)
1/1/08 : Fred Smith : Room 1 : Susan West : Room 2 : Tom East : Room 3 :
etc..
2/1/08 : Fred Smith : Room 2 : Susan West : Room 1 : Tom East : Room 3 :
etc..

That is the easy bit just to put in dates, names, location etc. Don't
require help in that bit of the puzzle, thanks.

I then want to make separate sheets for each Named person, AND each
department, so that each pupil knows where to go on which date, and the
department knows which students are coming to them on which days.

Is this best tackled using Excel, or is Access the better route - ps I would
need greater assistance if it were in Access, so see the Excel route as the
first step, and may be create a database from the resulting spreadsheet.

Hope this helps, and isn't too much in one go.
Regards,
Woody

 

[Max]

Going by your original post's ...

.. where 1st table acts as master table, copying data to other tables
in workbook, and any changes are driven by front sheet only ..

Here's one formulas driven option which might serve your needs ..

Take away this sample construct from my archives:
http://www.savefile.com/files/430142
AutoCopy Lines to Resp Sht Non Array.xls
(Full details inside, nicely rendered. Easy to adapt ..)

Data is continuously entered in a master ("parent") sheet, with lines neatly
auto-copied to each individual ("child") sheet based on the values within a
key col.

In the sample, the key col in the master sheet is the "State" col, which may
contain eg: NY, CA, NV, SD, AZ, etc. All lines with "NY" in the key col will
be auto-copied to the sheet named: NY, and appear neatly bunched at the top,
w/o any intervening blank lines. Ditto for lines with "CA", "NV", etc which
will be copied into their respective sheets.

Propagation of the "child" sheet is as simple as making a copy of the
initial one, then renaming it accordingly as the next key col value. Eg just
formulate one child sheet for "NY", dress it up nicely, then just make copies
of the "NY" sheet, and rename these as: CA, NV, SD, etc
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:57
xdemechanik
---

 

[Woody]

Hi Max,
Thanks for your help on this - I've obviously got a lot of trying out to do,
yet I think I can see a way through the minefield of the project.
I note that your file is .XLS - a simple question - would you advise asking
in the ACCESS forums, or is the best method to tackle it in Excel first, then
try and create a user-friendly solution.
In keen anticipation of a quick fix.
If I complete the file, I may well submit it for others to share, as you
have done.
Do you have any other EXCEL or ACCESS files, without submitting to yet
another membership group, or is their any other way of downloading your
files, as the main aspects of your files give plenty of scope for exploring.
Many thanks,
Woody

 

[Max]

Thanks for your help on this - I've obviously got a lot of trying out to do,

yet I think I can see a way through the minefield of the project.

Glad to hear that. Btw, from where you're reading this (MS' webpages)
there's a "Yes" button below for you to rate responses received. Do take a
moment to press that button, won't you?

.. would you advise asking in the ACCESS forums,
or is the best method to tackle it in Excel first, then ...

No comments to offer, sorry. Don't really know/use Access all that much.

Do you have any other EXCEL or ACCESS files, without submitting to yet
another membership group, or is their any other way of downloading your
files, as the main aspects of your files give plenty of scope for exploring

Other than savefile.com, one other free filehost
to upload illustrative sample files that I use from time-to-time of late is:

http://www.freefilehosting.net/

(Doesn't require registration, and it's real easy to use, with a visible
downloads counter to boot. But unlike savefile.com it doesn't have any
"folder" capabilities to place all the d/l links, and I think the files
retention period is shorter than savefile's)

In my savefile archives, except for a few earlier zip collections, you can
browse individual links/files of interest. I've tried to work it into the
filenames to reflect for easy browsing.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:58
xdemechanik
---