Copy selected row data to another sheet

[raju.145in]

Hello All,

I am trying to copy selected row data to another sheet.
Example : In sheet1 column "M", i have list with three values (i.e., BOOKED,NOT INTERESTED,CONCEDERING).If i select a value from list, the entire row has copy to next sheet means sheet2.
Please let me know some suggestions to achieve this.


Sample Data.xlsx


Thanks,
Raj

[Charles]

Raj,

Welcome to the forum.
At what time do you want the data to be copied to sheet2?
You have several drop downs and from the info you provided I would assume you want to copy the row of the selected Item to sheet2. if this is correct and the selection will be the last entry to select from then you can use a "Worksheet_Change" event to copy the data to sheet2.

[raju.145in]

Hi Charles !!

Thanks for response. I got the solution after looong googling
I have written code in "Worksheet_Change" method only .


Thanks,
Raj

[Charles]

Raj,

If your problem is solved please show this thread as "Solved"

[raju.145in]

Issue Solved