I am looking to set up up some sort of database that will alow me to enter data in Excel on one page and automatically enter this into a certificate which I...

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...

Is there a way to allow rows to break across a page in Excel 2007?

Hi there, I've got a list of products for my company but it is listed in product group, the products for that group coming underneath.. like...

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...

Hello, I use a spreadsheet as a calendar with a separate sheet for each month. I have the days going across the top and a list of staff names down the side....

I am trying to copy/paste the filtered (subtotals) on my worksheet of about 17,000 rows. I do this every week. Unfortunately, I am getting the following...

I have a cell with a full sentence in it. The cell is too small for that sentence so of course it carries over the cells to the right of it to display the...

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...

I know how to arrange windows to look at multiple workbooks. But I want to have two worksheets displayed at the same time from the same workbook. Is there...

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...

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 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...

Guess I have a duel question. First, I have numerous columns of data, all numerical. New entries are entered at the end of the column. Is there a formula...

I have a spreadsheet with several hundred rows and many columns. The formula in column "C" sums values for all columns from "D" through the last column for...

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 need to know how to create subtotals for individual pages in excel. The user has data each month consisting of hundereds of rows. Is it possible to have...

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...

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

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...