I am importing a csv into Excel (Excel 2000) which will have a
varying number of fields in the imported file.
  I can loop over a particular row to get the first blank cell in
this row.

Hi - I wrote a similar query yesterday but I don't think I explained myself
very well.
What i'm doing is creating a Excel Spreadsheet, with 2 tabs - one which is a
datadump with a large amount of information E.g Name, Customer,Date,Location.

I have a CSV file which data extracted from a backend database.
I noticed this CSV file when open in excel 2003 on different machine give
different result.
The raw data  of the CSV file, the text for one particular cell consists of

Is it poossible to let the user enter a value in a cell that already contains
a formula?Like if i am reflecting a value in the Cell A13 from any other cell
& have used a conditional formating on Cell A13 depending upon the value that
is been reflecting to Cell A13.Now Cell A13 ...

Good morning, can anyone tell me how to save a Recorded Macro to be used
later on a different workbook.

I need time sheet macro.
Suppose one user starts his work @ 8 ,
Here is what I need ( Step by step)
1. before user starts working need to click the button, in just single

i have an excel file.(.xlsm 2007)
i have no problem while opening it.
some people in my group got a message that the file have unreadble content,
need to recover. for other people this message does not appear.

i am used to closing excel 2003 with a single click to the upper right, red
X, which would then ask me if i wanted to save changed workbook, and then
close program .
in 2007, i am finding that it asks if i want to save changed workbook. then

A follow-up to my previous question.  I would like to sum from cell A1
through cells in row 1, column A + indirect(example number).  I am unable to
use the string =sum(A1:address(example code)) because the sum function will
not allow address() as an argument.  Suggestions?

I’m using this formula below but when I try to drag down the formula row B45
& B46 is moving down as well, when actually it should remain in B45 & B46
only B8 should be B9 C8 should be C9 and so on.
=(B8=$B45)*5+($B46=C8)*(($B46-4)+(B8=$B45)*(9-C8))

I'm using VLOOKUP and the value being searched for in the table array covers
4 rows (ie header "April" - search value - is in merged cells A12:A15). So
when I enter "return value in column 3(C)", it returns the value in the
highest row - being cell G12. As there are 4 different ...

I know I read about how you can save your custom macros and toolbars in a
specific worksheet instead of globally in your Excel environment.  I can't
find how to do this now.  Any help would be appreciated.
Thanks, Pat

Currently have an excel workbook in a shared network drive in which multiple
employee has access in retrieving and make changes.  There are a few
employees when they open the workbook it is a "Read Only" file.  Tried
everything from looking at properties to make sure read only is ...

Can I make the CountIf function conditional by preceding it with IF as follows:
=IF(O8:O264

This formula doesn't work, but you can see what I'm trying to do.

I have a pivot table based on an access query.  It gives sales by month and
then a total by customer.  The totals by customer vary from $100 to $100,000.
I want to be able to somehow filter out amount based on a dollar amount that
I type in.  For instance,  I only want to see ...