make 2 cells on different pages mirror each other.

Question

What I need to do is as follows.Sheet 1 Cell A1 Mirror Sheet 2&nbsp; Cell D4Sheet 1 Cell A2 Mirror Sheet 3 Cell D4Sheet 2 Cell D4 Mirror Sheet 1&nbsp; Cell A1Sheet 3 Cell D4 Mirror Sheet 1 Cell A2&nbsp;I need to be able to change the value on either side and it change the other.&nbsp;&nbsp;

riny_van_eekelen · Answer

mark_bates&nbsp;You would need some VBA coding in each of the worksheets own code area. The code checks if there was a change in the cell(s) specified and then changes the other cell, but only if the other cell has a different value.&nbsp;The attached workbook contains a working example.&nbsp;

mark_bates · Answer

Riny_van_EekelenThank you for the info.&nbsp; I am a contractor and I am trying to improve the excel spreadsheet I made to bid jobs.&nbsp; I am learning a lot about how it all works but I must admit I am surely a novice at best. Would you be able to tell me the steps to implement those codes?&nbsp; Thanks in advance.

riny_van_eekelen · Answer

mark_bates&nbsp;Let me first ask the question if you only need to mirror a few cells, like in your example. Because, when you have a lot of them and on a lot of sheets, it could easily get out of hand. And since you are trying to improve an existing sheet, I wonder if you can't set it up in a different way so that the need to mirror cells in the way you describe it on different sheets goes away. I suspect that these mirrored cells are parameters of some sort that need to change in both sheets, if certain conditions are met. If so, you will be better off creating a separate table with all these parameters and rules, and link all relevant cells to this table. There are many ways to achieve this but it depends a bit on how you have set-up your data. Would also be good to know which Excel version you are on.&nbsp;

mark_bates · Answer

Riny_van_Eekelenif you look at this file I think it would help.&nbsp; On page Main, Cells E10-E44 are the cells I need to be able to mirror.&nbsp; So E10 will mirror to Sheet 1, Cell I30.&nbsp; E11 will mirror to Sheet 2, Cell I30 and so on.&nbsp; What this does is gives me the ability to adjust my unit prices and it reflect on the total page and the specific item page.&nbsp; When we bid work our numbers keep changing down to 5 or less minutes prior to the bid deadline. &nbsp;&nbsp;I also need to learn how to make a drop down menu on Sheet 1 Cell A19 that uses the list on the Equip Page A1.&nbsp; I can do that but I cant seem to figure out how to make it so when I select an equipment in the drop down menu it also has a rate attached to that equipment that I can then multiply by adding hours into Sheet 1 Cell D19. I appreciate the help.&nbsp; Been Working on this for days.&nbsp;

riny_van_eekelen · Answer

mark_bates&nbsp;Saw your file was an "xls" file. An old file type! It gave a warning that it contained macros when i opened it. But I found no macro's, just two empty User Forms and i could not do much with it.&nbsp;I understand that you will have 35 sheets, i.e. one for every item on your Main sheet, and Sheet1 is the layout you are going to have for all of them.&nbsp;And then you want each cell in E10 to E44 linked to a corresponding cell in each of the 35 underlying sheets? But "E--" in the main sheet has "Unit Price". I30 in the underlying sheets has "Units". How did you think to mirror a price with a quantity? But perhaps I misunderstood. Sorry!&nbsp;With regard to creating the drop down, that easy but I couldn't do it properly due to the due to the problems described above.&nbsp;&nbsp;

Forum Discussion

make 2 cells on different pages mirror each other.

5 Replies

Resources