I'm not entirely sure if this is possible or not... but here we go.
I'm looking to lock down two cells in a row after data is input into the
cells... for the entire spreadsheet... or at least 2000 rows.  I think the
easiest way would be to have a function since I could fill down and ...

As described in another post of mine, I am calculating totals based on
criteria. In this case, I'm using SUMIF to calculate totals using criteria
that is between two numbers (>=1 and <=5 for instance).
Here is my SUMIF formula:

Hi;
is there a way to validate CND postal codes in a spreadsheet? If not how can
I format the column to accept only A9A9A9 type of data? (Upper case,
number,uppercase, etc.)

I'm using the SUMIF function to add numbers in a range that meet a given
criteria. The criteria I need to use is a range of numbers (>=1 and <=5, >=6
and <=10, etc).
While I have been able to perform this calculation by hard coding in the

How do I replace the dollar sign with the euro sign trying to set up an XL
invoice?

I want to set up an address data base in Excel.  They would be a combination
of personal and business addresses.  I want to be able to separate them for
the purpose of printing mailing labels.  I am new to Office, could someone
suggest a template or solution ?  Thank you.

I have the below macro which deletes duplicate entries based on column "A"
part number. The worksheet has nine columns, and column nine includes the
UPC code. So some duplicate rows may contain column nine with a upc code and
some may be blank. I need the duplicate rows that ...

Has anyone had this problem:
I have a spreadsheet with multiple tabs.  On the first tab I can selec
a group of cells within a column, lets say B12 -- B45 and right click o
them, get the option 'Delete...' and it asks if I want to shift left

Hi friends
My first ever post....
I have a web page whose template is fixed. Every half hour the page
gets updated. There are 10 rows (say 10 Students in a class) and

Is there a simply way to have the cursor in an Excel spreadsheet, once
it reaches a certain cell due to macro movement, to automatically jump
back to Column A.

What is the syntax of an address of cell immediately to the left of a given
cell ?
Can you please also write syntax of an address of cell immediately to the
right of a given cell. Perhaps that will help me understand and maybe even

I m trying to round a decimal up to the #.#9.  For example 8.33 I would
like to round up to 8.39 or 9.95 to round up to 9.99.  Does anyone know
the formula to do this.  If so email me @ tswango@glessnercpa.com
Thanks

I have a sheet that I want to share with co-workers but I only want
them to have read only access.
If I put the file on the public server it will give the frist perons to
open it full access and readonly to everyone there after.

Again, thanks so much for all the help on this newsgroup, much appreciated.
I have a workbook with a master sheet and several other sheets. I would to
see if there is a macro that will scan the master and update all the other
sheets if they have the corresponding part number. I am ...

Would it be better to use code with a msg box to enter data into a range of
cells or would a UserForm be better?  Is it possible to use a UserForm to
place data in only a range of cells?  If that can be done can it place the
data in the selected cell within that range?