Recent content by benisma

I can do that in the worksheet, but then that gives 2 sets of numbers for the sales manager to look at in the drill down report. Can I take out the first set of numbers from the pivot table and just use the rounded #s? If so, how? I tried to reset what data my pivot table was using, but it...

I have a "detail" report on one page of my workbook and a "totals" page with a pivot table for a quick refrence for all of the field personnel. The idea is for the pivot table to be looked at first, then the detail for further info if an issue is found. In the detail report, there are gross...

Sorry, I am having such a rough time of it lately. I will work on the query.

Skip, I am not absolutely sure of the number of query tables. I know that I built this query and this is the only thing on the page. On the next worksheet, there is a pivot table. But, I have built this out of an Access database that has 7 different queries linked to it. I am sorry I am being...

Foe some reason, I can not get the query to refresh on the worksheet through VBA. I have tried: Sheets("detail").querytables(1).refresh worksheets("detail").backgroundquery.refresh The first that I tried was the Excel command .refresh background query:=false What can I use? It will save the...

It worked!! Thank you all so much for your help.

Now it is giving me an "expected end of statement" at the first line continuation. I have tried a variety of things, and can't get past this. I think it's probably something I am overlooking. Here is the first part until it stops me. range("C4").Select With Selection.QueryTable...

Here is the begining of the code for xlbo: range("C4").Select With Selection.QueryTable .Connection = Array(Array( _ "ODBC;DSN=MS Access Database;DBQ=C:\Documents and Settings\jsneed\My Documents\work for fleet 1-2006.mdb;DefaultDir=C:\Documents and " _ ), Array( _...

I am trying to put the following sql into VBA to run 134 different districts. SELECT cash.REGION, cash.DISTRICT, cash.STORE, cash.LINE, cash.IPLCD, cash.IPCODE, cash.cash_sls_total, 1-(cash.cash_cost_total/cash.cash_sls_total), installer.charge_sls_total...

Thank you all. I took the code from "vbap" and applied it as Mike and Skip suggested, worked like a charm. I really appreciate the help!

I wanted to do a sumif for a concatenated 3 letter code, product code and sub code(groups of parts). After finding the match, I wanted to sum cost on those items. I want it to look like this: Con cost cost sum WAL22 75.41 10858.78 WAL22 52.52 10858.78 WAL22 23.33 10858.78 WAL22 65.78...

I have 4 queries built into a spreadsheet. There is a lot of manipulations that happen after that. I have figured out how to loop and use the selection.offset to be able to handle the different sizes of data. The first 4 loops work just fine. The fifth loop, that I had to write a function for...