Home Brew Forums > Home Brewing Community > General Chit Chat > Any Excel genuises out there?
Reply
 
Thread Tools
Old 09-16-2009, 03:35 PM   #1
RIBeer
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2008
Location: Rhode Island
Posts: 208
Default Any Excel genuises out there?

I keep track of my student's assignment deadlines using an Excel sheet. I use a separate worksheet for each student. Adding deadlines is a rely time consuming process, as I need to insert space, then copy and paste the assignment for each kid. Is there a more efficient way to do this? Say, insert a new entry in the line after a certain date for each worksheet at the same time? Thanks for your input!


RIBeer is offline
 
Reply With Quote
Old 09-16-2009, 04:03 PM   #2
menschmaschine
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jun 2007
Location: Delaware
Posts: 3,278
Liked 36 Times on 29 Posts

Default

There is definitely a more efficient way to do this. Can you post a picture of an example worksheet?... or at least describe the columns/rows in more detail?


__________________
END TRANSMISSION
menschmaschine is offline
 
Reply With Quote
Old 09-16-2009, 04:13 PM   #3
Palefire
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jun 2009
Location: SF, CA
Posts: 1,130
Liked 12 Times on 9 Posts
Likes Given: 3

Default

Yeah, if you attach your file people here can probably figure it out. I'm no Excel genius, but I do have some experience (though I still discover new things all the time!).
Palefire is offline
 
Reply With Quote
Old 09-16-2009, 04:38 PM   #4
hukdizzle
Feedback Score: 2 reviews
Recipes 
 
Join Date: Aug 2007
Location: Pensacola, FL
Posts: 432
Liked 4 Times on 4 Posts

Default

I believe this may be what you're looking for,

Learn Paste Link function in Excel
hukdizzle is offline
 
Reply With Quote
Old 09-16-2009, 05:04 PM   #5
roverlandpark
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Oklahoma City, OK
Posts: 23
Default

Quote:
Originally Posted by hukdizzle View Post
I believe this may be what you're looking for,

Learn Paste Link function in Excel
This is probably the easiest way to get the data over. It basically creates a reference from one page to another. Two things I would recommend when using this approach would be:
  • Make sure what you copy has room for future expansion. If you have ten assignments now (but will eventually have twenty later), include those cells that will have the future data. Otherwise, you'll be in the same boat later.
  • Also, if you have the references going to empty fields, you'll get zeroes populating your students' worksheets. To hide these, go to the toolbar and select "Tools->Options". Under the view tab, uncheck "View Zero Values"
.

Hope this helps!
roverlandpark is offline
 
Reply With Quote
Old 09-16-2009, 06:26 PM   #6
velotech
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2008
Location: Highlands Ranch, CO
Posts: 236
Liked 1 Times on 1 Posts

Default

If the deadline is the same for each student, then linking the cell from one sheet would be easier/quicker. Other options would be changing the spreadsheet from one sheet per student, to one sheet per assignment, then copying the students to each assignment spreadsheet.

Overall, this sounds like something Access would handle much better. I know its more complicated to learn than Excel, but picking up a few tutorials online can make this type of tracking much easier.
__________________

_____________________________________________
velotech is offline
 
Reply With Quote
Old 09-16-2009, 06:33 PM   #7
weirdboy
HBT_LIFETIMESUPPORTER.png
Feedback Score: 4 reviews
Recipes 
 
Join Date: May 2009
Location: Los Angeles
Posts: 8,000
Liked 440 Times on 359 Posts
Likes Given: 63

Default

Oh man, I hate links in spreadsheets that reference other workbooks. It is just asking for trouble later on.

I think the initial description needs to be fleshed out more instead of making assumptions about what is being described. The Paste Link feature sounds like overkill to me, as well as setting up stuff in advance and all that kind of crap. There is usually very little reason to have to set up extra spaces in advance in Excel, when you can easily use the "Insert" command to insert rows or columns when needed.
weirdboy is offline
 
Reply With Quote
Old 09-16-2009, 06:43 PM   #8
KYUSHO00
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jul 2009
Location: ANDOVER, MA
Posts: 34
Default

If it is one workbook and all the tabs are similar it is easy.

Hold control and click on each sheet you need to update. (or click on the first tab hold shift and click on the ending tab)
Then while the tabs are white(highlighted) do what you need to do in the one sheet and it should show in all of the sheets that are selected.

I do this for a salesperson tracker that I do every month.

Excel is my job.
I love pivot tables, v/h lookups, ect.


KYUSHO00 is offline
 
Reply With Quote
Reply


Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lets see your brewing Excel Spreadsheets LS_Grimmy General Beer Discussion 19 03-22-2011 10:57 PM
Need Some Excel Formatting Help jescholler Brewing Software 7 10-18-2009 10:50 PM
I use my Excel Spreadsheet LS_Grimmy Brewing Software 15 08-07-2009 07:01 PM
Fun with excel uwjester General Beer Discussion 5 02-14-2009 12:14 AM


Forum Jump

Newest Threads

LATEST SPONSOR DEALS