Same table on different sheets

Masimo85

New Member
Joined
Jun 5, 2020
Messages
17
Office Version
  1. 365
Platform
  1. Windows
Hi,

So im trying to make sort off a super simple Excel ark, to keep track of our outgoing offers to our customers.
And the table we have are working great, however - to make it easier to sort our different customers, and get a total overview of them.

We wanna seperate those customers into different Sheets - however we want the information to still be pulled from the main sheet.

So, to try and explain it further a little:

Sheet 1 - Will be the master, where we put in new project offers - and fill in different information in the column from A to M.
Each offer has their own row, going downwards.

Sheet 2 - Will have the same table headers, as sheet 1 - but want that table to pull out an seperate only a spesific customer on that sheet (Column D)

This will be going onto Sheet 3 - 4 - 5 etc.

I know sorting in the tables are super simple, however - also hoping to make some charts later, on the different sheets to further getting some quick information about each customer.

What we are alsi hoping is that each sheet will continue to update the information, when new project or information is being put into Sheet 1.

I figured I would using the VLOOKUP function, but I couldnt get around doing it to all cells and also that it will sort of based on a value on a column.

Hopefully someone in here, know the way or at least some articly/youtube etc that will help me accomplish this :)
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Is the data in sheet 1 in a table object or just a range?

If it is in just a range, could it be moved to a table object?

If it is inside a table object then you could either use a filter formula or pivot table to pull the seperate customer data simply. When the table grows then so will the formulae or pivot tables.
 
Upvote 0
Hi Georgiboy,

Well - it is atm a table.

I just a made quick example of what I was refering to - hopefully this explains it better.

This would be similar to the Main Sheet - With its own table

ExampleSales.xlsx
ABCDEFGHIJKLM
1DateOffer NameTypeCustomerSalesmanStatusOffer NumberOffer SumProductions TimeSupplierStatus2Feedback - 1Feedback - 2
201.05.2022Offer 1ElementsCustomer 1ErikOffer Send1234 500.000 05.10.2022LostTo Pricy
302.05.2022Offer 2ElementsCustomer 2CamillaOffer Send1235 500.001 06.10.2022Won
403.05.2022Offer 3ElementsCustomer 1FredOffer Send1236 500.002 07.10.2022LostEtc.
504.05.2022Offer 4ElementsCustomer 3SebastianOffer Send1237 500.003 08.10.2022LostEtc.
605.05.2022Offer 5ElementsCustomer 4MadsOffer Send1238 500.004 09.10.2022WonEtc.
706.05.2022Offer 6ElementsCustomer 2FlintOffer Send1239 500.005 10.10.2022WonEtc.
807.05.2022Offer 7ElementsCustomer 3StoneOffer Send1240 500.006 11.10.2022WonEtc.
908.05.2022Offer 8ElementsCustomer 1EmmaOffer Send1241 500.007 12.10.2022WonEtc.
Main Sheet


And then here Customer 1 - Sheet with a few information boxes on the right side.

ExampleSales.xlsx
ABCDEFGHIJKLMNOPQ
1DateOffer NameTypeCustomerSalesmanStatusOffer NumberOffer SumProductions TimeSupplierStatus2Feedback - 1Feedback - 2Customer Project Lost2
201.05.2022Offer 1ElementsCustomer 1ErikOffer Send1234 500.000 05.10.2022LostTo PricyCustomer Project Won1
303.05.2022Offer 3ElementsCustomer 1FredOffer Send1236 500.002 07.10.2022LostEtc.Sum of offers won 500.007
408.05.2022Offer 8ElementsCustomer 1EmmaOffer Send1241 500.007 12.10.2022WonEtc.
5
6
7
8
9
Customer 1
Cell Formulas
RangeFormula
Q3Q3=H4
 
Upvote 0
So here is the master sheet (sheet1) with the table:
GC 17.03.xlsm
ABCDEFGHIJKLM
1DateOffer NameTypeCustomerSalesmanStatusOffer NumberOffer SumProductions TimeSupplierStatus2Feedback - 1Feedback - 2
201/05/2022Offer 1ElementsCustomer 1ErikOffer Send123450005/10/2022LostTo Pricy
302/05/2022Offer 2ElementsCustomer 2CamillaOffer Send1235500.00106/10/2022Won
403/05/2022Offer 3ElementsCustomer 1FredOffer Send1236500.00207/10/2022LostEtc.
504/05/2022Offer 4ElementsCustomer 3SebastianOffer Send1237500.00308/10/2022LostEtc.
605/05/2022Offer 5ElementsCustomer 4MadsOffer Send1238500.00409/10/2022WonEtc.
706/05/2022Offer 6ElementsCustomer 2FlintOffer Send1239500.00510/10/2022WonEtc.
807/05/2022Offer 7ElementsCustomer 3StoneOffer Send1240500.00611/10/2022WonEtc.
908/05/2022Offer 8ElementsCustomer 1EmmaOffer Send1241500.00712/10/2022WonEtc.
1017/03/2023Offer 99Customer 1
1118/03/2023Offer 100Customer 4
Sheet1


And below is one of the customer sheets using the FILTER formula:
GC 17.03.xlsm
ABCDEFGHIJKLM
1DateOffer NameTypeCustomerSalesmanStatusOffer NumberOffer SumProductions TimeSupplierStatus2Feedback - 1Feedback - 2
201/05/2022Offer 1ElementsCustomer 1ErikOffer Send123450005/10/20220LostTo Pricy0
303/05/2022Offer 3ElementsCustomer 1FredOffer Send1236500.00207/10/20220LostEtc.0
408/05/2022Offer 8ElementsCustomer 1EmmaOffer Send1241500.00712/10/20220WonEtc.0
517/03/2023Offer 990Customer 1000000/01/19000000
Customer 1
Cell Formulas
RangeFormula
A2:M5A2=FILTER(Table1,Table1[Customer]="Customer 1")
Dynamic array formulas.
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,287
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top