Email:      Pass:    Pass?
Close Window   
TE
Subscribe for Email Updates!
Excel tips, help, and more!
E-mail:


Advertisements


Free Excel Forum

Linking Spreadsheets Within A Workbook

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I would like to link individual spreadsheets to a masterspreadsheet within a
workbook. Can someone help me not only link the data but also the format of
the cell. Example if the cells are different colors for different reasons -
how do I move over the colors?



View Answers     

Similar Excel Video Tutorials

Helpful Excel Macros

Display The Actual Link / Email Address From Links in Excel - UDF
- Display the actual link or email address from links within Excel with this UDF. This user defined function pulls the ac
Format Cells in The Number (Numerical) Number Format in Excel
- This free Excel macro formats selected cells in the Number or Numerical number format in Excel. This means that the cel
Format Cells as a Scientific Number in Excel Number Formatting
- This free Excel macro formats selected cells in the Scientific number format in Excel. This means the cell will be put
Create a 12 Month Calendar With The Current Day Highlighted in Excel
- Create a 12 month formatted calendar on a new tab in Excel with the current day highlighted. This macro creates a nicel
Determine a Cell's Color with this UDF - Outputs as Text or the Index Number in Excel
- This free Excel UDF allows you to output the color of a cell in text format or as that color's index number. Also note

Similar Topics







Hi there,

I have various spreadsheets and from these spreadsheets I link back to one central spreadsheet for a central information sheet.

I generally have all the spreadsheets open when linking them and when I do this I just type = and then click on the link in the cell of the spreadsheet that I want to link.

This generally works but today for some reason when I go to the the spreadsheet that I want to link nothing happens.

Do I need to manually set up these links or has something happened

Thanks

Dave


Hi there,

I have various spreadsheets and from these spreadsheets I link back to one central spreadsheet for a central information sheet.

I generally have all the spreadsheets open when linking them and when I do this I just type = and then click on the link in the cell of the spreadsheet that I want to link.

This generally works but today for some reason when I go to the the spreadsheet that I want to link nothing happens.

Do I need to manually set up these links or has something happened

Thanks

Dave


I have a worksheet with colors and materials. Colors make up the colums and material make up the rows with sales data in the cels. I am trying to add all of my colors and material together on one spreadsheet.

I have 5 spreadsheets with different colors and materials and want to make one master spreadsheet with totals of all 5 spreadsheets.

For example I have the color red in leather and on 3 of the 5 spreadsheets I have sales of 10,15,13 so I would want the total sheet to go and look at all 5 spreadsheets and give me a total of 38 for red leather, any idea on the formula? I tried an index match, but it became too long and cumbersome.

Thanks


I am needing to know how (or if) I can link spreadsheets together from multiple users. What I am trying to do is to have individual spreadsheets on each of the people's pc's in the office and have one central spreadsheet on our server. I would like for the central spreadsheet to be linked to all the individual spreadsheets and be updated when the individual spreadsheets change.


It's a New Year, so I have to create a new master spreadsheet that updates from several other spreadsheets that several people uses to compile their region's information.

My question-is there anyway I can have an entire worksheet link to another worksheet in a different workbook with out entering the formula like this?
='[workbook.xls]Sheet1'!$A$1

The format for the spreadsheets are identical.


I have a workbook that I have used a number of colors from filling cells, cell borders, and color of text within cells. But many colors I would like to use do not appear when I want to fill a cell with a color or change Text in a cell to a specific color. It appears the only colors I have available to me are based on Themes that I select in the Formatting Palette. When I change the theme to access color I want, colors in my workbook change to undesirable colors.

How can I get all the colors available for my workbook without limitations?


I have 5 sales people and want to see there reports in 5 tabs on my personal spreadsheets. I am on a network. My spreadsheet is on the network.
How can I link their workbook to mine. the have a whole report.Do I have to link cell by cell or can i link their entire workbook page / tab in to one of my tabs?

