Forum Discussion

pantakos's avatar
pantakos
Copper Contributor
Nov 06, 2022

Copy range from other worksheet to an other at last

Hello all and Happy to be here.

 

I need to copy the contents of an excel worksheet (Named SHEET2) (Range A1:F30) to another worksheet. The catch is that I need to paste them at the end of the worksheet (SHEET1). Meaning the end , where the last filled row is that varies (using tables at SHEET1).

 

Hope you understand. 

 

Thank you, 

Jerry

Macros and VBA

1 Reply

  • SnowMan55's avatar
    SnowMan55
    Bronze Contributor
    Nov 06, 2022

    pantakos To copy a range of data, first determine what all of the source cells contain: values (like numbers or text or dates or times), or formulas.  Formulas start with an equal sign (=), as you can see in the Formula Bar when you click on (or navigate to) a cell that contains one.

     

    I will assume that your range to copy contains only values.  Then:

    1. On the source sheet (SHEET2 in your case), select the entire range.  You probably already know how to do that: Click (a corner cell) and drag till the entire range is selected.  Alternatively, click on the cell at the top-left of the range, or another corner; using the Shift key and arrow keys (e.g.,).
    2. To start the copying, press Ctrl+C.  Alternatively, right-click somewhere in the selected range to see the context menu (popup menu) and click the menu item "Copy".
    3. Click on the tab for the destination sheet (SHEET1).
    4. Scroll to where you can see the top-left cell where the range should be pasted.  It does not matter that this cell has a different address than the top-left cell of your source range.  Click that cell.
    5. Press Ctrl+V.  Alternatively, and to see the different ways you can paste content (and formatting), right-click that same cell and a context menu appears; hover over the Paste Options icons in turn, and click whichever is appropriate.

     

    Regarding SHEET1...  Many people use the term "tables" in the general sense of lists of data (whether single-column or multiple-column), but Microsoft has a technical meaning for an Excel table.  So there might be a future problem if SHEET1 really does have an Excel table above the place where you are going to paste the copy of the data.

Resources