+ Reply to Thread
Results 1 to 6 of 6

Copy till last - we have vba code, just required a modification

  1. #1
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Agra
    MS-Off Ver
    Office 2010
    Posts
    241

    Copy till last - we have vba code, just required a modification

    Hi,

    Sheet1
    we have following code for copy row Z8:Z13 to its next to row to last filled row

    HTML Code: 
    what changes required in the code so we don't need to change Z374 every time when we get new data

    i mean if we get new data in Z375:Z378 then it will auto filled till last cell, so we dont required to change Z value every time

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Copy till last - we have vba code, just required a modification

    Maybe
    Please Login or Register  to view this content.
    or do you need to use a different column to work out the last row?

  3. #3
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Agra
    MS-Off Ver
    Office 2010
    Posts
    241

    Re: Copy till last - we have vba code, just required a modification

    Yes, based on different column

    i mean if column A filled till Z272 then it will copy in Z8:Z13 to Z272
    if column A filled till Z278 then it will copy in Z8:Z13 to Z278

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Copy till last - we have vba code, just required a modification

    In that case use
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Agra
    MS-Off Ver
    Office 2010
    Posts
    241

    Re: Copy till last - we have vba code, just required a modification

    Thank you very much boss,

    its working

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Copy till last - we have vba code, just required a modification

    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] Modification required in VBA PDF to excel conversion-
    By Zahid0111 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-16-2020, 04:53 AM
  2. [SOLVED] Copy to blank row modification required
    By A440 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-26-2017, 11:49 AM
  3. VBA to copy down Vlookup VBA code in Column till last available data
    By shansakhi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-15-2014, 08:09 AM
  4. Replies: 6
    Last Post: 11-05-2013, 02:22 AM
  5. [SOLVED] Modification required in vba code.
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-01-2013, 07:12 AM
  6. [SOLVED] Macro modification required (very small)
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-21-2012, 01:34 PM
  7. Modification required in the code line which finds the Last column
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2008, 03:54 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