Auto copy pest data from sheet 1 to sheet 2

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 entire row if any line of “A” is start with the word “View” (if there is a data) and past it in sheet2, 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 all the rows which is beginning with the word “View “ in “A1” in the 2nd Sheet and 2nd time whenever there is any changes in 1st sheet it should captured automatically in the 2nd sheet along with the previous data.

Regards
Arindam

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi
I have attached the excel by editing my question .plz check sheet1 and sheet 2

Sheet 1 -how I will get the data from the website
Sheet 2-how I want it to be saved.

only catch is
it should be auto update whenever there is some data in sheet 1 which is starting with the word "View" the entire row should be update in the 2nd sheet
if auto update is not possible at all then one click button is on in sheet1.

Regards
Arindam

According to your sample the only thing in column 1 is either Blank or View.

This code will find the non-blank cells, and copy the rows to the next sheet.

You need to `Cancel=true ` when using the DoubleClick event or you will end up in the edit box.

Please Login or Register  to view this content.

Here you go, still a BeforeDoubleClick event

Please Login or Register  to view this content.

Originally Posted by andrugrasu

but for any value , to be replaced with "View" ?

To quote the unknown,,"Um..What?"