Hello all, I'm wondering if this is possible:
I have a spreadsheet with multiple sheets. The first is a master job
list, with a job name column, etc, and then i have 14 other pages that
link from that master job list and have more info in subsequent

Hi there. When I run my macro it populates cell A1 with todays date,
the problem is the next day the date changes to the current day. I
would like the date to stay at the date the macro is run then the next
day it keeps the date etc. so I can look back in the month and see the

I have a Excel page with data that ends at linbe 602 however when I
click alt end it jumps down to 2750.
I have tried deleting all the rown 603 to 2750 and clearing the
contents but it does not work. Anyone have a to solve this.

I've had a request from a client for the following...
She wants to locate an Excel budgeting tool that will allow her to
input actual balance sheet balances (as they are changed throughout the
year) in such a way that based on certain assumptions linking sheets

new(ish) to excel and to this site (but have searched previous posts
for help
regularly).
Anyway, how do I select a cell, and then when hitting a button,

Say columns A and B are, Cost and Profit, respectively. Cell D1
contains a percentage value representing my profit margin.
Cost is entered manually.
I want to enter into B1 the formula =A1*D1 and then fill that down the

how can I automatically change all negatives to positives?
How can I automatically change a group of cells from thousands t
millions?
1000---1000000

Hi all, I have some excel question and hope all the expert here ca
help..
last time.. the SUMPRODUCT really helped me  a lot and I am stil
trying to really understand how it works..

A simple example of what I am looking for:
Sheet 1:
Col A     Col B
Jan       125

When i use the function auto filter, the fonts in drop down list box is
small. When i change the fonts of the cell, it can only chaneg the fonts of
the cell but not the fonts in drop down list box. Any advise.
Thanks in advance

I do the stats for a department and all of a sudden wierd things are
happening. Today, I logged on and went to enter some numbers in a spreadsheet
I use monthly. However, when I typeds in "2" it dispalyed as .02. So, I
checked the formatting, made sure it was on 'number' format ...

Help!
I want to start automaticaly a macro or SUB in ThisWorkbook. This is my
code :
Private Sub Workbook_Open()

I discovered the BuiltinDocumentProperties(13) or Total Editing Time in
MS Word.  Can anyone tell me if this property exists/works in Excel?
When I look at File\Properties\Statistics for a specific workboook, the
Total Editing Time field is empty.  When I try to use

Has anyone come across this setup before?
A user here has inherited an excel spreadsheet which is setup to be
shared. Users access the file and add information to the bottom of the
current list. Now if 2 users try to add new data to the same line when

I created a worksheet in Excel 2002 SP3. Nothing fancy, just columns and
rows with text and numbers.  When I open it in Excel 2000, the following
warning box appears:
File error. Some number formats may have been lost.