PDA

View Full Version : sort and paste macro



maninjapan
08-17-2011, 04:00 AM
I recieve a list of data daily that I need to sort and paste to a specific format.

Anyone seen a similar thread that they can point me too with an example of what needs to be done?

I have attached a simple example of what I am aiming to achieve
This example sorts units of products sold by staff by product, staff and color


1. Data is pasted into "Daily Data" sheet
2. Staff info in "Daily Data" sheet is listed as code (staff code) only, referenced in Column A in "Results"
2. Data needs to be sorted and pasted to populate "Results" page
3. No data in Daily Data = No Product sold
4. This example includes 2 products, but my actual excel will require 15-20

Any push in the right direction would be much appreciated.

Thanks in advance!!

Bob Phillips
08-17-2011, 05:29 AM
Apart from not knowing how it aligns to the people, looks like a perfect job for a pivot table to me.

maninjapan
08-18-2011, 01:30 AM
Sorry Xld, what do you mean, "How it aligns to the people", each person is represented by their code in the Daily Data sheet ( only actual sales data is recieved, no sales means no data for a staff)

Im not sure if a pivot table will help as the data wont contain data for every person everyday, but I still need to post their daily results in the results sheet (I have just started looking at pivot tables so I may very well be able to do this )

CatDaddy
08-18-2011, 04:29 PM
this is what yo uwant your pivottable to look like maybe

CatDaddy
08-18-2011, 04:30 PM
my bad, instead of count of product, you probably want count of No (in the sum collumn)