Results 1 to 2 of 2

Create a Table That Can Expand in Size

Threaded View

  1. #1
    Registered User
    Join Date
    02-16-2011
    Location
    Massachusetts
    MS-Off Ver
    Excel 2003
    Posts
    4

    Create a Table That Can Expand in Size

    Hello. I am looking for some help with a macro that will create a table for me based on data provided and also be able to grow if I add more sets of data.

    I've attached a spreadsheet of what my data will look like and also manually created a table below to show what I am hoping the results will be. For the data I've allowed for up to 20 rows of data to be entered, so when the table is created there will be 20 rows per set, but if not every row is used there will be blanks. This issue I am fine with because I have a macro that can remove empty rows. I am just looking for a macro that can create the table for me.

    If any help can be provided, it would be greatly appreciated.
    Attached Files Attached Files

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