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 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks