Question, I have a work book that has 2 work sheets, a cell in number 1 work sheet has the quantity of an item which is manually entered, work sheet 2 is a summary and displays the quantity of the item (='work sheet 1'!A1) etc. So basically is it possible to be able to type in both cells but both cells remain the same value.
Appreciate any help
So if you change either sheet it should reflect the value in the other one?
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.
Yes thats what I am looking to do
Yes thats what I am looking to do
This reflects the change in A1 on Sheet1 on Sheet2:
Please Login or Register to view this content.
The code needs to go on Sheet1's code page so right click on the sheet tab and select View Code.
Similar code would have to go on Sheet2's code page changing the sheet reference in this line to Sheet1:
Please Login or Register to view this content.
Dom
Dom,
Thanks for all your help so far, however a further complication in my work book is as follows:-
Using above sheet names and cell numbers - Sheet1 Cell A1 has the formula - =IF(ISERR(INDIRECT("'Sheet1'!A1")),"",INDIRECT("'Sheet1'!A1")) in it.
and I would really like to keep that formula, is it possible.?
Appreciate you help.
Nope. You can have a formula or a value in a cell, not both.
Dom
Thank you for your prompt response
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks