Auto copy pest data from sheet 1 to sheet 2

A

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

[TABLE="width: 4419"]
<colgroup><col span="40"><col><col span="2"><col><col span="4"><col><col span="18"></colgroup><tbody>[TR]
[TD][/TD]
[TD]Request[/TD]
[TD]Quote[/TD]
[TD]Opportunity ID[/TD]
[TD]Customer Type[/TD]
[TD]Customer Sub Type[/TD]
[TD]LOB[/TD]
[TD]Phase[/TD]
[TD]Status[/TD]
[TD]Customer[/TD]
[TD]Organization[/TD]
[TD]Country[/TD]
[TD]Region[/TD]
[TD]Sub Region[/TD]
[TD]Queue[/TD]
[TD]Sub Queue[/TD]
[TD]Net Fees (USD)[/TD]
[TD]Currency[/TD]
[TD]Requested By[/TD]
[TD]Assigned To[/TD]
[TD]Responsible[/TD]
[TD]Alternate Contacts[/TD]
[TD]Sales Channel[/TD]
[TD]Sales Rep[/TD]
[TD]Reseller Customer[/TD]
[TD]CSI#[/TD]
[TD]Shipment Method[/TD]
[TD]Payment Terms[/TD]
[TD]Contract Number[/TD]
[TD]Web Quote ID[/TD]
[TD]Product Changes[/TD]
[TD]Work Type[/TD]
[TD]Managed Deal[/TD]
[TD]Request Priority[/TD]
[TD]Required Since[/TD]
[TD]Required[/TD]
[TD]Product Type[/TD]
[TD]Business Unit[/TD]
[TD]Open Changes[/TD]
[TD]Related Quotes[/TD]
[TD]Last Reopen Date[/TD]
[TD]Draft Flag[/TD]
[TD]Creation Date[/TD]
[TD]Last Updated Date[/TD]
[TD]Created By[/TD]
[TD]Last Updated By[/TD]
[TD]Updated SinceDescending[/TD]
[TD]Revision Count[/TD]
[TD]Request Age[/TD]
[TD]Sub Status[/TD]
[TD]Vertical Type[/TD]
[TD]Sales Regional Manager[/TD]
[TD]Ezo Number[/TD]
[TD]Self Service[/TD]
[TD]Agreement Type[/TD]
[TD]Net Fee License[/TD]
[TD]Net Fee Hardware[/TD]
[TD]Net Fee Support[/TD]
[TD]IAAS Flag[/TD]
[TD]ePACT Quote Number[/TD]
[TD]IPM Status[/TD]
[TD]AR Contingency[/TD]
[TD]Sub Lob Type[/TD]
[TD]Managed Deal Flag[/TD]
[TD]Conditional Approver[/TD]
[TD]Request Sub Type[/TD]
[TD]Request Type[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]/iPD Deal/POR #[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]View[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]5456[/TD]
[TD="align: right"]8542[/TD]
[TD="align: right"]654[/TD]
[TD]DVAR[/TD]
[TD]H[/TD]
[TD]q[/TD]
[TD]N[/TD]
[TD]abcd[/TD]
[TD]abt[/TD]
[TD]IN[/TD]
[TD]INDIA[/TD]
[TD]INDIA[/TD]
[TD]N[/TD]
[TD]Not Assigned[/TD]
[TD="align: right"]265,864[/TD]
[TD]RS[/TD]
[TD]adc[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Field Sales[/TD]
[TD]a[/TD]
[TD]sfd[/TD]
[TD]-[/TD]
[TD]Standard[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD][/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Standard[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD="align: right"]0[/TD]
[TD]-[/TD]
[TD="align: right"]2/19/2015 0:47[/TD]
[TD]-[/TD]
[TD]2015-FEB-19 00:47[/TD]
[TD]2015-FEB-19 00:55[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]30 minutes ago[/TD]
[TD]-[/TD]
[TD]0 Hrs 37 Mins[/TD]
[TD]-[/TD]
[TD]ACME[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]No[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Quote for Standard Revenue Order[/TD]
[TD]Ordering Document[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Request[/TD]
[TD]Quote[/TD]
[TD]Opportunity ID[/TD]
[TD]Customer Type[/TD]
[TD]Customer Sub Type[/TD]
[TD]LOB[/TD]
[TD]Phase[/TD]
[TD]Status[/TD]
[TD]Customer[/TD]
[TD]Organization[/TD]
[TD]Country[/TD]
[TD]Region[/TD]
[TD]Sub Region[/TD]
[TD]Queue[/TD]
[TD]Sub Queue[/TD]
[TD]Net Fees (USD)[/TD]
[TD]Currency[/TD]
[TD]Requested By[/TD]
[TD]Assigned To[/TD]
[TD]Responsible[/TD]
[TD]Alternate Contacts[/TD]
[TD]Sales Channel[/TD]
[TD]Sales Rep[/TD]
[TD]Reseller Customer[/TD]
[TD]CSI#[/TD]
[TD]Shipment Method[/TD]
[TD]Payment Terms[/TD]
[TD]Contract Number[/TD]
[TD]Web Quote ID[/TD]
[TD]Product Changes[/TD]
[TD]Work Type[/TD]
[TD]Managed Deal[/TD]
[TD]Request Priority[/TD]
[TD]Required Since[/TD]
[TD]Required[/TD]
[TD]Product Type[/TD]
[TD]Business Unit[/TD]
[TD]Open Changes[/TD]
[TD]Related Quotes[/TD]
[TD]Last Reopen Date[/TD]
[TD]Draft Flag[/TD]
[TD]Creation Date[/TD]
[TD]Last Updated Date[/TD]
[TD]Created By[/TD]
[TD]Last Updated By[/TD]
[TD]Updated SinceDescending[/TD]
[TD]Revision Count[/TD]
[TD]Request Age[/TD]
[TD]Sub Status[/TD]
[TD]Vertical Type[/TD]
[TD]Sales Regional Manager[/TD]
[TD]Ezo Number[/TD]
[TD]Self Service[/TD]
[TD]Agreement Type[/TD]
[TD]Net Fee License[/TD]
[TD]Net Fee Hardware[/TD]
[TD]Net Fee Support[/TD]
[TD]IAAS Flag[/TD]
[TD]ePACT Quote Number[/TD]
[TD]IPM Status[/TD]
[TD]AR Contingency[/TD]
[TD]Sub Lob Type[/TD]
[TD]Managed Deal Flag[/TD]
[TD]Conditional Approver[/TD]
[TD]Request Sub Type[/TD]
[TD]Request Type[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]/iPD Deal/POR #[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]View[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]5456[/TD]
[TD="align: right"]8542[/TD]
[TD="align: right"]654[/TD]
[TD]DVAR[/TD]
[TD]H[/TD]
[TD]q[/TD]
[TD]N[/TD]
[TD]abcd[/TD]
[TD]abt[/TD]
[TD]IN[/TD]
[TD]INDIA[/TD]
[TD]INDIA[/TD]
[TD]N[/TD]
[TD]Not Assigned[/TD]
[TD="align: right"]265,864[/TD]
[TD]RS[/TD]
[TD]adc[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Field Sales[/TD]
[TD]a[/TD]
[TD]sfd[/TD]
[TD]-[/TD]
[TD]Standard[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD][/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Standard[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD="align: right"]0[/TD]
[TD]-[/TD]
[TD="align: right"]2/19/2015 0:47[/TD]
[TD]-[/TD]
[TD]2015-FEB-19 00:47[/TD]
[TD]2015-FEB-19 00:55[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]30 minutes ago[/TD]
[TD]-[/TD]
[TD]0 Hrs 37 Mins[/TD]
[TD]-[/TD]
[TD]ACME[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]No[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Quote for Standard Revenue Order[/TD]
[TD]Ordering Document[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Request[/TD]
[TD]Quote[/TD]
[TD]Opportunity ID[/TD]
[TD]Customer Type[/TD]
[TD]Customer Sub Type[/TD]
[TD]LOB[/TD]
[TD]Phase[/TD]
[TD]Status[/TD]
[TD]Customer[/TD]
[TD]Organization[/TD]
[TD]Country[/TD]
[TD]Region[/TD]
[TD]Sub Region[/TD]
[TD]Queue[/TD]
[TD]Sub Queue[/TD]
[TD]Net Fees (USD)[/TD]
[TD]Currency[/TD]
[TD]Requested By[/TD]
[TD]Assigned To[/TD]
[TD]Responsible[/TD]
[TD]Alternate Contacts[/TD]
[TD]Sales Channel[/TD]
[TD]Sales Rep[/TD]
[TD]Reseller Customer[/TD]
[TD]CSI#[/TD]
[TD]Shipment Method[/TD]
[TD]Payment Terms[/TD]
[TD]Contract Number[/TD]
[TD]Web Quote ID[/TD]
[TD]Product Changes[/TD]
[TD]Work Type[/TD]
[TD]Managed Deal[/TD]
[TD]Request Priority[/TD]
[TD]Required Since[/TD]
[TD]Required[/TD]
[TD]Product Type[/TD]
[TD]Business Unit[/TD]
[TD]Open Changes[/TD]
[TD]Related Quotes[/TD]
[TD]Last Reopen Date[/TD]
[TD]Draft Flag[/TD]
[TD]Creation Date[/TD]
[TD]Last Updated Date[/TD]
[TD]Created By[/TD]
[TD]Last Updated By[/TD]
[TD]Updated SinceDescending[/TD]
[TD]Revision Count[/TD]
[TD]Request Age[/TD]
[TD]Sub Status[/TD]
[TD]Vertical Type[/TD]
[TD]Sales Regional Manager[/TD]
[TD]Ezo Number[/TD]
[TD]Self Service[/TD]
[TD]Agreement Type[/TD]
[TD]Net Fee License[/TD]
[TD]Net Fee Hardware[/TD]
[TD]Net Fee Support[/TD]
[TD]IAAS Flag[/TD]
[TD]ePACT Quote Number[/TD]
[TD]IPM Status[/TD]
[TD]AR Contingency[/TD]
[TD]Sub Lob Type[/TD]
[TD]Managed Deal Flag[/TD]
[TD]Conditional Approver[/TD]
[TD]Request Sub Type[/TD]
[TD]Request Type[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]/iPD Deal/POR #[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]View[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]5456[/TD]
[TD="align: right"]8542[/TD]
[TD="align: right"]654[/TD]
[TD]DVAR[/TD]
[TD]H[/TD]
[TD]q[/TD]
[TD]N[/TD]
[TD]abcd[/TD]
[TD]abt[/TD]
[TD]IN[/TD]
[TD]INDIA[/TD]
[TD]INDIA[/TD]
[TD]N[/TD]
[TD]Not Assigned[/TD]
[TD="align: right"]265,864[/TD]
[TD]RS[/TD]
[TD]adc[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Field Sales[/TD]
[TD]a[/TD]
[TD]sfd[/TD]
[TD]-[/TD]
[TD]Standard[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD][/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Standard[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD="align: right"]0[/TD]
[TD]-[/TD]
[TD="align: right"]2/19/2015 0:47[/TD]
[TD]-[/TD]
[TD]2015-FEB-19 00:47[/TD]
[TD]2015-FEB-19 00:55[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]30 minutes ago[/TD]
[TD]-[/TD]
[TD]0 Hrs 37 Mins[/TD]
[TD]-[/TD]
[TD]ACME[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]No[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Quote for Standard Revenue Order[/TD]
[TD]Ordering Document[/TD]
[/TR]
</tbody>[/TABLE]

Second Sheet should be

[TABLE="width: 4483"]
<colgroup><col span="40"><col><col span="2"><col><col span="4"><col><col span="19"></colgroup><tbody>[TR]
[TD][/TD]
[TD]Request[/TD]
[TD]Quote[/TD]
[TD]Opportunity ID[/TD]
[TD]Customer Type[/TD]
[TD]Customer Sub Type[/TD]
[TD]LOB[/TD]
[TD]Phase[/TD]
[TD]Status[/TD]
[TD]Customer[/TD]
[TD]Organization[/TD]
[TD]Country[/TD]
[TD]Region[/TD]
[TD]Sub Region[/TD]
[TD]Queue[/TD]
[TD]Sub Queue[/TD]
[TD]Net Fees (USD)[/TD]
[TD]Currency[/TD]
[TD]Requested By[/TD]
[TD]Assigned To[/TD]
[TD]Responsible[/TD]
[TD]Alternate Contacts[/TD]
[TD]Sales Channel[/TD]
[TD]Sales Rep[/TD]
[TD]Reseller Customer[/TD]
[TD]CSI#[/TD]
[TD]Shipment Method[/TD]
[TD]Payment Terms[/TD]
[TD]Contract Number[/TD]
[TD]Web Quote ID[/TD]
[TD]Product Changes[/TD]
[TD]Work Type[/TD]
[TD]Managed Deal[/TD]
[TD]Request Priority[/TD]
[TD]Required Since[/TD]
[TD]Required[/TD]
[TD]Product Type[/TD]
[TD]Business Unit[/TD]
[TD]Open Changes[/TD]
[TD]Related Quotes[/TD]
[TD]Last Reopen Date[/TD]
[TD]Draft Flag[/TD]
[TD]Creation Date[/TD]
[TD]Last Updated Date[/TD]
[TD]Created By[/TD]
[TD]Last Updated By[/TD]
[TD]Updated SinceDescending[/TD]
[TD]Revision Count[/TD]
[TD]Request Age[/TD]
[TD]Sub Status[/TD]
[TD]Vertical Type[/TD]
[TD]Sales Regional Manager[/TD]
[TD]Ezo Number[/TD]
[TD]Self Service[/TD]
[TD]Agreement Type[/TD]
[TD]Net Fee License[/TD]
[TD]Net Fee Hardware[/TD]
[TD]Net Fee Support[/TD]
[TD]IAAS Flag[/TD]
[TD]ePACT Quote Number[/TD]
[TD]IPM Status[/TD]
[TD]AR Contingency[/TD]
[TD]Sub Lob Type[/TD]
[TD]Managed Deal Flag[/TD]
[TD]Conditional Approver[/TD]
[TD]Request Sub Type[/TD]
[TD="colspan: 2"]Request Type[/TD]
[/TR]
[TR]
[TD]View[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]5456[/TD]
[TD="align: right"]8542[/TD]
[TD="align: right"]654[/TD]
[TD]DVAR[/TD]
[TD]H[/TD]
[TD]q[/TD]
[TD]N[/TD]
[TD]abcd[/TD]
[TD]abt[/TD]
[TD]IN[/TD]
[TD]INDIA[/TD]
[TD]INDIA[/TD]
[TD]N[/TD]
[TD]Not Assigned[/TD]
[TD="align: right"]265,864[/TD]
[TD]RS[/TD]
[TD]adc[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Field Sales[/TD]
[TD]a[/TD]
[TD]sfd[/TD]
[TD]-[/TD]
[TD]Standard[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD][/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Standard[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD="align: right"]0[/TD]
[TD]-[/TD]
[TD="align: right"]2/19/2015 0:47[/TD]
[TD]-[/TD]
[TD]2015-FEB-19 00:47[/TD]
[TD]2015-FEB-19 00:55[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]30 minutes ago[/TD]
[TD]-[/TD]
[TD]0 Hrs 37 Mins[/TD]
[TD]-[/TD]
[TD]ACME[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]No[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Quote for Standard Revenue Order[/TD]
[TD="colspan: 2"]Ordering Document[/TD]
[/TR]
[TR]
[TD]View[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]5456[/TD]
[TD="align: right"]8542[/TD]
[TD="align: right"]654[/TD]
[TD]DVAR[/TD]
[TD]H[/TD]
[TD]q[/TD]
[TD]N[/TD]
[TD]abcd[/TD]
[TD]abt[/TD]
[TD]IN[/TD]
[TD]INDIA[/TD]
[TD]INDIA[/TD]
[TD]N[/TD]
[TD]Not Assigned[/TD]
[TD="align: right"]265,864[/TD]
[TD]RS[/TD]
[TD]adc[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Field Sales[/TD]
[TD]a[/TD]
[TD]sfd[/TD]
[TD]-[/TD]
[TD]Standard[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD][/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Standard[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD="align: right"]0[/TD]
[TD]-[/TD]
[TD="align: right"]2/19/2015 0:47[/TD]
[TD]-[/TD]
[TD]2015-FEB-19 00:47[/TD]
[TD]2015-FEB-19 00:55[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]30 minutes ago[/TD]
[TD]-[/TD]
[TD]0 Hrs 37 Mins[/TD]
[TD]-[/TD]
[TD]ACME[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]No[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Quote for Standard Revenue Order[/TD]
[TD="colspan: 2"]Ordering Document[/TD]
[/TR]
[TR]
[TD]View[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]5456[/TD]
[TD="align: right"]8542[/TD]
[TD="align: right"]654[/TD]
[TD]DVAR[/TD]
[TD]H[/TD]
[TD]q[/TD]
[TD]N[/TD]
[TD]abcd[/TD]
[TD]abt[/TD]
[TD]IN[/TD]
[TD]INDIA[/TD]
[TD]INDIA[/TD]
[TD]N[/TD]
[TD]Not Assigned[/TD]
[TD="align: right"]265,864[/TD]
[TD]RS[/TD]
[TD]adc[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Field Sales[/TD]
[TD]a[/TD]
[TD]sfd[/TD]
[TD]-[/TD]
[TD]Standard[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD][/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Standard[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD="align: right"]0[/TD]
[TD]-[/TD]
[TD="align: right"]2/19/2015 0:47[/TD]
[TD]-[/TD]
[TD]2015-FEB-19 00:47[/TD]
[TD]2015-FEB-19 00:55[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]30 minutes ago[/TD]
[TD]-[/TD]
[TD]0 Hrs 37 Mins[/TD]
[TD]-[/TD]
[TD]ACME[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]No[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Quote for Standard Revenue Order[/TD]
[TD="colspan: 2"]Ordering Document[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
You must log in or register to reply here.

Similar threads

D
  • Question Question
Find the matching details from 2 workbooks compile it in a sheet and then summarize it and put it in different sheet.
Replies
0
Views
380
deba2020
D
J
  • Question Question
VBA to extract row data to sheet and update data set
Replies
0
Views
933
justatroy
J
A
  • Question Question
Type mismatch (Error 13) in Visual Basic while retrieving data from spread sheet 2010
Replies
2
Views
2K
anuradha
A
J
  • Question Question
VBA Macro to compare two dates in two sheets, then transfer relevant data to relevant column
Replies
5
Views
3K
JLGWhiz
JLGWhiz
E
  • Question Question
Copy specific data from an excel template and paste in new workbook
Replies
3
Views
664
excel_1317
E

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top