Results 1 to 8 of 8

Code/Macro to populate table based on user input.

Threaded View

galvinpaddy Code/Macro to populate table... 12-05-2011, 05:51 PM
galvinpaddy Re: Code/Macro to populate... 12-05-2011, 05:54 PM
galvinpaddy Re: Code/Macro to populate... 12-06-2011, 10:49 AM
galvinpaddy Re: Code/Macro to populate... 12-07-2011, 11:17 AM
watersev Re: Code/Macro to populate... 12-07-2011, 11:34 AM
galvinpaddy Re: Code/Macro to populate... 12-07-2011, 01:37 PM
watersev Re: Code/Macro to populate... 12-07-2011, 05:15 PM
galvinpaddy Re: Code/Macro to populate... 12-08-2011, 07:50 AM
  1. #1
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Office 365
    Posts
    879

    Code/Macro to populate table based on user input.

    Hello Happy Campers!
    (first off, nice new look forums!)

    I have a workbook (attached)

    Sheet1 - Main Table
    Sheet2 - Data

    In sheet 2 i will add info into cells A1 & B1 (always 2 cells as A is the item, & B is the qty) and there will always be more than one line of data, but not a fixed amount.

    I would like either formula's or Code to do the following;
    From the info, populate 'Main Table' by looking at the item and then placing the respective qty in the column with matching date. (date, taken from date of entry on sheet or would i need to add a cell with the date i want to add/find?)

    The sheet attached has the info how i would like it to look.

    Many thanks in advance

    Galvinpaddy
    Attached Files Attached Files
    Last edited by galvinpaddy; 12-07-2011 at 01:40 PM. Reason: uploaded file

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