Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Transfering spreadsheet data to a master spredsheet.

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default Transfering spreadsheet data to a master spredsheet.

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.

"schottgun" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Locating Source Data in Master Spreadsheet Jen Excel Discussion (Misc queries) 3 May 27th 10 10:58 PM
transfering data from word form to an existing spreadsheet Jose Excel Discussion (Misc queries) 1 October 15th 07 07:56 PM
How do I link from a master spreadsheet? uofu Excel Discussion (Misc queries) 2 August 15th 07 07:51 PM
Load data from multiple spreadsheets into one master spreadsheet Scarlet Excel Programming 1 June 6th 06 06:04 PM
Gathering data to a master spreadsheet Sum Limit and marking Excel Programming 1 April 6th 06 07:50 PM


All times are GMT +1. The time now is 05:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"