I have a user that tries to load a 6.24MB Excel spreadsheet that takes "an
excessive amount of time to load". The spreadsheet in question is stored on
a remote file server on a different subnet. I already know that, in this
particular case, the 2Mb WAN link (MPLS circuit) ...

there are 3 sheets in an excel spreadsheet say the names are 1,2 AND3
layouts ar ethere for all 3 sheets.
the first sheet is used as input and based on certain fields , columns in
the first sheet i need to populate entries in the second and 3 rd sheet.

First of all i want to thank people who come here and help others.
I have posted a few questions and have many nice people help me.
Now for my question: I am confused. I just started a few days ago
learning to do some VBA. I noticed that when i create a macro in VBA i

I wonder if some one can tell me what is wrong with my code?
I am having problems with the first line? I looked online and i
thought my syntax was correct?
Andrew

I have a worksheet with 4 columns.
Column A = Product Family
Column B = SKU's
Column C = Attribute Metric

I need to check two conditions in a cell and then return the value if true or
false.
I am using the IF function, but not getting thru the second logical
condition to be applied.

I have a list of data on one worksheet called raw_data coming from an
external HR database
example below:
Month    Site            Hire Date            Name    Employee ID

Can anyone help with this.
For c = 1 to 4
  cells(1,c).formula="=counta(a2:a10)"
next c

I have a string of numbers, but they've been entered as:
357,041
332,224
341,038

Is there a way to create a query which can then be run by another user on a
different pc?

I just got a book called, Excel for Chemists. But it didnt tell me
something i want to know.
I wonder if someone out there can help me?
Here is the problem, say that i have put some data into a worksheet.

Hello, I am wondering if anyone else has had the problem that I am having.  I
am using Sharepoint Services 3 as well as Excel 2003 and when I create a List
in Sharepoint with "Person" fields that show network user smart tags.  I
attempt to export the list into Excel and when I do ...

Good day.  New to posting but I review the newsgroup all the time.  Great stuff.  I have a client who buys lists.  We need to be able to count the number of contacts on the list, divide between the number of sales people and then assign that number of contacts to each salesperson ...

Hi Group,
I have a spreadsheet that runs over a corporate network which is used
by a number of different people.  A problem that has plagued it from
time to time is that the sheet shows as locked read only when no one

I have used the formula below to work out the amount of hours from a start
time to a finish time for each day.
Start - Finish - Total Hours
=TEXT(D3-C3,"h:mm:ss")