How to have records with ID transferred to sheet ID

A

AA Arens

I have a sheet with raw records from a telkom company that lists the
SIM card phone numbers, name of the user, SMS usage etc.

Like this:

Record# SIM# User SMSusage etc.
1 12345 Andrew 500 etc.
2 65432 Deborah 430 etc.
3 12355 Andrew 450 etc.

How to have these records transferred to the new sheets, per name?

So, on sheet Andrew:

Record# SIM# (User) SMSusage etc.
1 12345 (Andrew) 500 etc.
2 12355 (Andrew) 450 etc.

The amount of record# varies, also the amount of SIM# per user.

Bart
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top