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