Filtering out data into another worksheet

[Declamatory]

Morning,

I have a workbook with multiple sheets. Sheet one is a list of instructions downloaded from an website. The instructions are from clients. each row represents an instruction and the orders are not all together for each client so row 2 could be an order from client A row two could be from Client F and row 3 could be from client A again.

Each client has their own tab in the workbook.

How can I best separate out the instructions for each client into their relevant tab in the workbook.

I want to have a sort of VLOOKUP that that lists the trades (or relevant cells from the instruction sheet) but ignore rows that are not for that client without having blank rows.

Apologies if this doesn't make much sense.

 

[My Aswer Is This]

Where on the row is the client name?

So for example if "Alpha" is in Range("A1") that row is copied to sheet named Alpha

But you did not say where on the row we find the clients name.

Are you willing to use Vba?
I do not know how to do this with just a formula.

 

[Declamatory]

Yes vba is fine.

The source data is not easily readable so I want to almost translate it into order input sheets so the orders can be manually input into our system.

Order date is in column A
Order ID is in column C
Order type (Buy or sell) is in Column E
Client account number is in column F
Product name is in column J
No. of ordered units is in column K
Order value is in column M

(Client can either order a number of units or buy an amounts worth of product e.g. $100 worth.

Thanks for your time.

 

[My Aswer Is This]

I thought you said all information is now on one sheet and wanted to copy each row to the proper sheet.

I asked:

So for example if "Alpha" is in Range("A1") that row is copied to sheet named Alpha​

But you did not answer that question.

How do I know what sheet to copy the row to???

Why do I need to know anything more?

 

[My Aswer Is This]

You said:

Each client has their own tab in the workbook.

​

How can I best separate out the instructions for each client into their relevant tab in the workbook.​

​

I cannot answer that question if I do not know where to find the relevant tabs name.