pulling data from tables based on criteria

Dannytt93

New Member
Joined
Feb 13, 2019
Messages
9
Hello,

I have a workbook which contains a several different tabs all with a different persons stats. i was entering this manually but now i have managed to do an sql dump from the server with all the data i need.

i have created a tab called data dump where im going to copy and paste this from the server and then what i want to do is to create a number of formulas so that it will deposit that data in the correct tab based on the information that is in the table. The data dump table is below and Cell with "Owner" would be B1


OwnerTicket noCategoryLast ActivityAge Category
Name 112345WORK27/03/2019Less than 30 days
Name 2246810Home22/02/2019More than 30 days but less than 90
Name 336912Pub25/12/2018More than 90 days old

<tbody>
</tbody>


The table i want to send the data to based on that criteria is :

NameTickets less than 30 days old Tickets more than 30 but less than 90Tickets more than 90

Ticket no | Category | Last Actioned | Number of days oldTicket no | Category | Last Actioned | Number of days oldTicket no | Category | Last Actioned | Number of days old

<tbody>
</tbody>
the lines between ticket no & category etc indicate a new cell - it wont let me put it on the way i have it.

So is there anyway to make it deposit the data for Dan in the tab that says Dan but then split it into 3 categories "less than 30, more than 30 but less than 90, more than 90" and then deposit the data in the correct cell?

So the plan is when i simply copy and paste the data dump from SQL to excel, it will automatically update all of the tables in the spreadsheet?

Any help would be greatly appreciated

Many thanks

Dan
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,129,311
Messages
5,635,478
Members
416,859
Latest member
GowthamiSita

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
Top