Hi everyone,
I have 2 worksheets. Here is my problem: I need to find a formula or a VBA code so that whenever I change the cell value in sheet 1, The same value will be updated in a specific cell in sheet 2 and vice versa.
Hi,
Sounds like doing this with formula will create a circular reference so you would probably need to use a vba worksheet change event.
Can you provide a bit more info about what you want to happen?
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Here's what I am working on.
What I want is : When I change D3 value -shhet 1, the same value is updated on B5 cell - sheet 2. And when I change B5, the new value should be updated on D3, too.
So are there any possible solutions?
I would probably just simplify it and list out all the possible timeslots on your Class attendance worksheet and than link the cells to the Timetable sheet.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks