+ Reply to Thread
Results 1 to 2 of 2

add data to already entered data in another worksheet

  1. #1
    Forum Contributor
    Join Date
    06-07-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    167

    add data to already entered data in another worksheet

    Hello Dear Experts
    i want only the data in blue highlighted column range E14:E37 in invoice must be added against its respective product codes in Stock.
    for example
    In case of sale transaction it should be added to qty. sold against respective product code in stock.
    In case of Purchase transaction same data should be added to qty. purchased in stock against its respective code.

    i hope my question is clear
    My sheet attached

    thanks
    roofi
    Attached Files Attached Files
    Abdul Rouf Roofi

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: add data to already entered data in another worksheet

    very roughly thrown together but attach this to your Post Invoice button

    Please Login or Register  to view this content.
    If someone has helped you then please add to their Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 06-07-2017, 02:26 PM
  2. Populating a Worksheet with data entered on other worksheets
    By ExcelSpreads in forum Excel General
    Replies: 24
    Last Post: 01-28-2016, 07:52 AM
  3. formula to scan array on a worksheet for data entered in another worksheet
    By cprpacific in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2015, 06:43 PM
  4. Replies: 8
    Last Post: 01-23-2013, 03:36 AM
  5. Transfer Data to another worksheet once certain variable is entered
    By J_Freeze in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2013, 01:36 AM
  6. Data/shapes entered in worksheet, how do duplicate data to another worksheet?
    By barleycorn in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-22-2012, 04:57 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