Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VBA to calculate some data
Hi everyone, I hope someone can think of a whizzy way to do th
following. I could use a pivot table but I would like it to be faster and mor whizzy than that, so would like to use VBA if possible. I have a data sheet, called "data". Inside this sheet are a number o formulae which calculate some derived fields. I would like to develop a VBA code that does the following: In sheet "analysis", and based on a value placed in cell A5 "customer and "product" take the the average time for an order to be processe after sold. And also gives the total number of the selected category o product sold. Where in sheet "data", the time taken per order is based on column D column C. And column V contains the "type", column R contains the "category" an column S the "product". Is there a way to write a code that takes the data in sheet "data" an based on the values in "analysis" does the following: Based on the customer selected, give a listing of all the products sol to them ? And also give the average time noted above. Hope this isn't too clumsy, and that someone brighter than me can com up with a colution. Thank you in advance. Scott -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VBA to calculate some data
This sounds very do-able. However, simply from the
description, it's hard to see exactly what you want to do. If you could send me a file, I'd be happy to take a crack at it. Please post your email, and we can go from there. (You won't be able to email me first due to my firewall.) Regards, Brett -----Original Message----- Hi everyone, I hope someone can think of a whizzy way to do the following. I could use a pivot table but I would like it to be faster and more whizzy than that, so would like to use VBA if possible. I have a data sheet, called "data". Inside this sheet are a number of formulae which calculate some derived fields. I would like to develop a VBA code that does the following: In sheet "analysis", and based on a value placed in cell A5 "customer" and "product" take the the average time for an order to be processed after sold. And also gives the total number of the selected category or product sold. Where in sheet "data", the time taken per order is based on column D - column C. And column V contains the "type", column R contains the "category" and column S the "product". Is there a way to write a code that takes the data in sheet "data" and based on the values in "analysis" does the following: Based on the customer selected, give a listing of all the products sold to them ? And also give the average time noted above. Hope this isn't too clumsy, and that someone brighter than me can come up with a colution. Thank you in advance. Scott. --- Message posted from http://www.ExcelForum.com/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VBA to calculate some data
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate data from different sheets | Excel Discussion (Misc queries) | |||
HELP! Find Data in columns next to known data then Calculate | Excel Discussion (Misc queries) | |||
How do I calculate formulas for yes/no data | Excel Worksheet Functions | |||
Calculate data on 2 different worksheets | Excel Discussion (Misc queries) | |||
Import data, calculate, export data | Excel Programming |