I have 2 problems in excel and I count with your help because i don't know
the best way to solve them.
1 - I need to do something like a combobox from where i select one text from
others. How do i do this? Is it possible to do it with lists?

I have a daily report that I am in the process of automating.  The
report needs to date sales from the day before, excluding the weekend.
E.g. today is Friday 28th, the report is run for Thurs 27th.  I can do
this using the =TODAY()-1 function but this comes unstuck on Mondays,

Hi I have several excel files which automatically save as a date.  I would
like to add a function to get data from a file defined in a cell.  
I have tried
="[("&A1&").xls]"&"Pay_Details'!$C$6" but it displays #REF! not sure if this

Does anyone know if or how I can set up an electronic rolodex/business card
file?  Thanks!

In english:
Cells in Column K contains one of the following values; .25, .50, .75, 1.00,
1.50, 2.00, 2.50, 3.00, 4.00, 5.00, 6.00, 8.00 & 12.00.
Cells in Column I contains one of the following values; Valve, H&B, Valve,

I'm trying to creat a macro which will copy and paste the value of a cell
(say G12 on a series of worksheets) to a newly created sheet "Summary".  The
code (so far) is below, but far short of what I want to acheive. Can someone
help me?

I have a web server that allows a user to download excel files, these
files have a autorun macros that format the sheet on load.
The problem comes when the excel macro is creating a pivot table the
message

Hi there,
I was wondering if you guys can come up with a easier and quicker solution
to work with ranges in Excel.
For example:

Hi dose any one know how to ckeck if two or more cells are true and then
return a value e.g if one cell = 10 and another cell =20 then return a value
of another cell or what ever it needs to be

Is it possible to delete rows automatically with specific criteria? Say I
want to automatically delete all rows that have a value of 0 in row c. Thanks!

I am having difficulty pulling background and font colors from one workbook
to a linked workbook... I have individual "weekly schedule" sheets for each
employee, and link them to a master timesheet which pulls only certain
information over to be used in scheduling meetings.... ...

I would like to convert a column of dates to be just month and year

Can I place "Text" in the "data items" of the Pivot table?

I am currently using Excel 2007, and was able to create Pivot tables without
a problem. However now when I highlight a range of data and click on Insert
pivot table, there are no fields in the pivot table list for me to create the
table.

I frequently need to calculate standard deviations (and standard
errors) in my spreadsheets.  I can input the functions manually, but
wonder if it is possible to put a custom standard deviation button
(linked to a macro?) on the toolbar, thereby saving a lot of mouse