Link 5 separate spreadsheets in one master sheet. ( I hope not cell by cell).


Here is my issue.
I'm combining 3 spreadsheets into one. I would like for all the spreadsheets to update the one...including when rows are added to them. I have been able to link individual cells from one worksheet to another but that doesn't solve the problem of added rows. I wondered briefly if this would be solved by linking a list but I can't even figure out how to do it. I'm currently using Excel 2003. Any help whatsoever would be appreciated.
Thanks in advance,
Bubb


Hi Guys/Gals,

This is will sound a little perplexing I've got a primary spreadsheet with multiple worksheets used for data entry I want to able to save these these worksheets as individual speadsheets and link to the to the primary.

Example Primary Spreadsheet ='C:\My Documents\Testing\[Alpha.xls]Alpha'!D16.

The following code below is converting so to speak th worksheets from the primary spreadsheet to individual spreadsheets

Sub SaveWSDesktop()
'Creates an individual workbook for each worksheet in the active workbook.
Dim wbDest As Workbook
Dim wbSource As Workbook
Dim sht As Object
Dim strSavePath As String
On Error GoTo ErrorHandler
Application.ScreenUpdating = False
strSavePath = "H:\Desktop\"
Set wbSource = ActiveWorkbook
For Each sht In wbSource.Sheets
sht.Copy
Set wbDest = ActiveWorkbook
wbDest.SaveAs strSavePath & sht.Name
'wbDest.Close 'If you wish to close after saving.
Next
Application.ScreenUpdating = True
Exit Sub
ErrorHandler: 'Just in case something weird happens
MsgBox "An error has occurred. Error number=" & Err.Number & ". Error description=" & Err.Description & "."

End Sub


Is there a to link them to prime spreadsheets as well. Sorry if sounds ambigous.


Thx


I don't like the pastel colors in any of the themes in Excel 2007.

Many of my spreadsheets use the older 2003 colors for highlighting cells or text -- and I prefer the bolder old colors.

Is there a way to easily add back the old Excel 2003 font colors as default?

Thanks
David.


Hi-

