Forum Discussion
make 2 cells on different pages mirror each other.
mark_bates 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.
The attached workbook contains a working example.
Riny_van_EekelenThank you for the info. I am a contractor and I am trying to improve the excel spreadsheet I made to bid jobs. 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? Thanks in advance.
mark_bates 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.
Riny_van_Eekelenif you look at this file I think it would help. On page Main, Cells E10-E44 are the cells I need to be able to mirror. So E10 will mirror to Sheet 1, Cell I30. E11 will mirror to Sheet 2, Cell I30 and so on. 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. When we bid work our numbers keep changing down to 5 or less minutes prior to the bid deadline.
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. 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. Been Working on this for days.
