PDA

bodmas
2011-08-25, 11:48 AM
Need code [Automatically calculate new results as values are entered on other sheets]
Need code in cell "I3:I1000" for sheet2,3,4,5..... so on respectively in order to reflect changes in cell "P7:P1000" of sheet1. Whenever i type any value in cells "I3:I1000", it should be reflect in cell "P7:P1000" of sheet1.
For eg: Sheet 1 : P7=10, I inserted value in sheet 2: I3=5. So i want the vale to be deducted from cell P7 automatically. It should be like this,
P7= 10-5 = 5
Cell P7 in sheet 1 should reflect value 5.
Please give the code for the above.
Thanks 218218

bodmas
2011-08-26, 11:30 AM

Ken Puls
2011-08-28, 04:16 AM
Hi there, and welcome to the forum.

So... I'm thinking that it's a little more difficult than what you've stated, but just want to check.

First, you actually want it decucted from Q7 according to your example file, not P7

Second, if this is a list of inventory, don't you actually need it deducted from P(whatever row the appropriate item is in on Sheet1)? What I mean is that, on Loom1's page, you're using 1 of part 6600. If part 6600 was in row 8, wouldn't you want the value deducted from Q8?

bodmas
2011-08-28, 06:49 PM
@Ken Puls ~ Yes, you are absolutely right. It is not P7, It is Q7. I want to edit my first post but not able to edit [Dont know why].
Thanks for correcting me. I have updated my worksheet, please check the attachment. Let me explain you my problem in more details:
Firstly,
After selecting A[Part No.] Sheet1, I will press enter and i would like the cursor move towards last row of cell AA[Part No. 6600] of sheet1 [If there is data in AA4 then the cursor should highlight AA5 cell after pressing enter from cell A, sheet1].
Secondly,
After completing the data entry at AF[Price] and hitting enter, I would like to move cursor towards Loom Section [Cell J,Sheet 1] of corresponding part no. of which the entry is made.
Thirdly,
I have already the code to select Loom Sheet. After selecting Loom No and completing its entries, i want a code for automatically maintain stock [cell K,sheet 1] of respective part no.
I hope you are getting me. Advance thanks!259

Ken Puls
2011-08-28, 08:30 PM
Okay, but what happens if you select part 6601? Where does that go?

To be completely honest here, what you're trying to do would be much better served in a relational database, such as Access...

bodmas
2011-08-28, 08:42 PM
@Ken Puls ~ I will create one more table for 6601,6602,...so on.
Thanks for your suggestions sir. I have access also but never used it. Can you please guide me for access or help me getting code for the above.

Ken Puls
2011-08-28, 10:42 PM
Hi,

I'm not an Access guru, just know enough to be dangerous with it, although I do use it as a back end (data warehouse) for many of my Excel projects. I may not be able to help you as much as you need there. If you want to try on emore Excel example, I'm sure we can make it work, it just may not be ideal for a really long life.

bodmas
2011-08-29, 06:34 AM
@Ken Puls ~ One guy help me out by the following code. It is working well. Can you please check it and update it according to my requirements of #4.

Thirdly,
I have already the code to select Loom Sheet + the code for stock updation. After selecting Loom No and completing its entries, i have the code for automatically maintain stock [cell K,sheet 1] of respective part no. Now, i want After updation of stock, i want my cursor to go back to Sheet 1, Part no. selection.
Please check my latest updated attachment.260

bodmas
2011-08-31, 07:44 AM