+ Reply to Thread
Results 1 to 4 of 4

VBA to fill contract from last row of list

  1. #1
    Forum Contributor
    Join Date
    12-20-2016
    Location
    Uzbekistan
    MS-Off Ver
    2016
    Posts
    189

    Question VBA to fill contract from last row of list

    Dear Excel Professionals,

    Let me ask You a question, can You please help me with how to fill Contract with last row from range with button, attaching photo and file.vba fill contract.jpg

    Thank You
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: VBA to fill contract from last row of list

    You could do it with just formulas

    K1
    =INDEX(A:A,COUNTA(A:A))

    K2
    =INDEX(B:B,COUNTA(A:A))

    etc.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    12-20-2016
    Location
    Uzbekistan
    MS-Off Ver
    2016
    Posts
    189

    Re: VBA to fill contract from last row of list

    AlphaFrog formula works perfectly didn't know that it can be solved just with formula Thank You!
    Last edited by tta.akmal; 12-26-2018 at 07:31 AM.

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: VBA to fill contract from last row of list

    You're welcome. Thanks for the feedback.

+ 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] Cannot seem to fill list box
    By bralew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2016, 08:37 AM
  2. Need To Know The End Of Contract
    By ibqaed in forum Excel General
    Replies: 4
    Last Post: 05-05-2016, 03:25 AM
  3. Skip x cells and fill (Fill/create weekly average from 7 days and fill down)
    By tunafishes in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-18-2016, 03:43 AM
  4. [SOLVED] Fill List Box with Five Text Boxes and Put List Box on Sheet
    By AmirSoft in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-25-2014, 11:42 AM
  5. Loop in list and fill in other list
    By theconscience in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-31-2013, 04:33 AM
  6. how to sum all the contract until end of the contract period
    By neskafeice in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2012, 07:37 AM
  7. Replies: 1
    Last Post: 09-17-2005, 10:05 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