I wish to populate formulas in cells A2:A20 in Sheet2, the formula's in each
of these cells is simply a reference to Sheet1 A10; A19; A28 etc.
I can't just copy whatever I enter in A2 Sheet2 down as it "skips" 9 rows
each time. Could I use a simple Offset formula for this and ...

I have a load of CSV files which are mp3 tags written from a program I
use. I would like to import or drag and drop them into excel all at
once. They are seperated by a semi-colon and have to go through the
tedious task of importing them individually and then click the

Hi folks. For the sample data below, columns A – C contain survey response
data: 3, 6 and 9. I'm looking for advice on writing a function for column D
that would look at columns A – C and return the # of the column containing
the min value (e.g. A in this example). Thank you in ...

Please forgive me if this is something that has been addressed befor
in a thread.  I did a search and had no luck :(
Here is my problem:  I have an Excel worksheet that I need my manager
at work to complete and send to a few people.  They always forget t

I want to do this:
A                                                B
Pay to 23 people 2006               Salery
Pay to 10 people  2006              Bonus

Some of the data I enter is 12-15 key strokes long.  Many of these
entries are the same.  Are there any shortcuts available, that allow me
to reduce the typing required to enter this data?  Thanks

Currently, I am working on a spredsheet to help track business accounts for
my business. Across the top 4 rows, I have columns where people can input the
information regarding the accounts. Anyways, is there a way to have those 4
top rows stay when someone scrolls down the list ...

it seems as though the office assistant was not included on the 2003 program
and i have not been able to find any updates to add the feature.

I WISH TO SORT THE FOLLOWING DATA:
1001
1001P
1002

I am creating a spreadsheet that several different people (who all want to
see different aspects of the spreadsheet) need to use. I want to be be able
to use the autofilter so that the various people can easily and quickly zero
in on ONLY the information that they want to see, ...

I try to copy some figures from an internet homepage,
but when I copy them into my worksheet for calculation, Excel does not
recognise them as numeric and #Value error message appears in the formula
cell.

My bank has recently changed its website presentation.
I normally copy and paste data from my web bank account page into an excel
spreadsheet. The data in three columns contains date, text, and amounts in
numbers. Now however, I can format layout, text etc but for some reason the

Is it possible to color code a tab in a workbook based on a condition?

I am setting up a combination project management and financial spreadsheet
for a builder.  I want to calculate the ending date from the duration days.  
If I put in Monday, 6/12/06 and add three days, the result is Thursday,
6/15/06.  this is as if it is adding 3 days from the end ...

I need help with some macro coding, as I am new to it.
Here is the basic breakdown:  
I have 50 rows of data space.  
Some rows do not have date.