Fill next available row if condition is met

My problem:

I want to say if condition "X" is met then fill the next row with information "Y".

In more detail, I want to look up customer type in one sheet. If customer type is "business", then I want to take their business contact details and fill the next available row on another sheet that follows the individual customer (i.e. if type=business then the business owners). If they are not type "business" then I only want to copy across the individual customer (non-business owner) contact details.

I'm happy to use multiple sheets to do this but I would rather not use a macro.

Is this possible?

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.