I am attempting to save a worksheet as a CSV or TXT file to import into
another program. When I attempt to save as the nly file options presented are
xls or all file types. I save the file with a csv extension.
When I attempt to import the file it is not recognized as a CSV. Save ...

(This has been cross posted to the VBA group as well)
Hello,
I am just learning VBA and macros in Excel so forgive me if this is a
simple mistake.  I am trying to automate a pivot table and have been

I am trying to build up "If " function. When I cross 8 number of 'if'
function then it return error message. Need proper suggestions.

A                            B                                      
    C
1 Walla Walla    =MATCH(A1&"*",Sheet1!A1:A1077,0)
=HYPERLINK("#sheet1!A"&B1,"GO TO")    

Hoping someone can help. I use a Financial loan application called Tvalue. T
Value includes a feature to export data to excel. Tvalue uses the same date
format as my OS settings, so in AUS is dd/mm/yyyy.
When you export data from Tvalue to excel, the date changes to mm/dd/yyyy

While attempting to use VLOOKUP THE LOOKUP VALUE IS 12345  the column that
has the list of values to be looked at has  '12345 so it is not recognized
and I get NA. The table I am working with has the ' attached to all of the
entries in that column.  Is there any way I can get rid ...

I have 3 xls ex: exl1, exl2 & exl3, any data entered in exl1 of column  A
and data entered in exl2 of column D to be automatically added in column A of
exl3, kindly help pls........
TIA

I need divide a list of 500 lines into groups of 8 and assign a number or
name to each group

Good day!
Is this possible to do programmatically?
Thanks.

I select a range (e.g. A6:Z267) and then apply the auto-filter. However once
the filter is applied it has picked up down to row 269 - i.e. rows below
where it should have stopped. How can I fix this?
Thanks

I have a spreadsheet that has data in a column of cells that have both
numbers and letters (ABCD 123456) that shoud match data in one of two tabs in
the same worksheet. What I'm trying to do is have a forumla look at the
information in the first tab match it to the same matching ...

hi.  i want to merge many rows in to one cell.  there are many names on
companies i want to display in a flowchart and want to be able to take the
individual rows and make them one cell so i can wrap the cell and format to
the left

I have columns A through F.  Each column has 26 rows with inventory items
(text).  When I try to sort it, it sorts BY column A and the other columns
remain unsorted.  Apparently, I can only sort each column separately but I
need the items in ALL of the columns to be sorted ...

When I click on a cell in Excel 2007 several cells get selected.  This is
freaking me out.

Is there a simple way to do this besides CTRL and the Row everytime.  I have
about 2000 lines?