Copy and paste problem

[acaPAWN7]

I'm not sure whether there are other topics related to this problem.. If so, do tell me k


I want to have a macro that can copy and paste a table from one sheet to the other sheet automatically.. Let say, there are 2 sheets; 'PC' sheet and 'Option' sheet..

This is the table in the 'PC' sheet before the user input the details:

The user will input all details in 'PC' sheet.. User will input the items and costs.. Example is such below:

Then, at the 'Option' sheet, the same table will appear.. But at different rows (as you can see at the example below):

The rows are different, right?

So, my problems are:
1. In the 'PC' sheet, if the user change the details in the Item and Cost column, such as change the cost value for PRELIMINARIES WORKS, the table in 'Option' sheet will be updated automatically.
2. In the 'PC' sheet, if the user make changes, such as adding a new row between the PRELIMINARIES WORKS and SPECIAL EQUIPMENT Phase 1, or even deleting the Preliminaries, the table in 'Option' sheet will be the same (updated automatically).
3. If the user leaves a blank in the Item column, such as cell E21 in the 'PC' sheet, the same section of the table in the 'Option' sheet will remain as blank.


So, are there any possible solution for my problems here? Hopefully, my problems will be solved as exactly as the printviews that I have included.. Looking for any experts here~ :wink:

 

[Jaafar Tribak]

If you are not going to edit sheet "OPTIONS" then how about Pasting a Picture Link of the Table.

Copy the Table in Sheet "PC", activate Sheet "OPTIONS", activate the Cell where you want to have the left-Top corner of the copy table , hold down the SHIFT key and select Paste Picture Link from the Edit Menu.

Any changes made to the original table will now be automatically reflected on its copy in the other sheet.

You can also protect sheet "OPTIONS" to prevent messing-up the table copy.

Regards.

 

[acaPAWN7]

Wow.. I never thought to use this kind of solution.. It's so easy and very simple to use.. But I need to edit the pasted table, bcoz I want to remove all of the borders (except the total amount).. Btw, thanks Jaafar~