data tables

I create workbooks that have a significant amount of private data that is used to generate charts and reports. We want to distribute a workbook with just the charts and reports without any links to the data. No big deal - use vba - create a new workbook, copy over the charts to the new workbook...

I have two Excel spreadsheets in this workbook and am using 2007 for development. Sheet1 contains the raw data and sheet2 contains summary information about the data on sheet1. I wish to restrict the user's access to sheet1 but I would like the user to be able to apply filters on the data in...

Can someone please advise what the VBA code would be for a 2-way and 3-way data table.

Hi, I have substantial amount of information which I would like to arrange in the following manner. I did believed I was an 'ok' Excel user, but I have tried this problem with PIVOT tables, with concatenation of IF / HLOOKUP, with very limited success. (and more gray hair) The way I have it...

Greetings all - For some Excel courses I teach at the beginning and intermediate levels... I am hoping to get some files with LARGE amounts of data to incorporate as teaching examples. Textbook data sets are usually woefully inadequate for instructing pivot table and database features in...

I'm using a model which has 8 different Data Tables. (No I did not create). I currently had the calculation mode set to manual. However, when I go to save, the file takes over 5 mins to complete the saving process, while it is no more than 4MB in size. Is there any way I could speed up the data...

Hello, I have built a model which aims to calculate various information/statistics based upon 2 inputs which I can change (see 'Mov_Avg_Chart' tab cells C6 and C8). In cell C6 I have identified the moving average period that I would like, and in cell C8 the period for moving average of the...