General

Doubt about pivot table
Good afternoon, I doubt the following staff: I know that you can create a Pivot Table apart from others in the same workbook (they share the cache). But I wonder if it is possible, normally or using VB to create a Pivot Table starting at one that is in another workbook. Thank you for your help. Diogo A.... 30 Mar 2010 15:01

counting identical items in a column and returning the occurrences
I use excell 2000. I have one column with 700 rows. In each cell is one number, either a 0, 1, 2, 3, 4, or 5. In the second column I have five rows, each with one number in increasing order: 0, 1, 2, 3, 4, 5. Next to the numbers 0-5 (in column three) I want the total number of occurances for each number in colu... 26 Mar 2010 22:57

make camera object refer to dynamic range
I have a camera object that refers to a range on another spreadsheet. When the user makes a selection the range filters to show only matching records. Unfortunately, the camera object does not resize to show only rows with data. Is there a way to make the camera object dynamic so that it will expand and cont... 26 Mar 2010 20:30

HOW TO MAKE A NUMBER OF CELLS INTO 1 BIG ONE AT THE BOTTEM
I need to put a long sentence at the bottem across a number of cells, how to do it? ... 26 Mar 2010 22:57

Converting excel 2007 to tab delimeter text file
when I convert excel 2007 data into tab delimeter text file, it is adding two extra tab spaces at the end of each row, but it is not happending the same while converting excel 2003 into tab delimeter text file. please suggest me on this. ... 27 Mar 2010 12:00

MS Query - Filtering all dates greater than the current date
I'd like to return only data by filtering a date field for any date past the current date. I can filter using [is greater than (>)] but it seems my only choices are a date that is already in the field or a static date I enter. I need to use an expression such as [CurrentDate] or [now()] but these don't seem to ... 26 Mar 2010 17:59

R1C1 reference
Can anyone tell me the proper structure for thid statement? ActiveCell.FormulaR1C1 = "=IF(TagNmeMe.value!RC[-1]="""","""",TagNmeMe.value!RC[-1])" TagNmeMe is a string that has the stored Sheet Name . if(sheet1!A5="","",sheet1!A5) ... 26 Mar 2010 20:30

Round up or down by set variable
Is there a way to have a number round up or down based on a threshhold it hits between the two number? I want a number when it hits .8 to round up, otherwise round down. For example 1.8 would round up to 2 but 1.79 would round down to 1 2.8 would round up to 3 but 2.79 would round down t... 27 Mar 2010 16:33

Dates
Quick question. I am setting up a column with a date format and want to just enter in the month and the year ie. 03/09. However when I enter this in it assumes that I am requesting for the current year and posts as 03/10 is displayed. 03/09/10 in the function field. Is there a way to do this and only enter i... 26 Mar 2010 15:37

Reminders in Excel
I would like to be able to have a reminder pop up in excel (when I open it) that reminds of training schedules that are due. Is there any way this is possible? I have conditional formatting to highlight, but would like to have it show me without scrolling through my sheet daily. any help is appreciated. ... 26 Mar 2010 16:46