I want to make a list of saturday and in the autofill option i do not see
this options? Ideas?

Hello~
Im trying to create a formula based on ranges of numbers, as well as single
value numbers in a spreadsheet to where the  out put is a value of either Y
(for yes) or N (for no) depending on where in the range of numbers my search

I have a brick selection sheet with Data Validations in Lists of Brick Blends.
I have added * to the end of each brick blend type to signify the amount of
different bricks ie. Colonial Blend** means 2 x different bricks required
(Non Chargeable to client) and Homestead Blend*** ...

i would like to seperate figures in lakhs and not in millions
eg 1,00,000 & not 100,000
how do i do it

Might be an issue that has been covered a million times before, but still
gonna ask once more...
Can I somehow link values between different worksheets, so that when I
change information (add lines etc) in the source worksheet, the information

I need to limit a date entry to no greater than four days from the current
date.  The only Excel data validation schemes call for restricting by
specific dates.  This validation is inadequate for my purposes.

I'm trying to run the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
Range("C65536").End(xlUp).Offset(1, 0) = Range("B1") + Target

How can i display an error message if the sum of values exceeds a certain
number, or not to allow sellecting a number from a list if the total values
exceeds a certain number

Hi,
I need to find a formula which gives me a total in the cell of all cells
which are formatted in a certain colour.
This is for a banking spreadsheet with a running balance across worksheets

Would really appreciate someone telling me how to display a name (from 10-12
possibles), based on multiple options in a range.
In the column A (range), there is a number of ten or more 4 digit engineer
codes spread across 300+ rows, which I would like to display as engineer

i need help making a wooksheet that right to left each column increases by
12.00
and each row going top to bottom with increase by 8.00  so i can go to line
eight and colum, 5 and get the correct total for 8 childrens admissions and 5

I have a couple of charts that need a line drawn at a certain number on the
value axis. Is there a way to place a line on the chart?
Any help is appreciated
Steve

I have several working worksheets with data.
I made an summary sheet for all working worksheets.
The formula I used is =SUMIF(Sheet1!$C$3:$F$258,$A3,Sheet1!$F$3:$F$258)
Now, I attempt to replace "Sheet1" with function INDIRECT.

I am trying to get a count of rows where the date column has a specific date
and a second column is marked with an "X".  
Example:
Col F is a column of dates

I designed a Pivot table to look at various data, with 2 fields in the
column section.  The information is perfectly accurate, but because of
the quantity of information, I have to set a specific alignment for
readability for the 2 fields.  If I add information and refresh, I'm