arindamsenaxa
New Member
- Joined
- Feb 20, 2015
- Messages
- 1
HI I need a help in coding
I have a spreadsheet which linked with a web page through DATA menu from web
So every time it gave me a new data or sometimes blank when it got refresh automatically.
I want to copy the data (if there is a data) from sheet one to sheet 2 the problem what I am facing is
every time when it got refresh if the web page is not having any data or updated with new data then my sheet 1 (where I link the web page) is coming as blank or only with new data ,but I want all the previous details also ,so is there any code by which I can immediately save the 1st sheet data in the 2nd sheet, and second time if it’s get any other new data then it save the new data in the 2nd sheet but in the next row (as the previous data is already copy pasted from sheet one to sheet 2.
I Am attaching the excel file how my first sheet is look like and how I want the second sheet data.
First Sheet
<colgroup><col span="40"><col><col span="2"><col><col span="4"><col><col span="18"></colgroup><tbody>
</tbody>
Second Sheet should be
<colgroup><col span="40"><col><col span="2"><col><col span="4"><col><col span="19"></colgroup><tbody>
</tbody>
I have a spreadsheet which linked with a web page through DATA menu from web
So every time it gave me a new data or sometimes blank when it got refresh automatically.
I want to copy the data (if there is a data) from sheet one to sheet 2 the problem what I am facing is
every time when it got refresh if the web page is not having any data or updated with new data then my sheet 1 (where I link the web page) is coming as blank or only with new data ,but I want all the previous details also ,so is there any code by which I can immediately save the 1st sheet data in the 2nd sheet, and second time if it’s get any other new data then it save the new data in the 2nd sheet but in the next row (as the previous data is already copy pasted from sheet one to sheet 2.
I Am attaching the excel file how my first sheet is look like and how I want the second sheet data.
First Sheet
| Request | Quote | Opportunity ID | Customer Type | Customer Sub Type | LOB | Phase | Status | Customer | Organization | Country | Region | Sub Region | Queue | Sub Queue | Net Fees (USD) | Currency | Requested By | Assigned To | Responsible | Alternate Contacts | Sales Channel | Sales Rep | Reseller Customer | CSI# | Shipment Method | Payment Terms | Contract Number | Web Quote ID | Product Changes | Work Type | Managed Deal | Request Priority | Required Since | Required | Product Type | Business Unit | Open Changes | Related Quotes | Last Reopen Date | Draft Flag | Creation Date | Last Updated Date | Created By | Last Updated By | Updated SinceDescending | Revision Count | Request Age | Sub Status | Vertical Type | Sales Regional Manager | Ezo Number | Self Service | Agreement Type | Net Fee License | Net Fee Hardware | Net Fee Support | IAAS Flag | ePACT Quote Number | IPM Status | AR Contingency | Sub Lob Type | Managed Deal Flag | Conditional Approver | Request Sub Type | Request Type | |
| /iPD Deal/POR # | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| View | 123 | 5456 | 8542 | 654 | DVAR | H | q | N | abcd | abt | IN | INDIA | INDIA | N | Not Assigned | 265,864 | RS | adc | - | - | - | Field Sales | a | sfd | - | Standard | - | - | - | - | - | Standard | - | - | - | - | 0 | - | 2/19/2015 0:47 | - | 2015-FEB-19 00:47 | 2015-FEB-19 00:55 | a | a | 30 minutes ago | - | 0 Hrs 37 Mins | - | ACME | - | - | No | - | - | - | - | - | - | - | - | - | - | - | Quote for Standard Revenue Order | Ordering Document | |
| Request | Quote | Opportunity ID | Customer Type | Customer Sub Type | LOB | Phase | Status | Customer | Organization | Country | Region | Sub Region | Queue | Sub Queue | Net Fees (USD) | Currency | Requested By | Assigned To | Responsible | Alternate Contacts | Sales Channel | Sales Rep | Reseller Customer | CSI# | Shipment Method | Payment Terms | Contract Number | Web Quote ID | Product Changes | Work Type | Managed Deal | Request Priority | Required Since | Required | Product Type | Business Unit | Open Changes | Related Quotes | Last Reopen Date | Draft Flag | Creation Date | Last Updated Date | Created By | Last Updated By | Updated SinceDescending | Revision Count | Request Age | Sub Status | Vertical Type | Sales Regional Manager | Ezo Number | Self Service | Agreement Type | Net Fee License | Net Fee Hardware | Net Fee Support | IAAS Flag | ePACT Quote Number | IPM Status | AR Contingency | Sub Lob Type | Managed Deal Flag | Conditional Approver | Request Sub Type | Request Type | |
| /iPD Deal/POR # | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| View | 123 | 5456 | 8542 | 654 | DVAR | H | q | N | abcd | abt | IN | INDIA | INDIA | N | Not Assigned | 265,864 | RS | adc | - | - | - | Field Sales | a | sfd | - | Standard | - | - | - | - | - | Standard | - | - | - | - | 0 | - | 2/19/2015 0:47 | - | 2015-FEB-19 00:47 | 2015-FEB-19 00:55 | a | a | 30 minutes ago | - | 0 Hrs 37 Mins | - | ACME | - | - | No | - | - | - | - | - | - | - | - | - | - | - | Quote for Standard Revenue Order | Ordering Document | |
| Request | Quote | Opportunity ID | Customer Type | Customer Sub Type | LOB | Phase | Status | Customer | Organization | Country | Region | Sub Region | Queue | Sub Queue | Net Fees (USD) | Currency | Requested By | Assigned To | Responsible | Alternate Contacts | Sales Channel | Sales Rep | Reseller Customer | CSI# | Shipment Method | Payment Terms | Contract Number | Web Quote ID | Product Changes | Work Type | Managed Deal | Request Priority | Required Since | Required | Product Type | Business Unit | Open Changes | Related Quotes | Last Reopen Date | Draft Flag | Creation Date | Last Updated Date | Created By | Last Updated By | Updated SinceDescending | Revision Count | Request Age | Sub Status | Vertical Type | Sales Regional Manager | Ezo Number | Self Service | Agreement Type | Net Fee License | Net Fee Hardware | Net Fee Support | IAAS Flag | ePACT Quote Number | IPM Status | AR Contingency | Sub Lob Type | Managed Deal Flag | Conditional Approver | Request Sub Type | Request Type | |
| /iPD Deal/POR # | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| View | 123 | 5456 | 8542 | 654 | DVAR | H | q | N | abcd | abt | IN | INDIA | INDIA | N | Not Assigned | 265,864 | RS | adc | - | - | - | Field Sales | a | sfd | - | Standard | - | - | - | - | - | Standard | - | - | - | - | 0 | - | 2/19/2015 0:47 | - | 2015-FEB-19 00:47 | 2015-FEB-19 00:55 | a | a | 30 minutes ago | - | 0 Hrs 37 Mins | - | ACME | - | - | No | - | - | - | - | - | - | - | - | - | - | - | Quote for Standard Revenue Order | Ordering Document |
<colgroup><col span="40"><col><col span="2"><col><col span="4"><col><col span="18"></colgroup><tbody>
</tbody>
Second Sheet should be
| Request | Quote | Opportunity ID | Customer Type | Customer Sub Type | LOB | Phase | Status | Customer | Organization | Country | Region | Sub Region | Queue | Sub Queue | Net Fees (USD) | Currency | Requested By | Assigned To | Responsible | Alternate Contacts | Sales Channel | Sales Rep | Reseller Customer | CSI# | Shipment Method | Payment Terms | Contract Number | Web Quote ID | Product Changes | Work Type | Managed Deal | Request Priority | Required Since | Required | Product Type | Business Unit | Open Changes | Related Quotes | Last Reopen Date | Draft Flag | Creation Date | Last Updated Date | Created By | Last Updated By | Updated SinceDescending | Revision Count | Request Age | Sub Status | Vertical Type | Sales Regional Manager | Ezo Number | Self Service | Agreement Type | Net Fee License | Net Fee Hardware | Net Fee Support | IAAS Flag | ePACT Quote Number | IPM Status | AR Contingency | Sub Lob Type | Managed Deal Flag | Conditional Approver | Request Sub Type | Request Type | |
| View | 123 | 5456 | 8542 | 654 | DVAR | H | q | N | abcd | abt | IN | INDIA | INDIA | N | Not Assigned | 265,864 | RS | adc | - | - | - | Field Sales | a | sfd | - | Standard | - | - | - | - | - | Standard | - | - | - | - | 0 | - | 2/19/2015 0:47 | - | 2015-FEB-19 00:47 | 2015-FEB-19 00:55 | a | a | 30 minutes ago | - | 0 Hrs 37 Mins | - | ACME | - | - | No | - | - | - | - | - | - | - | - | - | - | - | Quote for Standard Revenue Order | Ordering Document | |
| View | 123 | 5456 | 8542 | 654 | DVAR | H | q | N | abcd | abt | IN | INDIA | INDIA | N | Not Assigned | 265,864 | RS | adc | - | - | - | Field Sales | a | sfd | - | Standard | - | - | - | - | - | Standard | - | - | - | - | 0 | - | 2/19/2015 0:47 | - | 2015-FEB-19 00:47 | 2015-FEB-19 00:55 | a | a | 30 minutes ago | - | 0 Hrs 37 Mins | - | ACME | - | - | No | - | - | - | - | - | - | - | - | - | - | - | Quote for Standard Revenue Order | Ordering Document | |
| View | 123 | 5456 | 8542 | 654 | DVAR | H | q | N | abcd | abt | IN | INDIA | INDIA | N | Not Assigned | 265,864 | RS | adc | - | - | - | Field Sales | a | sfd | - | Standard | - | - | - | - | - | Standard | - | - | - | - | 0 | - | 2/19/2015 0:47 | - | 2015-FEB-19 00:47 | 2015-FEB-19 00:55 | a | a | 30 minutes ago | - | 0 Hrs 37 Mins | - | ACME | - | - | No | - | - | - | - | - | - | - | - | - | - | - | Quote for Standard Revenue Order | Ordering Document |
<colgroup><col span="40"><col><col span="2"><col><col span="4"><col><col span="19"></colgroup><tbody>
</tbody>
