Results 1 to 9 of 9

Macro Help - Newb here... Creating Table

Threaded View

  1. #1
    Registered User
    Join Date
    04-29-2014
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    6

    Macro Help - Newb here... Creating Table

    Hey All,
    So i'm definitely not smart with this stuff (which is why I'm coming to you all!)

    Here's what we're trying to do. We have a single worksheet and need to keep it on one sheet. The top "table" will be edited by the user. They will have the ability to insert rows and the data as necessary. Below this user-defined table we need two tables that separate the data that was collected.

    I'll try to explain this as best as possible and have attached the document as well.

    The table that people have the ability to edit/add to contains a model number, description of the item, total quantity of item sent, and the total quantity of that item they would like to return. The macro will need to separate the items by the quantity of items staying vs. the items being returned. The return table should just pull values from the "Return Qty" column (Column E). The Items Staying table will need to do a simple subtraction of Column D minus Column E (Qty minus Return Qty).

    I have searched many forums and spent too much time on the interwebs and I'm getting frustrated. Was hoping to find a similar code that I could manipulate to my needs, but again, I suck at this. My big hang up is the fact that people will have the ability to ADD rows to the user defined table. I was going to do some simple formula (if/then statements) to just copy data down, but that ability to add tables makes me feel like the macro is needed.

    Any of you able to help out??
    Last edited by vipvanilla; 05-02-2014 at 12:36 PM. Reason: Problem solved!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Creating Macro Table
    By Julian86 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-18-2013, 09:10 AM
  2. [SOLVED] Creating new table with macro
    By damaple in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-01-2013, 05:14 AM
  3. Newb needs help on how to populate a table
    By Mr Nat in forum Excel General
    Replies: 1
    Last Post: 07-09-2013, 09:20 PM
  4. Newb VBA developper needs Macro help with dates
    By baggio7 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-30-2010, 01:18 AM
  5. Newb needs macro help.
    By S3NTYN3L in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-06-2006, 09:16 PM

Tags for this Thread

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