Search results for query: *

I know, damn those functions that work as designed! :-) Here's the task: I would like to have a report that will show users which items will be produced on which line, by date. Pivot tables make it easy for me to set up the columns and rows by which the report should be presented and if I...

Here's a simplified scenario: Column 1 contains production line code Column 2 contains production date Column 3 contains shift number Column 4 contains item number that will be produced I create a pivot table with line/shift as rows and date as columns and would like to display the actual item...

No, timer definitely won't work. The data is relatively fast-changing and should be accessible "on-demand". So making a timer, say, for every hour is definitely too slow, but every 5 minutes would probably be an overkill, especially if it fires off while they are doing the analysis within the...

Skip, Thanks for the code! I'm assuming this would have to be added as a macro or on the Worksheet.Activate or Workbook.Open events. I would like to avoid any of those, since placing another macroable button would interfere with how the old spreadsheet that I'm trying to replace used to look...

Excel 2007. Table1 in Sheet1 is linked via ODBC to an external data source. PivotTable2 in Sheet2 is based on Table1. I'd like to have PivotTable2 automatically refreshed when the user refreshes the data through "Data/Refresh All" My first attempt, based on the archives here, was to do this...