Simple I know but have stumped everyone. How do I format a worksheet to view only the selected print area in the working area. In other words I do not want to...

I'm not sure if this is an Excel or Word problem. I have an exported file from a database which has multiple lines that need to be merged into a form...

SOME OF MY CELLS ARE NOT SHOWING UP ,IN MY SOURCE DATA ON BARTENDER IF I PUT NUMBERS IN THE CELL IT WORKS FINE, BUT LETERS DO NOT SHOW UP.IVE TRIED CHANGING...

i have the following text string "Home: installation on Cognos (5.5 hrs)" the number represents the number of hours i want to have separated from the text"...

I have data that I have summarized where I need to count the occurance of particular words (i.e. No Answer, Unconfirmed, Wrong Number). Is there a way in a...

Like the subject says, try it out. Its REALLY annoying. Does anyone know how to change it?

How do you delete all the 'names' defined @ workbook? I can only do it 1 at time now using 'Insert'-'Name'-'Define'......however, I have hundreds of them...

Hi - very thick question I'm sure but is driving me mad - I have the following and want the time to travel in minutes, how do I then calculate the total cell...

I jumped on the Excel (VBA) bandwagon some years ago. I have dozens of books and reference them constantly. In no book or in my visiting any newsgroup have I...

Hi, I have column of monthly investment returns. If the return for a particular month is less than zero I want to regard the return for that month as zero but...

I have a workbook with 4 columns containing lists of names from 4 different workbooks pasted as links to a name list in each of those workbooks, one list per...

I've searched and searched but can not find a template for a daily work order or even a daily activity sheet. A work order database would be great as...

kindly let me know about a tool that converts figures into words in excel

I would like to be able to force employees to enable macros for a certain workbook or it will not let them open the workbook. And maybe put a password on it so...

Despite my limitation with writing codes, I need to find a simple to follow code to hide rows without information in a specific column in three tables that I...

Hi, In A1 i've got 31-dec-2005 as a date I need to get the month as text into A6 ie dec Any ideas? -- Cheers

Hello We try to use pivot table using external data from access to bypass 65K lines limitation . . . the pivot table blocks at 195.233 lines Is there an...

Hey Guys, here is my situation. I have two workbooks (excel files) WorkbookA.xls and WorkbookB.xls. I would like to combine them both into...

I created a file which uses advance filtering on a database worksheet. On clicking a button, the advance filtering work its magic. But when I copy another set...

I am new to this forum but thanks for any help. I have one sheet which is a work schedule of 6 weeks at a time. On the second sheet I was trying to get some...