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
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
