Hi.  I am trying to assign a set of values, in separate fields ,to a each
selection from a drop-down list in Excel (using data validation).  What I am
trying to do is very smilar to, say, to selecting a SKU from a list and
having the product description, unit price etc. fill into ...

Hello, Im doing this spreadsheet model on handling costs and how many
items of products ive sold from a shop...and I will like to add in some
macros...can you suggest some macros such as "Save"  "Print"  etc etc
Thanks

Help!
A client's server was automatically updated to MS Office 2003 SP2 at 3am
this morning. Normally this would be wonderful, but a Windows Service that I
had written, that runs on that server, and that utilizes Excel is now

I have two very 'tall' columns of data (>10k rows) and I'd like to
insert a third column calculating the difference between the first two.
Ordinarily I'd just insert the formula into the top row and drag it
down, but with 10k rows this takes a very long time. Is there a better

I have a list with transactions.  The first field is Date (maybe that's not
a good name) and I want to filter the records by month.
I tried this
Mon = Val(InputBox("Which month"))

I have recorded a number of macros in a worksheet,
How can i combine these macros together, instead of running each macro
i want to just run one macro.
It was too big of a job to record one big macro.

When there are 1 or more descriptive fields in a pivot table and
the entries in field 2 or further on are repeated, the values in the
previous field are left blank for each repition of the subsequent
field.

Got a small problem with excel.
I need to convert some text from upper case to lower case, easy i hear
you say..
The only problem is that the first letter of each word needs to be

I am trying to manipulate some imported text/data on a spreadsheet. My
problem seems simple enough but I have not been able to come across
the solution by myself.
I have a column of numbers preceded by a # sign.  I would like to

Thanks Otto for your help. I really appreciate it.
The destination cells will be exactly 28 columns to the left of the
orginal cells.
I fooled around with some formats for the destination, but once again

I can't get the grid lines to work on my worksheet. I fill in the box to
show grid lines on the options but they don't come up. Am I doing something
wrong or is there somewhere else I need to check? Thanks for any help.

Thanks Bob that works great, just one more detail since I didn't notice it
at first, What code would you put in to return the cell color back to white
on click again.
I would use that if I clicked a wrong cell.

hi
i'm working on a excel spreadsheet and was wanting to place a link to a
empty word document, from a link or a macro of some kind.
this is so that the user can open a document a write a letter after

i have a worksheet that the user is required to enter data
in row 27 columns c to z
what i want to to is check the cell data entered in and return a value
eg.

Ive seen spreadsheet where you can click your mouse on a 'Button' on th
spreadsheet and it will print out a range of worksheets/pages etc.
Id like to set this up on my Budgets, is it a Visual Basic thing ?  Ho
do you do it ?