The Great Bottle Opener Giveaway

Home Brew Forums > Home Brewing Community > General Chit Chat > Any Excel genuises out there?

Reply
 
LinkBack 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 Quick reply to this message
Old 09-16-2009, 04:03 PM   #2
menschmaschine
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jun 2007
Location: Delaware
Posts: 3,278
Liked 31 Times on 26 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 Quick reply to this message
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 11 Times on 8 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 Quick reply to this message
Old 09-16-2009, 04:38 PM   #4
hukdizzle
Feedback Score: 2 reviews
Recipes 
 
Join Date: Aug 2007
Location: Pensacola, FL
Posts: 425
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 Quick reply to this message
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 Quick reply to this message
Old 09-16-2009, 06:26 PM   #6
velotech
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2008
Location: Highlands Ranch, CO
Posts: 236
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 Quick reply to this message
Old 09-16-2009, 06:33 PM   #7
weirdboy
HBT_LIFETIMESUPPORTER.png
Feedback Score: 3 reviews
Recipes 
 
Join Date: May 2009
Location: Los Angeles
Posts: 7,912
Liked 424 Times on 345 Posts
Likes Given: 58

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 Quick reply to this message
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 Quick reply to this message
Reply


Quick Reply
Message:
Options
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-13-2009 11:14 PM