Search results

I'm trying it now. I have Office 2007. I added all the libraries but it won't let me run it at all. Doesn't show up as something I can run... did you have that issue?

Hello, the code below basically runs some Access Queries, then copies them in to a NEW excel workbook in .XLS. What I want to do instead is open an existing .XLSM wokrbook delete or update the 7 sheets it creates and replace them with the new query results from access. I love this code below...

Pat, I agree. In this case, I couldn't figure out how to make it work. There are about 7-8 tables that make the asset position go up or down. I have to keep everything in their respective months. It's a rolling monthly asset balance. The only way I could figure it out is to create quries to...

I'm analyzing SAP data and putting it in a dynamic visual tool in excel. So, the formulas in Excel actually need the data in columns in order for the chart visualization to work. I'm going to revisit restructuring the queries for the purposes I need here. Thanks guys!

I compeltely agree but it's the format that I had to use for our users. There are about 7-10 tables that create the initial subquery. There are 60 subqueries to get to the one I want to analyze. I had to take the ending balance of each asset of each month, the create another query based off...

Hello, I need to do figure out a couple options: This query returns a running asset balance for 60 months. Each month is 1 column. 1) I need to create a query based on those results that can cycle through each column and determine if it is NEGATIVE. Then if it is negative, I need to...

I found a solution on an excel forum. The subgroups could be random though and they can be sorted randomly as long as the would end up on the same row as major group "A." Thanks for your help!

I would be ok doing some VBA. That was just one example... in another case we made need up to 750 columns. May have to use Excel for this.

In the real set there is about 77 groups and at least 10 subgroups per group

I'm not even sure how to search the forums or google for an existing solution. What I'm trying to do is create columns based on subgrouping. See attached example in excel. It's almost like transposing but not it. The names of the columns don't really matter. It's to be used in a dynamic...

Not including the comment box. Starting with the date of the first demand for each item. So if the first demand was in May, start there and avg for 12 months then the following months.

Thanks again but still not there! Its better that it does all the materials now but the result I'm looking for is more like Completely fictional: A - 8/1/2013 - 30 (which is the average of 8/1/2013-7/1/2013) A - 9/1/2013 - 40 (which is the average of 9/1/2013-8/1/2013) A - 10/1/2013 - 50...

Thanks but not what I'm looking for. I need an average for every rolling 12 month period so each month would return an average of the future 12 months. There are really over 10,000 materials.

May be VBA is a better solution for this: Say for Material A: I need Access to see that the 1st date is 05/01/2013 and say 365 days out or 12 months (05/01/2013-04/01/2014) the average is 158.6 then 06/2013-05/2014 the average is 146.667 and so on. Every month is not going to be listed in the...

I have a lot of scenerios where I need to do rolling formulas, so it'd help if I could learn some lessons here :)

Help! I swear I figured this out earlier today and I was like "that's easy enough to remember" then I couldn't do it again :( Here is what I need help with: Say for Material A: I need Access to see that the 1st date is 05/01/2013 and say 365 days out or 12 months (05/01/2013-04/01/2014) the...

For every month you'd do 50/100 Then you'd sum up the last 12 months of that equation (Error/Historical Demand) SO you'd get 6. Then Divide that by 12 and you'd get .5 (used below) Then the 2nd part you'd get the sum of demands for the past 12 months for the group which is 1200. Then...

Sorry, does this help? EDW Item, Cal year / month, Historical Demand, Abs Error, Group X, 03/01/2012, 100, 50, A X, 04/01/2012, 100, 50, A X, 05/01/2012, 100, 50, A X, 06/01/2012, 100, 50, A X, 07/01/2012, 100, 50, A X, 08/01/2012, 100, 50, A X, 09/01/2012, 100, 50, A X, 10/01/2012...

Hello, My hair is literally turning white trying to figure this out. I'm not sure what is the best way to do this so I hope you experts can help me. I'm not at work so I don't have the examples with me. It's not that complicated. Basically I have a table called "EDW" which is an SAP...

Can you give me an example of a Case Statement with multiple statements? [MC]![P] is Value I ended up leave the "type" off for now. Here is what I'm running with: Public Function SMC(Dmd As Long, Value As Long) As String If Dmd >= 500 And Value >= 40000 Then SMC = "A1" ElseIf Dmd >= 100...