Excel Problem

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

I want to link a worksheet in one workbook to a worksheet in another. So they both contain the same worksheet and if you update one worksheet it automatically updates the other worksheet.

I have managed to make it so when you update one worksheet it updates the other but if you update the other it does not update the other worksheet (if you know what I mean)

Any ideas?

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Yep:-

• Hold CTRL on your keyboard and click all of the available worksheets using their appropriate tabs at the bottom left of the screen. This will 'group' the worksheets.
  
  
• Do your changes
  
  
• It should reflect on all selected worksheets.

Hope this helps.

Qs

 

Is it like Q said?

Or are you wanting to send data each way? as in you update worksheet 1 in workbook A and it updates workseet 1 in Workbook B then if you update worksheet 1 in workgroup B it updates worksheet 1 in Workbook A??

Just trying to get my head round this lol

 

Yeah the OP made my brain hurt too.

My solution works if all the worksheets are in the same workbook.

If the worksheets are in separate workbooks I'd assume you'd need to implement a macro to achieve the desired results.

Qs

 

Yes thats what I want, sorry I did not explain it better, any ideas?

 

Right... ok

The way I remember it and I had to google this to be sure, in this scenario Workbook A would become "the Source" and workbook B is "the dependent". Now Im not sure if you can have them both as "source".

I think there is a way round this but it will be even mind blowing than it is in the minute... I'll have a play and see if I can get this working... will require more coffee and sugar first though

 

Could you not just copy the worksheets from your second workbook to your first workbook as a separate worksheet (confused yet? )

Then you could use my solution to update the data in both. Once you're finished copy all of the desired data back to a separate workbook.

This is obviously dependant upon what you want to update (cell specific locations etc etc).

Qs

 

not really as it is for a user who is creating a works schedule and needs the two worksheets to haev the same data, so when they type it in worksheet A workbook 1, Worksheet A Workbook 2 automaically gets updated and vice versa.

 

That is where I am stuck I can only make one the source which can update the other but the dependent one cannot update the source one.

Also Worksheet 2 is password protected which I think means it can not be a "source" one??

 

I dont think both could be 'source'. Otherwise you end up with a perpetual cycle, where the worksheets are passing data back and forth, back and forth. ie:

worksheet 1 is updates A1 = 100
Update sent to Worksheet 2 A1 = 100
Worksheet 2 sees that its been updated and sends the update to worksheet 1 A1 = 100
...

Do you see how this is going to go? Thats just for one change, imagine you are constantly updating loads of cells in both sheets. Imagine how quickly your pc is going to crash. Now imaging those two sheets are on different network locations, how quickly is the network going to die with the increasing load?

 

Presumably the two workbooks aren't identical right?

I'm assuming that suggesting "copy/paste" isn't a valid answer?

Qs

 

Yeah I totally overlooked the fact that this will rapidly crash the machine depending on the scale of changes

And having 1 worksheet password protected is going to throw a major spanner in the works