Results 1 to 13 of 13

update value and edit items already update on sheet by userform

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    12

    update value and edit items already update on sheet by userform

    Hi,
    I have work on my first VBA on the attached file. I need help in couple of them. First let me tell what the sheet is all about. I have a sheet on as Item master list that has all the items used in cooking. along with price and broken down to per gram or per ml. the rest of the sheet is the menu costing sheet where items are updated using userform. Now what i want is that in the attached sheet example say on the sheet 1 the value update for "egg" is one dozen ( 12 peice ) Rs.60, which bring the value of 1 egg to Rs.5. Now what i want is if for some reason the egg price should or have gone up say Rs.80 ( 12 peice) so the value for a single has gone up by Rs.6.67. And since there are close to 45-50 sheets where eggs are used its not possible to update every sheet. what code to write so that when i update the value Rs.80 on sheet1 the result for a single peice is reflected on all the sheet where eggs are used.
    Second i also want say in sheet 2 named egg nog milk used is 80 ml but that has to be 100ml. which needs to be corrected. how or what is to be added in the userform so that i can edit the information which out disturbing any other info, and also can be use in any of the sheet to correct such info.

    Thanks in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA Userform Edit/Update record help
    By sa.1985 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-20-2013, 10:29 AM
  2. Update excel based on userform text box update
    By sivakumar123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2013, 01:01 AM
  3. [SOLVED] update button on userform does not update all cells in worksheet
    By tutke in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-27-2012, 03:07 AM
  4. edit data in userform and update spreadsheet
    By nunans in forum Excel General
    Replies: 2
    Last Post: 03-08-2012, 04:44 AM
  5. Edit/Update list from userform (auto alphabetized)
    By Jogier505 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-07-2009, 06:28 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1