Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can this not be done?
Is the reason no one has come back to me because it cant be done?!
Thanks Scott. Hope someone can help with the following: I have a worksheet ("data") with the following details: range: A2:AO20000 column S is the country of customer column C date order placed column D data order sent column R customer column V product bought What I would like my VBA to do is take this information, and then i another sheet called "analysis" use the information typed into cell A1 customer area and A2: customer name And calculate for each product bought by the customer, the average tim between column C and column D. Note where nothing is displayed in cell A1 in "analysis" then th result of the VBA would give all customers. Help please ! Thank you, Scott -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
can this not be done?
Why not add a column that calculates the time between C & D and then use a
Pivot Table to perform the averaging. Then you can filter the pivot table using its selection popups. "scottwilsonx " wrote in message ... Is the reason no one has come back to me because it cant be done?! Thanks Scott. Hope someone can help with the following: I have a worksheet ("data") with the following details: range: A2:AO20000 column S is the country of customer column C date order placed column D data order sent column R customer column V product bought What I would like my VBA to do is take this information, and then in another sheet called "analysis" use the information typed into cell A1: customer area and A2: customer name And calculate for each product bought by the customer, the average time between column C and column D. Note where nothing is displayed in cell A1 in "analysis" then the result of the VBA would give all customers. Help please ! Thank you, Scott. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
can this not be done?
Thanks for the message, but I would really like it to be a bit mor
automated than that, and the enduser should be able to select from list of available areas / names etc and then have the code run th calculations for them rather than play with pivot tables. If worst comes to worst, i will have to use pivot tables as I thin this particular query has stumped everyone. Thanks Scott -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
can this not be done?
But a Pivot table allows a user to select from a list of available names
already. And I don't think it has stumped everyone. However from very sparse information you have asked for a largish macro and appear to have waited a very short time before asking why no one had yet supplied what you asked for. YMMV "scottwilsonx " wrote in message ... Thanks for the message, but I would really like it to be a bit more automated than that, and the enduser should be able to select from a list of available areas / names etc and then have the code run the calculations for them rather than play with pivot tables. If worst comes to worst, i will have to use pivot tables as I think this particular query has stumped everyone. Thanks Scott. --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
can this not be done?
I have this solved. I'll send you the code when I get out
of my meeting. (a few hours) -----Original Message----- Is the reason no one has come back to me because it cant be done?! Thanks Scott. Hope someone can help with the following: I have a worksheet ("data") with the following details: range: A2:AO20000 column S is the country of customer column C date order placed column D data order sent column R customer column V product bought What I would like my VBA to do is take this information, and then in another sheet called "analysis" use the information typed into cell A1: customer area and A2: customer name And calculate for each product bought by the customer, the average time between column C and column D. Note where nothing is displayed in cell A1 in "analysis" then the result of the VBA would give all customers. Help please ! Thank you, Scott. --- Message posted from http://www.ExcelForum.com/ . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
can this not be done?
Very sorry if it seemed that way, not intended. However I tried a ne
way of looking at the data and have managed to link 2 pivot table together which, in a round about way gives me what I want. Thank -- Message posted from http://www.ExcelForum.com |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
can this not be done?
Thanks Brett, will let you know how I get on tomorrow morning.
Scott -- Message posted from http://www.ExcelForum.com |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
can this not be done?
You are asking someone to write a "mini-application" for you.
Generally, the people here are willing to help you write your own code when you get stuck on some (relatively) minor issue, like a line that doesn't work or doesn't give the right results. There are consultants available that will create the "app" for you for a fee. On Wed, 11 Aug 2004 09:01:16 -0500, scottwilsonx wrote: Is the reason no one has come back to me because it cant be done?! Thanks Scott. Hope someone can help with the following: I have a worksheet ("data") with the following details: range: A2:AO20000 column S is the country of customer column C date order placed column D data order sent column R customer column V product bought What I would like my VBA to do is take this information, and then in another sheet called "analysis" use the information typed into cell A1: customer area and A2: customer name And calculate for each product bought by the customer, the average time between column C and column D. Note where nothing is displayed in cell A1 in "analysis" then the result of the VBA would give all customers. Help please ! Thank you, Scott. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|