+ Reply to Thread
Results 1 to 5 of 5

Trying to make a stock movement sheet that moves stock between sheets without overwriting

  1. #1
    Registered User
    Join Date
    09-22-2016
    Location
    England
    MS-Off Ver
    2013
    Posts
    14

    Trying to make a stock movement sheet that moves stock between sheets without overwriting

    I am trying to make a stock movement sheet that draws information of where the stock is being moved to from sheet A and then puts it onto sheet B. i have tried to make this happen but have only succeeded in drawing the first movement into all of the available slots, any help would be greatly appreciated.


    image001.pngScreenshot_3.jpg

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,999

    Re: Trying to make a stock movement sheet that moves stock between sheets without overwrit

    .
    Sorry, your description is confusing. Please be more specific where the data is coming from , where it is going and what should the result be after the copy/paste ?

    I think the image you provided, the lower right had section represent the "To" sheet .. where the data will be pasted ?

    If the data on the first sheet changes, are you wanting that new data to paste into the second sheet but into the first blank row under the existing data ? Or ???

  3. #3
    Registered User
    Join Date
    09-22-2016
    Location
    England
    MS-Off Ver
    2013
    Posts
    14

    Re: Trying to make a stock movement sheet that moves stock between sheets without overwrit

    apologies, i am wanting to be able to put the location that stock is being moved to into A:A on the first image, this would then pull values from C:C and beyond into the second table, there are several parts of each section (A1, A2, etc) and i am wanting it that if there is no value in A:A then the data will copy to sheet 2 using the value in B:B.
    Last edited by BaronVonBeefDip; 11-14-2018 at 03:18 AM.

  4. #4
    Registered User
    Join Date
    09-22-2016
    Location
    England
    MS-Off Ver
    2013
    Posts
    14

    Re: Trying to make a stock movement sheet that moves stock between sheets without overwrit

    I have managed to get the stock to pull through from table 1 to table 2 with the following formula:
    {=IF(SHEET1!A:A=0,SHEET1!C85,VLOOKUP(B:B,SHEET1!A:C,3,FALSE))}
    what I am trying to do now is make it so that there can be multiple entrances per location on sheet 2.
    For example location A1 has 5 slots, if 2 of 5 slots filled and one product is being moved to location A1, I need the codes already in A1 to stay and then the third A1 slot to have the new product placed into it.

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,488

    Re: Trying to make a stock movement sheet that moves stock between sheets without overwrit

    I notice that you have opened two other threads since this one, so you may already have a solution to the stock movement issue. If not I would suggest that you upload a sample workbook showing what input data will be on sheet 1 and then manually fill in the expected output that will be on sheet 2 so that we may attempt to automate the process using formulas/code.
    To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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: 31
    Last Post: 10-28-2015, 01:54 AM
  2. VBA Code to pull Stock Balance Sheet Data from a Stock Symbol in a cell
    By akash1229 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-27-2015, 04:37 PM
  3. STOCK MOVEMENT day to day
    By makinmomb in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-10-2014, 12:34 PM
  4. I need a stock order sheet to be created from a stock inventory
    By tamhav in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-20-2014, 10:40 AM
  5. Stock values linked to physical stock on seperate sheet
    By Andycoulton in forum Excel General
    Replies: 6
    Last Post: 08-28-2013, 05:15 AM
  6. Replies: 4
    Last Post: 01-29-2013, 02:26 AM
  7. Replies: 0
    Last Post: 10-28-2012, 07:22 AM

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