Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Format a drill down report out of pivot table
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...- benisma
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Trouble with sql in VBA, too much?
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...- benisma
- Thread
- Replies: 14
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Function not calculating the last row of loop
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...- benisma
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
