General

Printing selected pafes in Excel 2007
Is there a way to print selected pages in Excel? ie. instead of just range (5 to 10) print pages 1-5, 7,9 ... 15 Apr 2010 13:39

Help with a macro
I have a form that people enter daily information in. I need to be able to retain the data each day. So, my thought was to link cells to a second worksheet. How do I make the 2nd worksheet switch to the next row after the last column is filled in so that the next day has a new row to take data in? ... 15 Apr 2010 13:39

trouble with shared workbook
I have an Excel workbook that is shared amongst approximately 20 people. They enter project progress updates weekly. It is linked to access. Some reports are run in Excel and some in Access. When I finished running reports this week I went to close the Excel workbook and reimplement the sharing feature. It... 15 Apr 2010 13:39

Displaying report filters on Excel Pivot Tables
I am using pivot charts to display different departments' data, over the course of the year. When looking at the graph, I often filter it to see just one department. When viewing and printing, I would like to be able to see which department the chart is filtered on. Is there a way to do this? ... 15 Apr 2010 12:32

Converting a letter to a numeric value
I have a spreadsheet where I need to tally the number of Yes, No and N/A anwsers. How can I add them if the letter "x" is being used to mark the answer? ... 15 Apr 2010 12:32

Conditional Formatting from 2007 to 2003
Hello, I'm having trouble creating conditional formatting that will work in a pivot that both 2007 and 2003. I understand that in 2007 you can have more than 3 conditions but 2003 only supports 3. Can anyone give me any suggestions. Thanks ... 16 Apr 2010 22:53

Time entry help
I am using this formula =IF(D5="","",NOW()) I want to stop it updating everytime I put a new entry in the worksheet I need the time to stay static Cheers!! ... 15 Apr 2010 12:32

how to delete an excel worksheet?
... 15 Apr 2010 12:32

Problems with 'Names'
I am using MS Excel 2007. I have a series of linked files - 1 main 'parent' file with 5 'children' files. The parent file contains 'names' which are used in all the children files (eg..titles across columns, drop down boxes/lists (referencing name ranges) etc) I need to find and replace some of the externa... 15 Apr 2010 14:46

runtime error 429 when trying to create Inet object
Hi I am trying to create a macro that uploads a file to a ftp server.It works fine on my laptop (using Vista) but not at the office(2003 Server R2 and XP prof users).I keep getting run-time error 429 "Cannot create object...".I did reference Microsoft Internet Transfer Control 6.0. I did some research online ... 15 Apr 2010 09:11