I am looking for a way to combine the data from many worksheets in
several (about 30) workbooks.
My employer requires me to record my activity for each client using
excel workbooks which has separate worksheets for each product.  The

hi,
I have a custom commandbutton. On click of this commandbutton I need to add a Char '@' to the current cursor location on the Excel Sheet. While using range Interop object I m able to replace the current cell data with the above char but I need to append it.
Could anyone help ...

I was just wondering if there is an easy way to change all uppper case
letters in cells ins spesific range to down case?
-Sirritys

I am studing Excel online but the practice templates will not download; I am
following a hyperlink to the page
(http://officebeta.iponet.net/en-us/templates/axinstall.aspx?FromArea) but
told this link is incorrect ; This program is  MS's Office beta program so I

can I enter a day into my date & year and then drag to auto fill if so how?

Does anyone know how to export an Excel spread sheet to  a csv file using
"|" as the delimiter instead of ","?

I want to be able to copy a csv file into a single cell in an excel
spreadsheet. I then want to apply a formula to various cells which
result those cells being automatically populated with relevant data
from the csv file when I paste it. The formula needs to take into

I get spreadsheets that have numerous (superfluous) tabs that I must delete
every time before I present the data.
When I record a macro to delete these tabs and then execute it, I still have
to respond to the dialog box - " do you want to delete this worksheet as it

How could I determine the average of work orders that are received per
business days in a given month? I have two columns: Column B lists a unique
code for each work order and Column C lists the date in which each work order
was created. I don't receive work order every day, but ...

i have a column in excel that has people's names. i have sorted the
whole document to be in alphabetical order, by name....what i want is
to capture one entry of each name...so for example now i have something
like:

With the captioned formula in D1;
A1=1, B1=1, C1=nothing;  D1=False.
A1=1, B1=2, C1=nothing;  D1=True.
A1=1, B1=1, C1=1;  D1=False.

I live in Ecuador, here we use centimeters for paper sizes and margens. So I
need to change the original inches, to cm.

I'm using Excel 2000 at work, and I've got data in colums, which has to
be transposed to rows on an other worksheet, with a "=" function (so no
copy/paste special - transpose). I input the first 3 cells manually,
then select them and try to autofill the rest of the row. No go...

I have a spreadsheet With speedometers on it and I want to add a scrollbar
to make the Speedometer move.
I inserted the scrollbar and when I right click the scrollbar and select
edit, I can make the speedometer move. any other time when I try to slide

Okay i have an Excel Spreadsheet with 3 Sheets inside this. 1) Summary
Sheet: is what i would like ALL the data to go to once i press the
Macro Button. I'd like it to Capture all the Data from sheets, 2)
Sheet1 & 3) Sheet 2. Please refer to the Attached Zip as this explains