+ Reply to Thread
Results 1 to 3 of 3

Populating 2 columns of table from array

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Populating 2 columns of table from array

    Hi,

    i have table like this:

    Screenshot_9.png

    And code for this is:

    Please Login or Register  to view this content.
    now i do not want to populate whole table from array - only 2 columns.
    And i am using index for this one.

    The problem is that i have to use it 2 times like this:

    Please Login or Register  to view this content.
    it is possible to do this only one time?
    To output only column4 and column5 to table in one time?

    I do not want to output array to whole table because in my real data numbers like "12.3" are changed to "12,3" so i prefer to avoid this.

    Best,
    Jacek
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: Populating 2 columns of table from array

    Please Login or Register  to view this content.
    Last edited by jindon; 05-21-2019 at 07:25 AM.

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Populating 2 columns of table from array

    Thank you jindon,

    you are the best!

    Working like a charm.

    Best,
    Jacek

+ 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. [SOLVED] Noncontiguous columns to array -trying to correlate columns to array positions - and redim
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-19-2019, 08:11 AM
  2. VBA populating a table based on columns and rows
    By Vokesie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-24-2016, 06:03 PM
  3. [SOLVED] Populating Array
    By jim808 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-17-2016, 03:56 AM
  4. [SOLVED] table(A) as an array using all rows but only selected columns to compare with table(B)
    By se3unlock in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-27-2015, 10:15 AM
  5. Reference two columns to get result in table array
    By mrussell555 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-01-2013, 08:56 PM
  6. [SOLVED] Adding Record to data table + preserve array formulas in specific columns
    By olivierpbeland in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 02:33 PM
  7. Populating Array in VBA
    By phil_b in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-13-2010, 10:15 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