+ Reply to Thread
Results 1 to 6 of 6

Loop in list and fill in other list

Hybrid View

  1. #1
    Registered User
    Join Date
    12-13-2013
    Location
    Bulgaria
    MS-Off Ver
    Excel 2010
    Posts
    3

    Loop in list and fill in other list

    Hello to everybody
    I really hope to help me. This will save me a lot of time each Mondays.
    A little preliminary. First of all for security reason I deleted 99% from orginal file witch one is much complicated. It is normal. This is my solution to manage the purchse orders from main costumer.
    Approximately we have 5000 orders per year. You can immagine we are exporting each week about 100 different PO's.
    So, I want the quantity from "Invoice" automaticly to be filled in "Order" just with one click after export.
    All the PO numbers like "P000003" are unique.
    The yellow marked lines are exported orders.

    Is it possible to do it and if yes, now?

    Thanks you in advance!

    P.S. I'mfrom east Europa.so I'm sorry for my not correct gramatically sentences.
    Attached Files Attached Files

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: Loop in list and fill in other list

    Hi theconscience,

    There is no 'Quantity' field in the Invoices worksheet.

    Can you clarify what you want where?

    Thanks
    Remember you are unique, like everyone else

  3. #3
    Registered User
    Join Date
    12-13-2013
    Location
    Bulgaria
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Loop in list and fill in other list

    Hi noboffinme
    Thanks for attention on my problem.

    The column with name "pieces" is quantity.
    Attached updated.
    Attached Files Attached Files

  4. #4
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: Loop in list and fill in other list

    Hi theconscience,

    I've added a column to the 'Orders' worksheet (The newly created 'Invoice Pieces' column) that looks up the 'Order_No' field & adds the 'Qty' amount to the same row for the 'Order_No'.

    There are no matches because there isn't a qty for the Order No in your data.

    I'm not really clear of what you're trying to do here...

  5. #5
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: Loop in list and fill in other list

    Sorry, forgot to add the file.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    12-13-2013
    Location
    Bulgaria
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Loop in list and fill in other list

    Hi noboffinme

    Few days I thougt how to describe my needs.
    I'll try in simple words.
    Genarally, I want VBA code.
    What the code shoud do it?
    To find quantity from one sheet and to write in another, according purchase order number.
    The idea with Vlookup is OK, but immagine next export! The purchase order numbers are different and if I use Vlookup function the values in yellow rows will be delelted because it is formula.
    That is why I need VBA.
    Sorry, but it is difficult explanation to me even in my native language!

+ 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: 2
    Last Post: 02-22-2015, 11:40 AM
  2. Replies: 0
    Last Post: 01-09-2013, 11:44 AM
  3. Replies: 3
    Last Post: 07-20-2012, 09:52 AM
  4. How to fill out with list?
    By Ghasemzadeh in forum Excel General
    Replies: 2
    Last Post: 03-19-2010, 05:17 PM
  5. Replies: 1
    Last Post: 09-17-2005, 10:05 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