Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: Need code [Automatically calculate new results as values are entered on other sheets]

  1. #1

    Need code [Automatically calculate new results as values are entered on other sheets]



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 Spare parts inventory.xlsmSpare parts inventory.xlsm

  2. #2
    Need HELP and advises please.

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,021
    Articles
    79
    Blog Entries
    14
    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?
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  4. #4
    @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!Spare parts inventory.xlsm

  5. #5
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,021
    Articles
    79
    Blog Entries
    14
    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...
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  6. #6
    @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.

  7. #7
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,021
    Articles
    79
    Blog Entries
    14
    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.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  8. #8
    @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.Spare parts inventory.xlsm

  9. #9
    Any Help or advises please.

  10. #10
    Acolyte gsnidow's Avatar
    Join Date
    Aug 2011
    Location
    Virginia
    Posts
    38
    Articles
    0
    Quote Originally Posted by bodmas View Post
    Any Help or advises please.
    Bodmas, I think you should take Ken's suggestion to heart. Once you read up on relational database theory, you can get all the Access help you need at www.accessmonster.com. Please don't take this the wrong way, but trying to force into Excel a model that is best served by a relational database is going to require constant maintanence. There will be a hefty learning curve, but you will be doing yourself a great favor by learning Access. Just my two cents.

    Greg

Page 1 of 2 1 2 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •