New guy here (automatic moving of rows to another sheet)

[adammint7]

Hi guys I am Adam and I am new here, I have a programing background (c# but not excel).

I have 3 sheets in excel, I would like content from sheet 1 to be moved into sheet 2 if it has the work CCTV, Mango or peach. Could you kind guys give me a little help on how I would go about this?

thanks in advance

Adam

[stanleydgromjr]

adammint7,

Welcome to the Excel Forum.

To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed/changed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.

[JOHN H. DAVIS]

An example would be If those words would appear in Column A and you wanted the entire row moved to Sheet 2 then maybe something like this would work.

Please Login or Register  to view this content.

[adammint7]

Thanks you so much for your help

[JOHN H. DAVIS]

You're welcome. If you consider your problem solved then please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.