I have a row that contains monthly results and I want to select the last monthly data entered.
So in the below example I would want to look for 2007 and select all of the rows with the data below ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Hi,
I'm trying to make SQL.REQUEST work with my mysql database server, but i can't get it started. When i use the simple "Import data function" method with my mysql DSN the connection/DSN workes...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 03/23/2004 Grade: B Views: 17
This is an odd one.
One of our users has a spreadsheet that is about 35mb. It takes about 15 mins to open. It has no external links, and doesn't really contain that much data, although it does...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/12/2005 Grade: A Views: 0
User cannot edit map in the Excel sread sheet. He wants to update this attached map in Excel 2003 and cannot. This is urgent, please help.
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 04/14/2005 Grade: A Views: 0
I am using Excel 2003 and have a Module which is regularly added to and ammended on my local machine for distribution to five other machines. The ammended module is exported to a folder ( G:\Latest...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/29/2005 Grade: A Views: 0
How can I sort a column based on the cells color?
NOTE: !!!!! the cells color was determined by conditional formatting. !!!!
I've tried to determine the color index of the cells to included...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 12/05/2005 Grade: A Views: 0
I currently have several sheets that are linked. The problem is that when I move the folder group the links break.
How can I make the links global like this.
..\..\My File.xls
The sheet i...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 12/17/2005 Grade: B Views: 0
I have been given the task to evaluate 4 columns in one workbook with another 4 columns in another workbook. The problem is that if it finds a match in any one of the 4 columns I want it to return...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/24/2006 Grade: A Views: 0
i am looking for the vba that would give me the sheet index base on a sheet name the user enters and vice versa.
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/28/2006 Grade: A Views: 0
Excel 2003
I need some unique way to keep data from overflowing into the next cell.(can't use wraptext)
I have a function listed here: BUT IT NEEDS REVAMPING
'====================
Sub PutA...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 06/28/2006 Grade: A Views: 0
