acaPAWN7
Board Regular
- Joined
- Oct 11, 2006
- Messages
- 71
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:
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: