If cell =X then copy entire row to new workbook

[troosers]

Hi, Newbie here so please bear with me.

I would like to know how to copy paste from one sheet to another within the same file using the IF function or code.

I have thousands of entries of staff details and would like a formula/code to copy rows into new sheets for each service line.

I have attached a sample workbook on tab 1 and how I would like the data to be appear in tabs 2-4. The formula/code should check column A in tab 1 for service line e.g. roads, finance and then copy corresponding rows to individual sheets as detailed in example, so I would end up with extracts for each service.

Hope this makes sense

[jewelsharma]

Try the following code:

Please Login or Register  to view this content.

HTH!

[troosers]

Hi jewelsharma,

Thanks for your response. It works a treat and does exactly what I was looking for.

Apologies for the lateness of my reply, been on holiday and only just back to test.

Thank you again

[jewelsharma]

Cheers mate. Kindly mark this thread as "Solved".