Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default 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.)
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 703
Default 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.)


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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.)

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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.)





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 189
Default 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.)

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default 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.)


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying values from one sheet to the same cell in another sheet Ayo Excel Discussion (Misc queries) 2 September 19th 08 06:21 PM
Copying the repeated data of the previous sheet to the next sheet Sasikiran Excel Discussion (Misc queries) 1 September 25th 07 03:18 PM
Dynamic column chart - copying from Sheet to Sheet. Marko Pinteric Excel Discussion (Misc queries) 1 April 10th 06 12:57 PM
Dynamic column chart - copying from Sheet to Sheet. Marko Pinteric Charts and Charting in Excel 1 April 10th 06 12:57 PM
2 questions, copying data from sheet to sheet and assigning macro Boris Excel Worksheet Functions 0 December 16th 04 07:11 PM


All times are GMT +1. The time now is 12:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"