I am trying to create a type of scrubbing workbook. For instance I am taking 3 separate spreadsheets (that represent shipped sales for parts) and merging it with the Master (payments confirmed) spreadsheet. I have colored the 3 spreadsheets different colors and left the master white. I need to somehow auto sum all three colors (with the matching part #) and compare it to the master (white) cells. If the totals do not match up, I need the white cell to turn Red. I have attached a sample. The actual spreadsheets are over 3k rows long each. So this is extremely tedious for me to do manually. Ughhh. HELP!! :0) I have attached a sample of what I am attempting to do.


Hi
I'm trying to link budget spreadheets. I want to link one cell and then copy the link across the spreadheet, down and sideways. However. it brings up an absolute link and I have to go in and get rid of the dollar signs manually before copying the formula. Is there a way to bring the link over so that its not absolute?

Thanks


Hi

I wish to create a excel database which will link about 200-250 excel spreadsheets. Each spreadsheet will have a minimum of 20 cells that will link to the main database

Just wondering if its better to do the calculations on the individual spreadsheets and link the values of the outcomes to the main spreadsheet.

or copy the base values from the individual spreadsheets and then perform the calculations on the main spreadsheet

Never attempted a file with this many external links so i dont know how the system will cope.

Thanks


I have 2 spreadsheets.

Workbook A is updated daily by an admin assistant

so it looks like this:

Column 1 Column 2
2/28/2008 348
2/29/2008 439

etc.

So every day, a new row is added.

workbook B is an overall sheet that will need to pull data from those columns every day.

I would like to automate this to the extent that every time I open Workbook B, it adds the new data on workbook A in the same fashion, namely by adding a new row to the column and inserting the data.

I have been able to link the data, but I still have to go through a manual process every day to tell workbook B to link to specific cells in workbook A - so in terms of time, I may as well just copy and paste.

I'm hopeful that this is a relatively simple task, but searches have proven futile - I'm probably not searching on the right term.

Thanks for your assistance.


Im using Excell for my Fantasy Football Draft, Id like to have one
spreadsheet with my players in order by Rank and the other by Name,
however id like to link them so that when a player is drafted i can
mark them as drafted and that particular player will be marked as
drafted in both spreadsheets- ive sucessfully used the Paste Special
function to link the 2 spreadsheets, but i run into a problem when i
re-sort the second sheet because this messes up the links, please
help!!!




Im using Excell for my Fantasy Football Draft, Id like to have one
spreadsheet with my players in order by Rank and the other by Name,
however id like to link them so that when a player is drafted i can
mark them as drafted and that particular player will be marked as
drafted in both spreadsheets- ive sucessfully used the Paste Special
function to link the 2 spreadsheets, but i run into a problem when i
re-sort the second sheet because this messes up the links, please
help!!!




I have an excel workbook with twenty four spreadsheets in it that rely on
each other being there (can't seperate them into individual files). I am
writing a report in Word that uses some of the sheets in the Excel file via
an "insert object" menu item in Word.

My question is how do I link to an individual sheet? When I link to the
file it brings in the sheet that was open during the last save of the Excel
file. I have to go and open the Excel file, select the correct sheet, save
and exit (if it is not exited it doesn't insert correctly). I would rather
link to something like "\path\filename|sheetname". Is there a way to do
this, can I change the link once made to point to the specific sheet I want?
Any other thoughts?????





Linking is what I am having trouble with... I can establish the link but when I copy down a cloumn, Excel wants me to establish the link each and every time.

I purchased Link Hacker and it tells me Error 52. Bad file name or number
I have tried the mapped drive as well as the entire directory listing.
Is there anyway to force Excel to perform the formula without having to manually tell the link where to go?
I want to type a formula and it tells itself where to find the data.

If not is there another way to accomplish the reading of the spreadsheets?


Hello everyone. I have created several custom colors for my workbook, and applied them to different cells. However when I send the workbook to other people the colors swap back to their pallet colors. Is there a way to prevent this that doesn't involve macros? Thanks!


I am currently using Excel 2007 and have a large workbook. When I go to make a format change in any of the tabs, the colors across the workbook change to some base color pallette. I'm not making coloring formatting changes, just formatting changes in general, such as adding a border around a group of merged cells.

Not only do the colors change, but some of the formats (such as the border) seem to change too. For example, in a group of merged cells with a border around it, the uper right hand portion of the border will disappear.

Please help.


Hello!

Can someone tell me why, when I copy a worksheet from one workbook to another, the colors on the sheet in the destination workbook, become dull/faded. They actually change from the original colors to some off colors.

I copy by selecting the source sheet, hold down ctrl key, then drag from one workbook to another).

Also, is there a way to get the sheet back to the original colors.

Thanks.


Hi, i was just wondering if it was at all possible to link to workbooks off line so that if data was changed in on it would change in the other, i relise that this can be done by making one cell equals another cell in a different workbook but my aim is to link them off line so that you do not need both sheets open to have it make changes. i hope that all makes sense, thank you in advance!

Josh


I am having four individual excelworkbooks, those are reports generated by crystal reports and exported into excel format. now, i am trying to copy these different workbook into one workbook as different sheets. but the row colors were changing into different color at time coping.

Thanks guys

Tripu


Hi there,
I am new to this forum and a moderate Excel User. I have a workbook with three separate worksheets. Each worksheet contains 5-7 columns of data for about 25 individuals. Out of that data, I want to create a selective "At a glance" report for each of the 25 individuals. I have no idea where to start bc I do not know how to link spreadsheets. Is this what I need to know? Any insight is greatly appreciated. I also have a sample report so you can see my workbook. I can't seem to include it in this post.

Thank you


I want to link a cell to two different cells in a new workbook with one being a reference # and one being the value of the reference #. How can I do that?