+ Reply to Thread
Results 1 to 5 of 5

Look for values in sheet1 (input) and paste output in dedicated cells in sheet2

  1. #1
    Registered User
    Join Date
    01-04-2013
    Location
    Örebro, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    7

    Question Look for values in sheet1 (input) and paste output in dedicated cells in sheet2

    Hi!

    At work, we are using an excel workbook to create a form of delivery note (which contains other data as well).
    There are several input sheets and one output sheet that contains a printable delivery note.

    One of the input sheets contains all available products in one column, one for quantity and one for units.
    Now I want to find all items where quantity >0 and place that data in the dedicated cells on the delivery note sheet.

    I quickly created an example file to explain how it looks. Hope it works, since I made it at home on Libre office

    Hopefully someone here can help!? Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Look for values in sheet1 (input) and paste output in dedicated cells in sheet2

    try the macro
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-04-2013
    Location
    Örebro, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Look for values in sheet1 (input) and paste output in dedicated cells in sheet2

    Thanks rcm! It works perfect.

    Just to spice things up a bit, I created a modified example file that looks more like our original (a bit more complex).
    Is there a way to edit the macro to fit the new file? I don't have enough knowledge to do it myself

    The input sheet has a number of hidden colums (needed for output in other sheets) and the values we need for the output
    are in columns B, Z and AA.

    Regarding the output sheet, the dedicated space starts at row 43 and contains of (9 rows x 2 cols) x 2.
    Is it possible to fit values in col Z + text in col AA from the input sheet into col 2 until row numbers = 52
    then begin filling values in columns D and E? The output file is only used for human reading so it doesn't matter if number formatting is lost.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Look for values in sheet1 (input) and paste output in dedicated cells in sheet2

    I parametized the output in the parameter TAB

    Empty col 28 means in which column the posting mark will go
    Columns 2 how many columns are to be printed
    Product 2 position (column no.) of the first column
    Delivered 26 position (column no.) of the 2nd column
    more columns could be added



    Output

    Startcol 1 column where the output begins
    Startrow 44 initial row
    Endrow 52 end row

    the rapping is done within the range above specified
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-04-2013
    Location
    Örebro, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    7

    Thumbs up Re: Look for values in sheet1 (input) and paste output in dedicated cells in sheet2

    Thanks again! Now I have put this macro in our file at work, and it works just great.
    Very good work!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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