Transfering spreadsheet data to a master spredsheet.

[Guest]

So here is my delema. I have a spreadsheet put together for my job to show
the daily production of my workers. Corporate has asked me to put together a
spreadsheet to give a monthly total of what the workers have done from day to
day. I need to know if there is a way to hyperlink data from one spreadsheet
to the other?

Thnaks,

Mike

 

[Guest]

Look this up in the Excel help file and see if it will do what you want.

"Create a link to another cell, workbook, or program"

There are various ways to link data but the tricky part is manipulating,
organizing and/or totaling and displaying the data. Creating a hyperlink
might solve your problem, but I suspect you will need much more than a
hyperlink to satisfy the bosses.