Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |