Macro for copying the data from one sheet and insert the same in next sheet

**Thinker8** · 11-01-2013, 06:47 PM

Hi All,

i have a workbook with two sheets named "sheet1" and "sheet2".If i insert anything in sheet 1, that should automatically populate in sheet 2.

I have a column name as "status" in sheet 1.

If i insert anything in sheet 1, that should automatically populate in sheet 2 is my primary target.But if i update the status column in sheet 1 that should highlight that particular row/cell in sheet 2 expect the status "Resolved". If the status in sheet 1 is updated as resolved, then the specific row in sheet 2 should be deleted.

Please help me..., Thanks in Advance..

**HaHoBe** · 11-02-2013, 02:25 AM

Hi, Thinker8,

sounds that you are looking to use the Worksheet_Change-event behind Sheet1 but you need to be more specific about

I have a column name as "status" in sheet 1.

You certainly can give the number of the Column.

Please Login or Register  to view this content.

Maybe you think about using the Sheet_Activate-event for Sheet2 to go through the code only when you will have a look at Sheet2 or tell us about the number of records we are talking about.

Ciao,
Holger

**Thinker8** · 11-02-2013, 02:22 PM

Hi Ciao,

Both the sheet has same count of columns.Status column number is 10.

First it should copy the data from sheet 1 to sheet 2.(I meant to say is if i insert a data).
After it was inserted in sheet 2 , if i made any change in the column status in sheet 1 it should highlight that row in sheet 2 but the status was updated as "Resolved" in status column that particular row in sheet 2 should be deleted.

I hope now you are clear with my question.. :P

**HaHoBe** · 11-02-2013, 05:51 PM

Hi, Thinker8,

did you ever try to plot out what requirements are needed for your request? You put in any information into any Column in a new row on Sheet1 the row gets copied over, you put more info in, you need to find the dataset and overwrite the contents, you put in Resolved in COlumn 10 in Sheet1 that row gets deleted on Sheet2 leaving no direct contact to Sheet1 but using Find on a unique ID which you haven´t listed as of yet.

I´m glad you didn´t point out for which reason this should be a Worksheet_Change-event type as I don´t know what the data on Sheet2 is needed for. So again: I´d recommend using the Worksheet_Activate of Sheet2, delete all information, copy over, use Autofilter, delete resolved, unapply Autofilter.

Ciao,
Holger