I have two sheets, Roster and Skills. Both sheets have a name column that is
identical. I want to pull data from the Skills sheet and put on Roster sheet.
The following code works:
Sheets("Skills").Activate

how do i call the data table function in VBA?
Thank you

I have a macro that copies a range of data from one worksheet to another,
then saves that worksheet as a CSV file (comma delimited).  The macro repeats
this process for 4 worksheets, copying them one at a time to a worksheet
called "temp" and saving each one with a different name ...

    I am trying to set up a tracking schedule for vehicle repair. I need to set
a time line to track initial work, when to order parts, when to schedule the
work etc. Basically I want column A to be the start or work request , all
the way to column J to be the start of work. In between ...

Is there a way of synchronizing on demand a local folder with a server folder
from within Excel ?
oldjay

I would like to be able to filter a sheet based off of two columns in
VBA.  If I run the following one at a time I can filter based off the
one column, but if I run them both it will not work.
Worksheets("Master Index").Range(Cells(12, 42), Cells(65536,

Is there a way to load an Excel spreadsheet onto a website in such a way that
people who don't have Excel (or at least an up-to-date version of it) will be
able to open and use the file?  Specifically, what I am thinking about is to
create an order form blank for an on-line ...

I have an excel vba macro that uses a collection to store some string
data. The collection 'key' is a string that is shown in a listbox. (as
below)
When accessing the 'Item' property, I get the runtime error: "Object

I have big excel spread on the columnA has duplicate name, how can I run the
scripts to fix this problem.
Thank you so much
Lillian

Say I have a "Name" column which could have someone name like "John
Davis" or "Adam John Nelson"
Now, I want to use "IF" statement so that any name has the word "John"
be considered.  For example, using the above example I want to get the

Hi All......
I have two macros, the first one works to delete rows if a cell in column H
is empty.
Sub DeleterowsNONAME()

I am new to macro....pls tell me some common terms and languge of macro

How can RED color be made driendly to some? You know, sharp colors are
not okay to some. So, how can that be fixed in Excel?
I want it as redish as possible but not sharp red...
Thanks,

Im having problems with the code below displaying the text on one line.  E4
is reference to a date i select in the worksheet.
       .htmlBody = Format(Range("E4") - 2, "mm/dd") & "  ECCR (Daily, MTD)"
& _

I've learned that after inserting a picture into my spreadsheet (which I am
creating in a VB.Net program) I have to adjust it's size.  So I recorded a
macro to so and ended up with the following:
Sub sizepic()