Results 1 to 9 of 9

Dynamic AutoFill Destination Range

Threaded View

cesrua Dynamic AutoFill Destination... 01-13-2016, 01:34 PM
6StringJazzer Re: Dynamic AutoFill... 01-13-2016, 01:54 PM
cesrua Re: Dynamic AutoFill... 01-13-2016, 03:34 PM
6StringJazzer Re: Dynamic AutoFill... 01-13-2016, 03:48 PM
cesrua Re: Dynamic AutoFill... 01-13-2016, 03:53 PM
cesrua Re: Dynamic AutoFill... 01-13-2016, 05:05 PM
cesrua Re: Dynamic AutoFill... 01-18-2016, 12:51 PM
6StringJazzer Re: Dynamic AutoFill... 01-18-2016, 03:32 PM
6StringJazzer Re: Dynamic AutoFill... 01-18-2016, 03:33 PM
  1. #6
    Registered User
    Join Date
    01-13-2016
    Location
    Madrid
    MS-Off Ver
    2013
    Posts
    5

    Re: Dynamic AutoFill Destination Range

    As you can see in the Image:

    STATEMENTS EXECUTED IN THE IMAGE
    Statement 1 -> I know cell with value="ACTUAL" is in row 50. So I move to cell A50.
    Statements 2-3 -> Because I have only 3 values (Star, Actual, End) I can select Actual cel with pressing ctrl+right twice.
    Statement 4 -> I can select only cells between rows 50-58 pressing ctrl+sift+down and copy them.
    Statement 5 -> I insert cells moving to the right.

    STATEMENTS TO EXECUTE
    Statement 6-7 -> Because after first 5 statements i know there are blank cells i can reach the las values column by selecting cell A51 and pressing ctrl+right once.
    Statement 8 -> I can select only cells between rows 51-58 pressing ctrl+sift+down.
    Statement 9 -> I need to Autofill the blank cells with the formulas on the range i currently have selected but i don't know how.

    I hope is clearer now, thank you very much.
    Last edited by cesrua; 01-13-2016 at 05:10 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy from static destination & paste to dynamic destination
    By Marbleking in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-31-2015, 09:31 AM
  2. [SOLVED] Autofill Destination Range
    By ERaasio in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-14-2014, 03:02 PM
  3. Autofill a destination range using last row value
    By jaym911 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-29-2013, 12:07 PM
  4. [SOLVED] AutoFill Destination Unknown Range
    By sperry2565 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-08-2013, 04:53 PM
  5. How to extend Range.AutoFill Destination down an addition 3 rows?
    By BBoydAnchor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2011, 10:51 AM
  6. Autofill in VBA with a dynamic "Destination" range
    By ConneXionLost in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2011, 04:55 PM
  7. Selection.Autofill Destination:=Range(ActiveCell.Value)
    By Shaka215@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-23-2006, 06:20 PM

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