A friend of mine, a Police Crime Analyst has a workbook that keeps data
for each month in a seperate sheet. Each sheet Jan, Feb, Mar, etc could
have different number of rows. They all start at row 14 but could have
20 to over 100 rows.

I have written a visual basic module to insert pictures from a list
contained in a worksheet. I have figured out how to delete the picture
when I load the next picture. For this I need to know the picture
number.

I have a large amount of info on one sheet and I don't want to add it to a
worksheet.  I need it on 1 page.  When I print it, some information is
missing.

I have a situation where I need to fill Column B with Text Depending on what
Text is in Column A eg
       Column A                Column B
     1  GREAPPLES           GREEN Products

I have some functions calculating certain values. All is fine, but all
of a sudden I have this strange #value sign there in the cells which
contains the function to calculate some value. If I click on the cell,
and then hit enter, it calculates fine. However, it doesnt calculate

I have a solution with some projects. I try to open a .xls in a excel
project from windows application project. Note that this solution is in
ClickOnce and i dont know the path of the file.
how i know the path?

My regular Excel file is 29 KB. When I added 2 Pivot Tables and 1
Macro, the file ballooned to 2.51 MB.
I was able to use Zip to compress it back to 34 KB (amazingly). But I
don't want to manually do this all the time.

I have an Excel file that has data in it like this...
FirstName LastName PhoneNumber
mary        johnson      (909) 404-1242
(continued...)

I have a matrix in the following format
1 X X X X X X X X
X X X 3 X X X X X
4 X X X X X X X X

How do I turn the underline key off in excell

How can I emerge an xl document to n number of recipients individually.

I need to do a function that will look for one of three criterion in a cell,
if condition a,b, or c is met, then I need to lookup a person's name and then
assign them to a team. So far I've tried the following formulae, but it turns
up NA or TRUE.

How do I get rid of them?

  if i have some number at column and i want to switch all the numbers to
vertical in one times,how can i do this.
For example :   i have 1 at A1 cell,  2 at Number at B1 cell and 3 at C1
cell, how can i switch/rotate all my data  to A1/A2 and A3 cell?

        I used to consider myself a master of excel until I started
this project and now I am stumped and could really use some help. I
have a friend who needs me to create a spreadsheet that he can run his
whole business on but he doesnt have the funds to have a database