+ Reply to Thread
Results 1 to 3 of 3

Copy formula, insert value, shift down

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,946

    Copy formula, insert value, shift down

    I haven't run across this one before, so not sure how to approach it. Cell A5 is a formula. I want the value of A5 to be placed in H1, but as an insert, because I want the current H1 (and H2, etc) to shift down.

    As I was typing this I realized I could do the reverse: Shift the cells down, then put the value of A5 into the freshly cleared H1. But, I'd still like to know if there's a more straightforward way to do it.
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Copy formula, insert value, shift down

    When you copy the cell, select the cells where you want to insert and right click to select "Insert Copied Cells", then seelct "Shift Cells Down"

    code would look something like this,
    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,946

    Re: Copy formula, insert value, shift down

    Did it like this:
    Please Login or Register  to view this content.

+ 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] Marco to Insert & shift cells down at active cell and copy cell range
    By jyarbrough in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2015, 06:18 AM
  2. Formula to insert shift daywise
    By akashmenon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2014, 01:43 AM
  3. Replies: 0
    Last Post: 11-12-2013, 04:56 PM
  4. Need Help on Time Sheet Formula (Day Shift OK/Night Shift=Problem)
    By jomapac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-18-2013, 02:26 AM
  5. [SOLVED] Shift horizontal range of text based on a parameter, copy formula down across
    By David Brown in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2013, 10:14 AM
  6. Help - Insert method of Range class failed - Selection.Insert Shift:=xlToRight
    By sandy@excelforum in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2012, 11:14 AM
  7. Macro to copy a row, then insert shift:=x1Down
    By Lost in Alabama in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2006, 08:00 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