In Quattro Pro I was able to print a selection of data from several sheets just by selecting the area in each sheet. Quattro Pro would then put all the...

Como fazer para evitar a digitação de dados duplicados nas células de uma coluna do Excel. Ou fazer com que o excel me informe que já exite uma célula...

Hello, I have scoured the newsgroups and searched quite a few posts for what I would like to do. We will use cell R3 as an example. I have Office 2007 and I...

Hi, I want to be able to count between a date range and return the value yes. I will show you the formula I currently...

Does anyone have any suggestions on how to set the default format on excel 2003? such as font, size, center align, whenever I open, it is all set. Thanks in...

I have a column of numbers. Some are positive and others are negative. I would like to color "red" the cell with negative numbers and 'green' the positive...

I am creating a questionnaire, where there are yes and no questions that have radio buttons next to each answer. I have two questions. 1. Currently I have...

Hi there, this error seems simple enough--but it won't go away. THE ERROR: "Compile error in hidden module: TBRun9" The error appears when I open or when I...

I am doing a project for work and need to copy a interest formula to the next 214 months (Ipmt function). Ii am receiving an error when I try to fill the...

I am trying to create a column or line chart where a value for 9 variables are given for each month of the year. My problem is that the values are mostly...

Does anyone have any suggestions on how to determine the value? For example, Under following columns: 1 174 198 222 7 180 204 228 9 182 206 230 A given...

We are using Windows Server 2000 & several versions of Excel (2000 / XP / 2003). When opening Excel files from the network, SOME users get the...

Sent OP this Option Explicit Sub SAS_MakeTable() Dim lr As Long Dim c As Range Dim mm As Double Dim mr As Long Dim mc As Double

Tried to find an answer but haven't found one yet. :( I have two sheets. On Sheet 1, I have a Demo Code (1, 2, 3, etc.) in A9:A17 and a total quantity column...

I am having a problem with formating when I copy a table from a word document into excel. Someone in my company decided to use Word to make a very large table....

In some of my spreadsheets, when I try to use the currency format icon (the one with the $), I get "style 'currency' not found. Why would this happen?

I am trying to print an entire workbook and would like the page number to be specific to each worksheet set. For example, my workbook contains 7 sheets, each...

I created a large multi-sheet workbook with lots of Vba macro stuff. This worksheet has been working fine until lately. Just recently after some minor...

I imported a tab-delimited text file, with quotation marks as the text qualifiers. Excel removed the marks, and now I need to save the file back as text,...

Bold is too heavy, normal is too light, I need something in the middle