Moving specific data to next sheet.

[Bigil]

i would want to transfer a specific data to sheet 2.

1. select "General requests" from column B and move it to sheet 2.
2. Come back to sheet one and delete All the data belonging to country "Netherlands" ( column G)

Please note: only on sheet 1 the country Netherlands should be deleted. Thanks

Please Login or Register  to view this content.

[maras_mak]

Check my corrections.

Please Login or Register  to view this content.

[Mumps1]

Another approach:

Please Login or Register  to view this content.

[Bigil]

Hi, I want the entire general requests to move to sheet2 but i see a few general requests ends up in the sheet1. also netherlands should get completely deleted from sheet 1. Please assist.

[vcoolio]

Hello Bigil,

1. select "General requests" from column B and move it to sheet 2.
2. Come back to sheet one and delete All the data belonging to country "Netherlands" ( column G)

Please note: only on sheet 1 the country Netherlands should be deleted. Thanks

Both the codes supplied to you above do exactly as you ask.

If you are saying that you do not want to see any rows of data in Sheet1 with the criteria "General Requests" in Column B then you are contradicting your own request as data for other countries will also be deleted not just the Netherlands.

Please fully explain what it is that you wish to achieve.

Cheerio,
vcoolio.