If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy detail between sheets
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 |
#2
|
|||
|
|||
Copy detail between sheets
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" wrote in message news 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 |
#3
|
|||
|
|||
Copy detail between sheets
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 "Otto Moehrbach" wrote: 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" wrote in message news 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 |
#4
|
|||
|
|||
Copy detail between sheets
"Woody" wrote:
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 "Otto Moehrbach" wrote: 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" wrote in message news 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 |
#5
|
|||
|
|||
Copy detail between sheets
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 --- |
#6
|
|||
|
|||
Copy detail between sheets
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" wrote: 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 --- |
#7
|
|||
|
|||
Copy detail between sheets
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 --- |
Thread Tools | |
Display Modes | |
|
|