I am new to macros but have worked out how to transfer the results of a
calculation to a row on another sheet. When I clear the original data to
enter more how can I transfer the second lot of results to the next row down
on the second sheet.

hey guys can any one help me?(of course it is not a excel question)
My drives are not openinin. if i double click on my drives an "open with"
window opens. I know that it is a virus. Can u send the free link of the anti
virus software that removes this virus?

I have the following:
                                   Attended         Attended
     A                B               C         D         E        F
1 John Doe         x               Y         x         N       ____

I have an Excel 2000 file that I use as booking diary for a community hall,
columns have date, time in, time out, name, etc.
There are about 600 lines of data and the file size is approx 380kb.  I have
conditional formatting set on the date entry to colour the cell if two

I have two cells, each one have a clock in it, like 14:30 and 22:00
Now I want to calculate how many hours/minuts there is between
the two clocks, and the result to be showed in a third cell.
How can I do this ?

I want to calculated travelling cost depending on the days of travel. I have
following data.
(0-7)hrs-0$,
(8-13)hrs-5$,

I really need to know how I can print my finished excel spread sheet on the
same paper but I need one side with a clients supports and then the other
side with the clients financial documentation. That way when I print what I
need out and finish filling in the information thats ...

How can I auto activate of a macro with respect to date

I want to insert subtotals in an Excel 2007 table but the icon is grayed
out.  The 'group' or 'ungroup' icons are active.  Appreciate any ideas.
Regards ...

I want to count how often a single value (the dash symbol)  occurs in a
single cell than rank it.  Showing two examples, AUS-IAH/PTY-IAH/AUS is in
cell A1 and
AUS-ORD-LHR/WAW-LHR-ORD/AUS is cell A2.  Cell A1 has 2 dashes and A2 has 4

While trying to record a macro I need to fulfill the following task, Chose a
sheet go to the last cell move up using the control+UpArrow, then use the
down arrow to go a vacant cell to perform the copy paste operation.A part of
the macro reads like this

For simplicty say I have two cells with values 0.0000004499190595611849428288
and 0.0000004499190595611849428288. If I have a formula that adds the two
cells (=A1 + A2) the value seems to be accurate. But if I use the 'SUM'
function (=SUM(A1:A2)) I get a result of zero, exactly. ...

I run Excel 2000
I have a list of names with each one of them having a hyperlink to an email
address.
These all work fine.

Is there a way to lock a series of selected formulas without going
through and editing every individual one?  This is very time
consuming.  I have looked and I haven't found anything thus far.
Thanks.

Hello - I am having a consistent problem when I build a series of
spreadsheets that contain many rows (usually about 20-50,000 rows in
several spreadsheets), and contain several "if formulas", and contain
several Vlookup formulas.