I need to update a spreadsheet that uses macros for invoice tracking.  Here
is an example of what I am calculating:
Invoice 1               Task 1   Task 2    Task 3  Task 4
Company A           $500      $1,250   $400     $375

I would like to use the now function to record the current system time with
seconds, but I do not want this function to update when I type another
instance of the now function.  I need seconds so using ctrl+shift+; does not
work.  Is there a short cut or syntax that I can use to ...

Hello, I need to have excel fill a cell only if there is a value in the cell
to the right. I.e Column A1 increases by 1 whenever I enter a value in column
B2 and so on down the sheet. Thanks

=VLOOKUP(A2,Budget!$C$2:$Z$10000,6,FALSE)
This is the formula that I am entering into my spreadsheet.  However, when I
copy it downwards, I get a #N/A, even though there is a match for the lookup
value in the table.  If I enter the formula in the next cell, Excel will

Is it possble for one Workbook to have more than one password?

I'm currently working on an excel spread sheet with around 370 sheets. On my
final sheet there's a big list of everything. Each sheet is a parts list for
a product, and each product has its own unique id. The list is meant to
reference the cell E2 on a sheet and call up the id.

I have created a check box from the format toolbar.  I want to change the
text font size and make it bold.  How do I do that?

how can i password protect my vbe projects so the work but cant be changed
with out a password
Regards
Stan

Do you know what should be the number formatting if I want to achieve this:
.151843 instead of 0.151843 (=beginning zero falls out)
but
1.182 stays the same (=if the number begins with something else than 0. than

If i have a range of A1:A300 and the range of numbers within those cells
could be anything from 1 to 50 how do i count cells that contain numbers
greater than 20 but less than 31?
Thanks

I have a number of worksheet in a excel. Base on a worksheet from A1 to
IM5000, is it possbile to change some of the cell color from yellow to blue,
but without changing other style? As I have some other worksheet to change
too.

I have a spread sheet (5000 entries)
i have an extra column at the end.
I'd like to generate a formula which find if my data in column A (A1:A5000)
contans the word "Thailand".

I am trying to evalute all cells in a column with the word Tesco in.  The
problem I have is when I download the data from an external range, the cell
that contains Tesco can have other words in it, i.e. Card Payment to Tesco or
Tesco Store.  I can see how to use SumProduct if the ...

I have copied quite large amount of data from my companys web based
information system and pasted it to Excel (XP/2002). In that data were names
that work as hyperlinks to e-mails.
How can I remove multiple (like 100) hyperlinks at once?

I'm trying to produce a report which summarises data by country, when the raw
data is given by country - region viz:
Australia - Canberra    765.4
Australia - Melbourne    18796.3