ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help Needed ! (https://www.excelbanter.com/excel-programming/448220-help-needed.html)

Vixen_Twenty22

Help Needed !
 
1 Attachment(s)
I need a guide/ assistance to help me make a template that will do the auto sort of and distribute this into assigned worksheets.

The main worksheet which is under the name "raw data tab", upon pasting the data the sort will be according to Region (column C) and the data belongs to " Western Europe" and the rest will follow.

** WE ( Western Europe) data will automatically feed into worksheet WE,
** AME (Americas) and LATAM ( Latin America) data feed into AME-LATAM worksheet
** AP and EMA feed into AP-EMA worksheet.

i attached the sample file ...

Note: the raw data is downloaded daily ... and the template that will produce will help me analyse the data.

Gizzmo

1 Attachment(s)
Quote:

Originally Posted by Vixen_Twenty22 (Post 1609520)
I need a guide/ assistance to help me make a template that will do the auto sort of and distribute this into assigned worksheets.

The main worksheet which is under the name "raw data tab", upon pasting the data the sort will be according to Region (column C) and the data belongs to " Western Europe" and the rest will follow.

** WE ( Western Europe) data will automatically feed into worksheet WE,
** AME (Americas) and LATAM ( Latin America) data feed into AME-LATAM worksheet
** AP and EMA feed into AP-EMA worksheet.

i attached the sample file ...

Note: the raw data is downloaded daily ... and the template that will produce will help me analyse the data.

Hi Vixen,

Have a look at the attahce dfile its fast and nasty but hopefully it does what you want.

I have deleted the data on the output sheets go to Sheet 3 click the button and it should update the out put sheets.

Hope this helps


All times are GMT +1. The time now is 03:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com