Hello again,
i read sometime ago about a macro about a macro that can embed formula in a
worksheet...
(e.g)

I'm losing data validation when I carve up an existing spreadsheet.
Validation values are hidden on sheet #1 currently in rows 2-35.
If I carve up the spreadsheet (for example: I save rows 50-250 onto another
workbook), I lose the validation on the new workbook.

I have a question?
When you are making a cell with a formula the references are set.  But when
you copy the cell each cell reference changes relative to the position the
new cell is.  My question is, is it possible to have to cell references stay

Is there any way to accomplish this? Preferrably without VB code(although it
would seem unlikely to me any other way).
Basically what I have is a worksheet which imitates an Equipment Rack Facial
drawing(say "Rack Profile"). It dynamically populates the data from the

Is there an Excel funtion that calls the last value in a column? For example
I have a column that will be continuosly added to (through barcode scan) and
I need the last value in that column to show up in a specific cell. It sounds
so simple. there has to be a built in function, ...

Would like to know how to use cell refrences in Excel to configure a simple
checking book worksheet.

hello again,
after reply and reading previous posts...anyone please give me ONE sample
SIMPLE formula that can produce results either error results "#NULL! or
#NUM!" or numbers as desired result.....

have two columns and column B want to paste special with skiping empty
cells into column A (in column A where need to paste there ARE empty
cells)   and my excel 2003 paste it all as normal paste!  don't get it
what is problem but i'm sure before was working this fine!?

Once I have 'ranked' the rows by a 'priority' number, how can I automatically
get rows with priority 1 to move to the top of the sheet followed by priority
2 and so on?
Also, how can I get rid of the #N/A error (still in RANK) in cells reporting

Using po numbers in column A produces the serial numbers in column B.  The
issue is the PO numbers are the same but the serial numbers are unique.  The
vlookup function is only pulling the first po lookup line for the serial
number.  The results for serial numbers are all the ...

I need to get random result between 1.1 and 1.25  like :
randbetween(1.1,1.25) or randbetween(1.125,1.235)
It gives always 1. How cani solve this ?
Thanks,

Could someone tell me how to write an If-then statement that will identify if
a new row is added to a range? For example, we have a range of data from A8
to J329 that covers a financial accounting system. In some cases, a new
account number will be added simply by inserting a new ...

I am calculate benefit rates based on current age.  I have entered the
following, which works but I have more age catagories that need to be added
=IF(E22>70,"2.01",IF(E22>65,"1.24",IF(E22>60,".66",IF(E22>55,".43",IF(E22>50,".23",IF(E22>45,".15",IF(E22>40,".10",IF(E22>35,".09"," ...

I want to import data from a website into columns and rows in excel. Please
help!

I have numerous cell entries all the same length ie:( 21071303129W300)
I need to edit the entries with slashes and dashes as shown here
21/07-13-031-29W3/0...how can I acomplish this in excel without manually
editing each entry cell by cell?