+ Reply to Thread
Results 1 to 4 of 4

Copy from excel to a word table to the next available cell in column

  1. #1
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Lightbulb Copy from excel to a word table to the next available cell in column

    Hello
    I have 2 files:
    A-TESTI.xlsm <--- Where I keep the certifiactes of material
    (3)Material.docx <----- Where I make a report of which materials were used in a specific project.

    In my excel file I have column J where I set when I hit the Send&Print it prints out the hyperlink and "hope some day will" send a value to the word document next to 1 so CellRange is 5,2 in the table.
    How can I make excel check the next available cell in column 2 of the word table? In this case it should look like this:
    1 Something Writen
    2 Something Writen
    3 Empty
    And excel would search somehow for the next empty cell in column 2 of the word table.
    I could make an If statment for every cell in column 2 but thats a lot of if's.
    Is there some code like for checking the last used cell in a column in excel like:
    Please Login or Register  to view this content.
    Can one be made for checking in word? like:
    Tables(1).Cell(Column2).End(xlUp) <<<---
    Attached Files Attached Files

  2. #2
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: Copy from excel to a word table to the next available cell in column

    Nothing eh?

  3. #3
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: Copy from excel to a word table to the next available cell in column

    Does no one know the answer to this?
    How about Start at Range Row 1 Column 2 and if that is empty move down to the next cell and check if range row 2 column 2 is empty? and so on?

  4. #4
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: Copy from excel to a word table to the next available cell in column

    After a lot of googleing I got my answer. So solved.

+ Reply to Thread

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