+ Reply to Thread
Results 1 to 5 of 5

Copy cell above to blank cells below till last filled cell of other column

  1. 12-31-2018, 01:07 AM #1
    abhinavbinkar
    abhinavbinkar is offline
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Nagpur, India
    MS-Off Ver
    Excel 2010 / 2013
    Posts
    293

    Copy cell above to blank cells below till last filled cell of other column

    Please refer the file attached.

    I needed code to copy cell value from cell T3 to blank cells below till the last filled cell in column I.

    and also same for cell W3 to blank cells below till the last filled cell in column I.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-31-2018, 04:21 AM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: Copy cell above to blank cells below till last filled cell of other column

    Your attached file was not helpful at all. It has an auto-open macro that closes the file on open and you password protected the vba code modules. Cute.

    Here's some code that may or may not work...

    Please Login or Register  to view this content.
    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.
    Reply With QuoteRegister To Reply
  3. 12-31-2018, 05:15 AM #3
    abhinavbinkar
    abhinavbinkar is offline
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Nagpur, India
    MS-Off Ver
    Excel 2010 / 2013
    Posts
    293

    Re: Copy cell above to blank cells below till last filled cell of other column

    Quote Originally Posted by AlphaFrog View Post
    Your attached file was not helpful at all. It has an auto-open macro that closes the file on open and you password protected the vba code modules. Cute.
    Sorry sir, I havent noticed that. Please find new file attached.

    Your code is not working properly.

    I've also attached snap of the result i need in columns T & column W.
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 12-31-2018, 05:44 AM #4
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: Copy cell above to blank cells below till last filled cell of other column 

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 12-31-2018 at 05:47 AM.
    Reply With QuoteRegister To Reply
  5. 12-31-2018, 05:59 AM #5
    abhinavbinkar
    abhinavbinkar is offline
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Nagpur, India
    MS-Off Ver
    Excel 2010 / 2013
    Posts
    293

    Re: Copy cell above to blank cells below till last filled cell of other column

    Thank you so much Sir. SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to find the first blank cell in a column and add formula till lastused row
    By sobhnima in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-06-2018, 01:14 PM
  2. [SOLVED] Delete Rows till next filled Cell
    By Kaiserschmarrn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2016, 04:19 AM
  3. Find filled cell in column, select corresponding rows and copy only selected cells/columns
    By Tona in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-20-2015, 04:20 AM
  4. Counting text in between Months in a column till next blank cell
    By sapell in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2014, 04:41 PM
  5. [SOLVED] I need a macro to copy down till adjacent column ends in a blank cell
    By Paul Hayward in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2014, 02:27 PM
  6. [SOLVED] Find empty cell till next value merge or copy the respective cells in next column
    By rpriyadharsini1987 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2013, 03:46 AM
  7. Find a blank cell and calculate the average of all cells above till the next blank
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2012, 11:51 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1