I have a file that I want the user to click an insert button and not
be able to insert rows.  I have protected the sheet, except for the
area they can enter data into and have created another Sort button.
My code keeps errors at the sort stage.  Any help is appreciated.

Hi I need some script to count a rows in a column in sheet1 & in
sheet2 pate value in cell a1, then a2 when macro is run again and so
on a3,a4 this is so that i can audit if any rows have gone missing.
Thanks

is it possible to use a named array constant in the data validation
list like
={"Jan";"Feb";"Mar"}
I can't work it out.

I'm not proficient in macros, so I was looking for a function that will look
for duplicates and mark one of them so I can delete it but then put in the
combined mail name.
My data looks like this:

I have made several worksheets for lookup up pricing for our various product
lines.  These sheets look up a description, list price, and my cost in
another worksheet (in the same XLS file) based on the part number I enter on
the first sheet.  The list on the second page has been ...

I am trying to create the simplest of macros. I just want to delete the first
4 characters of a cell, and then have it repeat that process for about 350
cells.  Everytime I hit record and give it a name and hot key. I preform the
steps of deleting 4 characters in a cell and hit ...

I need to multiply a time written in the format (m:ss) times a number for
instance 4:02 by 20.  What would be the best way of doing this?
Thank You,
David

I am trying to move values from one worksheet to another using the OFFSET
function.  The worksheet I am pulling from has data on every 27th row and the
cells are 2 columns wide (the cells are merged i.e. A1:B1).  
This is the formula I used: =OFFSET('Elem Bnchmrk'!$B$17:$C$17 ...

I need help with the following problem.  
Example
Cell H13 is either left blank or has a number 1,2,3,4,5,6,7,8,9 or 10
I need the formula to return the following results

Is it possible to compare three columns from three different spreadsheets
using VLOOKUP or another formula?  If all three columns are each in column A,
will you please provide the formula(s)?
Thank you!

I have read many posts regarding this issue and I thought I wrote my formula
correctly.
I have tried it as a formula AND as an array formula
=IF(ISBLANK(A1:N1),"Delete","OK")

Can anyone help me with this challenge. I have an amortization
schedule calculating mortgages. Everything works fine except that I
would like to add a feature for interval extra payments. Does anyone
know how to do this?

using office '03, i want to use a spreadsheet as an invoice, and i keep
having to look back at saved for the last number used?

I'm sure this is in the discussion board somewhere already, but I don't have
time to search through it all, so hopefully someone will take pity :O)
I'm working with a data set ("DATA") that has 5 columns and each week I'll
paste in new rows. I will be transferring this data into ...

I column B I have code numbers, 4 and 5 digit. In column E I have
corresponding financial values. I want to sum values which correspond to
sections of code numbers. ie by reading the first two or three digits of
grouped code number.