I am trying to create a macro that will copy a range of data; however, the
number of rows to copy will vary each time the macro is run.  Is there a way
that I could creat parameter fields that the macro cuold read?
Thanks,

Am trying to get the agedays based on today and 20th dec , excluding
weekends( Saturday and Sunday) , Can some help me quickly

How do i move a Vertical column over to the right & have the information
move with it ?

I am trying to count any matching days when comparing one date range
to another. Any formula suggestions would be appreciated.
For example:
Range 1

I have two charts.  Both have Dates as the Category Axis.  The
distance from the date to the bottom border on Chart1 is about 1/4".
The distance from the date to the bottom border on Chart2 is about
2".  Both charts have the same font, etc.

When I do a page preview, each cell in the worksheet appears as a separate
page, and when I try to change the page layout, I can not get past a "margins
do not fit page size" error.
I have followed all the help instructions on formatting a worksheet to a

I have a named range, called Servers (B2:I50). Within this range I
want to count how many entries begin with New, so figure I need to use
Left somehow, but am not sure how I can use this in a single cell with
some countif/sumproduct function to count them all.  Can anyone help

I would appreciate it if someone could tell me the formaula to retrieve the
number of weekend days in any given month e.g. January 2011.
Many thanks,
Andrew

Hey guys :)
I use this formula =">="&DATEVALUE(Files!D3)+TIMEVALUE(Files!D3) to
display and use as filteroption.
(Dont ask why I have to do this exercise....)

Is it possible to change the background and foreground colour frm the
standard grey and black to say white and red?
Thanks

Can you make a drop down list appear within your original drop down list?
I have a list of items:  box, ball, aplle, scissors, stalper. (for example)
and I want to be able to select from different lists depending on which
number I am choosing.

I'm trying to calculate the prior month (in 3 letter format) using a formula where I populate the cell reference with the current month.
i.e. I enter Nov in A1 and A2 has a formula to give me Oct
Any ideas?
Submitted via EggHeadCafe - Software Developer Portal of Choice

I'm pretty uneducated on excel but am trying to develop a master list of
coded infomation that I can simply type a "code number or item number" which
will then input the saved info for that "item number" into the adjoining
cell, along with a cost  associated with that item number ...

I have a spreadsheet with dates in one column and data extends to columns to
the right of the date.  I need to do is count the number of cells that
contains data within a date range (for each month within one year).  Example:
For the month of January 2007, count the number of ...

I have a spreadsheet with many rows & columns of text and numbers.  when I
sort by date and then run a subtotal for each month's figures- the 1st
section (January) data does not add the 1st or 2nd line into the subtotal...
whether I have checked "header" box or not or even if ...