Copying Table from one Sheet to Another
 

I just want to copy a small table from one sheet to another. Whenever
it is updated on the main sheet, it will also be automatically updated
on the second sheet. When I put it on the second sheet it will be in
a different area as well.

Can you do this without macros?

Thanks (I have ASAP utilities, but after fiddling with it all morning
I drew a blank.)

Answer: Copying Table from one Sheet to Another
 

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

1. 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).
2. Select the table on the source sheet by clicking and dragging over the cells.
3. Press Ctrl+C or right-click and select "Copy" to copy the table to the clipboard.
4. Go to the destination sheet and select the cell where you want to paste the table.
5. Right-click and select "Paste" or press Ctrl+V to paste the table.
6. If the table is not in the desired location, click and drag it to the desired location.
7. 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.

Copying Table from one Sheet to Another
 

Hi

Copy headings etc. from main sheet and paste in desired cells on
second sheet.

Select the first cell on second sheet which shall update automafically
and type in an equal sign, then use the mouse to point at the desired
cell on main sheet. Repeat the previous or drag the formula as
desired.

The formula will look like this: =Sheet1!A1

Hopes it helps.

--
Per

On 12 Jan., 01:51, JimS wrote:
I just want to copy a small table from one sheet to another. *Whenever
it is updated on the main sheet, it will also be automatically updated
on the second sheet. *When I put it on the second sheet it will be in
a different area as well.

Can you do this without macros?

Thanks (I have ASAP utilities, but after fiddling with it all morning
I drew a blank.)

Copying Table from one Sheet to Another
 

Hi,

Select Original Table, Copy it

select the location from other sheet where you want to copy the table.

Click Edit--Paste Special, from Paste Special dialog box, select All from
Paste options, and click on Paste Link button. This will paste the table in
other sheet in such a way that when you'll make changes in original sheet
that would get reflected in the other sheet.

I am sure, this will help you


"JimS" wrote:

I just want to copy a small table from one sheet to another. Whenever
it is updated on the main sheet, it will also be automatically updated
on the second sheet. When I put it on the second sheet it will be in
a different area as well.

Can you do this without macros?

Thanks (I have ASAP utilities, but after fiddling with it all morning
I drew a blank.)

Copying Table from one Sheet to Another
 

Hi,

Select table from original worksheet. copy it. open another worksheet. click
on Edit Menu, select Paste Special. From Paste Special dialog box, click on
Paste Link button. It will paste the table in such a way that whenever you
make the changes in original table it would reflect the table in other
worksheet.

Definitely this would help you.


"Per Jessen" wrote:

Hi

Copy headings etc. from main sheet and paste in desired cells on
second sheet.

Select the first cell on second sheet which shall update automafically
and type in an equal sign, then use the mouse to point at the desired
cell on main sheet. Repeat the previous or drag the formula as
desired.

The formula will look like this: =Sheet1!A1

Hopes it helps.

--
Per

On 12 Jan., 01:51, JimS wrote:
I just want to copy a small table from one sheet to another. Whenever
it is updated on the main sheet, it will also be automatically updated
on the second sheet. When I put it on the second sheet it will be in
a different area as well.

Can you do this without macros?

Thanks (I have ASAP utilities, but after fiddling with it all morning
I drew a blank.)

Copying Table from one Sheet to Another
 

Deepali is right
--
Thanks
Suleman Peerzade


"JimS" wrote:

I just want to copy a small table from one sheet to another. Whenever
it is updated on the main sheet, it will also be automatically updated
on the second sheet. When I put it on the second sheet it will be in
a different area as well.

Can you do this without macros?

Thanks (I have ASAP utilities, but after fiddling with it all morning
I drew a blank.)

Copying Table from one Sheet to Another
 

Thanks to all! I knew there was an easy way to do that, but I forgot
about paste link. Works perfectly.

On Sun, 11 Jan 2009 21:53:00 -0800, Deepali Joshi
wrote:

Hi,

Select Original Table, Copy it

select the location from other sheet where you want to copy the table.

Click Edit--Paste Special, from Paste Special dialog box, select All from
Paste options, and click on Paste Link button. This will paste the table in
other sheet in such a way that when you'll make changes in original sheet
that would get reflected in the other sheet.

I am sure, this will help you


"JimS" wrote:

I just want to copy a small table from one sheet to another. Whenever
it is updated on the main sheet, it will also be automatically updated
on the second sheet. When I put it on the second sheet it will be in
a different area as well.

Can you do this without macros?

Thanks (I have ASAP utilities, but after fiddling with it all morning
I drew a blank.)