Excel formula link between sheets

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Madrex

Thread Starter
Joined
Dec 4, 2011
Messages
3
I have a workbook containing a master sheet (sheet 1), and several other sheets (sheets 2 to 7) which I want to populate with colour highlighted cells that automatically appear in the corresponding cells in the master sheet.
Is there a formula/function that can do this?
Thanks
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,636
Hi welcome to the forum, Yes there is but it all depends on what and you realy want and how the data is in the sheets
If they're all in equivalent cells you can enter a formula in let's say Cell A1 that adds all the values from all the cells AI of each sheet:

A1=Sheet2!A1+Sheet3!A1+ etc...

You forgot to mention what version of Excel you're using, that is also important.
A sample of what you have and what you want would help give us a better idea
 

Madrex

Thread Starter
Joined
Dec 4, 2011
Messages
3
I'm using Excel 2007.

I've attached a sample workbook of what I mean (its not the one I'm actually using). Sheets 2, 3, 4 and 5 (named 'Tom' 'Dick', 'Harry' and 'Bob') are each populated with a name, and a grid of red green or yellow coloured cells, and that data can change. The data is different in each sheet, although the range of cells is the same in each sheet. As the cell grid is populated/changed, I want that information to automatically populate sheet 1 'Master' in the same format, with the information for 'Tom' first, then 'Dick' beneath, and so on. I don't want to copy and paste, as the actual workbook I'm using contains a large amount of frequently changing data. So basically, I just want sheet 1 to be read only.

Hope that makes sense. Thanks for your help.
 

Attachments

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,636
Okay, I'll look at it, it's almost midnight here so it won't be until after work tomorrow.
Good-night (at least for me now) I don't know your time zone
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,636
Maybe this works for you.
The macro to run is 'UpdateActivities'

I did not choose to delete previous data in the Master sheet but this you could include too to make sure you refresh all and only show those where there is an activity.

If more months are added it will take these with it.
I included some explanatory info in the vba code, it's really quite straight-forward, nothing magic ;)
 

Attachments

Madrex

Thread Starter
Joined
Dec 4, 2011
Messages
3
Thanks for your help, I think this can work for me. I need to play around with it a bit and try it on my actual workbook, and also make sure I understand your notes.

Thanks again, this is really helpful!
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top