+ Reply to Thread
Results 1 to 4 of 4

Macro to copy a cell, paste it to another sheet, then move down, without moving formulas

  1. #1
    Registered User
    Join Date
    11-25-2016
    Location
    Warrington
    MS-Off Ver
    2010
    Posts
    60

    Macro to copy a cell, paste it to another sheet, then move down, without moving formulas

    Hi,

    I need help and I'm not great with macros but if you can tell me a way to do what I want with 1 cell I will be able to mimic the results for multiple cells.

    I've had a look through the threads and I've seen some which are similar but not exactly what I want and they all seem to do the same, which is when I shift the data down by 1 cell any formulas I have set up to read the data also moved down.

    this is what I wrote which does the copying and the poasting and shifts the cells down:

    Please Login or Register  to view this content.
    When I then want to do some calculation on the data that appears in sheet "data" the ranges on the formulas I write keep moving down, how do I stop the shift from effecting my formulas range?

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

    Re: Macro to copy a cell, paste it to another sheet, then move down, without moving formul

    When you insert a row on sheet Data, that would affect the formulas that reference that data. The code below copies all the data and pastes it one row down. That shouldn't affect formulas. Other copy\paste lines were cleaned up as well.

    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.

  3. #3
    Registered User
    Join Date
    11-25-2016
    Location
    Warrington
    MS-Off Ver
    2010
    Posts
    60

    Re: Macro to copy a cell, paste it to another sheet, then move down, without moving formul

    I love you!

    You beautiful person!

    Thank you for also tidying up my code

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

    Re: Macro to copy a cell, paste it to another sheet, then move down, without moving formul

    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. macro to copy from one sheet and paste to another sheet defined by cell value
    By bryans88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2015, 02:09 PM
  2. Macro to copy rows based on moving date and paste the rows into an identical sheet
    By ivandc1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2014, 11:59 AM
  3. Replies: 4
    Last Post: 08-12-2013, 01:35 PM
  4. Replies: 7
    Last Post: 12-03-2012, 03:10 AM
  5. Replies: 1
    Last Post: 10-07-2012, 11:01 AM
  6. [SOLVED] Copy, paste, then move to a new sheet.
    By Cyberpawz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2012, 02:12 PM
  7. Replies: 2
    Last Post: 10-15-2009, 10:12 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