Need help to auto extract rows of data based on customer number into individual tabs

Hi there,

I am new to the forum and would like to thank anyone in advance for reading and possibly to help solve my problem here!

Basically, I am new to working with massive excel tables of raw data.

Please, can anyone offer insight to the following issue?

1) Master list has thousands of rows of data
2) Each row of data is sorted by customer number
3) Need to extract the rows with same customer number into individual tabs in the same sheet.

As I have hundreds of customers, I am manually doing the following currently

1) Use the sort function in Master List, sort by customer
2) Copy and paste into new tab manually

The manual way of sort/copy/paste (repeat x100) is very tedious and time consuming, so I was wondering if any kind Excel experts here can help suggest a formula or easier way?

Thanks!

Hello Ford,

Thanks for the quick reply!

Here is a little more background on this.

Worksheet A = Raw Data from system. Contains Customer number, ISBN book number and Units Sold.
Worksheet B = Report format, which contains ISBN book number, Units Sold and also customer number!

Right now, my issue is the time consuming manual sort/cut/paste into different tabs

They are separated into diff tabs because in Worksheet B (The Final Report)

Customers Number is listed as header row on top, while ISBN number is listed as header column on the left.

Correspondingly, I am using vlookup under each Customer Number, with ISBN as lookup value, and table array as specific columns from each customer tab.

This gives me the units sold, per customer, per ISBN book number.

I tried using table array by choosing the columns under the Main sheet in Worksheet A, but that gives me an error.

Hope this isn't too confusing!

Cathy