General

Macro to filter dates using Userform1 & printing
I have a speadsheet that has 5 columns. (Headings are in row 2 and are: Cell A2=Date, B2=Name, C2=Paylist, D2=Cycle, E2=Action). Data starts in Row 3 and will go down to row 5000. The dates would start 01-Jan-2011 and could go up to 31-Dec-2011. Right now I have 2 macro's to sort by date and paylist but what ... 11 Mar 2010 11:11

Comments Defaults
Hello i want to change the shape and font of Comments in Excel 2003 and then apply this as the default to all Comments created thereafter. I thought I just needed to right click on the comment and select Set Autoshape Defaults but this does not work. ... 12 Mar 2010 12:49

access & excel issue
i made a pivot off an access data base but the figures came up showing zero "0", and i founf out that the reason this is so is because the excel pivot is reading the figures as text and not number and i checked the design view everythin is in order. was wondering how i can rectify this. ... 11 Mar 2010 11:11

SUMIF???
I need a formula that will sum up columns N through W but only for rows where column C = specific word AND F = specific word. ... 11 Mar 2010 12:19

How to mail merge multiple rows in one document
Hi, I have a worksheet that lists subscribers of a service. It looks something like this: Organization Name Title Email ACME CO. Smith, Sam CEO ssmith(a)acme.com ACME CO. Jones, Bill Staff bjones(a)acme.com Each organization has one president and ... 11 Mar 2010 10:03

Sort Window Size
My company recently upgraded to Windows7 and Office 2007. When I use the sort command in Excel, the size of the sort window increases with each use of the command. I have to grab the edge of the popup window and resize it in order to see the work sheet. Is this a known problem with this software combination, or... 11 Mar 2010 10:03

Excel 2003: Duplicate dashboard and data sheets
Hello, I created a dashboard with several small graphs on it. The data for the graphs is stored on a separate data sheet (i.e., work sheet). I now want to duplicate the dashboard/data sheets to build a dashboard for another employee. I envision the workbook eventually having 5 dashboards driven off 5 d... 11 Mar 2010 08:55

Filter
Is there any way to link a filter to a sheet of data which is based on a data validation cell/cells? (Instead of using VBA). ... 11 Mar 2010 08:55

xls data valadation question
i can create a list using the data validation btu would also like to be able to type text in the same cell. is this possible? ... 11 Mar 2010 11:11

How to print the background?
Any simple way to have the background picture be also printed rather than being only displayed on the screen. -- Thanx & Best Regards, Faraz! ... 12 Mar 2010 11:41