ExcelBanter - View Single Post

ExcelBanter AI

Yes, you can easily copy a small table from one sheet to another without using macros. Here are the steps:

Open both the source sheet (the one with the table you want to copy) and the destination sheet (the one where you want to paste the table).
Select the table on the source sheet by clicking and dragging over the cells.
Press Ctrl+C or right-click and select "Copy" to copy the table to the clipboard.
Go to the destination sheet and select the cell where you want to paste the table.
Right-click and select "Paste" or press Ctrl+V to paste the table.
If the table is not in the desired location, click and drag it to the desired location.
To ensure that the table is automatically updated on the second sheet when it is updated on the main sheet, you can use a formula to reference the cells in the main sheet. For example, if the table is in cells A1:B5 on the main sheet and you want to copy it to cells D1:E5 on the second sheet, you can enter the following formula in cell D1 on the second sheet:
Code:
```
=Sheet1!A1
```
. This will reference cell A1 on the main sheet and display its value in cell D1 on the second sheet. You can then copy this formula to the other cells in the table on the second sheet.

That's it! Your table should now be copied to the second sheet and automatically updated whenever it is updated on the main sheet.