I need to check an array for the most recent date, then return the text contents of a cell at the head of the column which contains that date, concatenated...

Hi Laila! Try this in your macro for the drop down list: Sheets(Range("A1").Value).Select Where Range A1 is the the linked cell from your drop...

OR Just select the column with the leading, hidden apostrophes, and simply open and close "TextToColumns". Select the column. Data TextToColumns...

Hi, I have recently start a macro to run on a daily basis. It is to take data twice daily from an internet site and then intup this data to a table in date...

Hi all, I'd be very grateful indeed for any help with this problem! I have a range of times in column A and corresponding data in column B. Several data...

I am new to excel but have worked with speadsheets (MS works) I need a formula that when I enter a team name into cell A5 it automatically inserts the team...

I am using the DSum function in a spread sheet to extract partial information from a data list I created according to the criteria set forth by me in the DSum...

Does anyone know how you calculate the nth root of a number in Excel 2003? I want to calculate the annalized percentage rate of return from a table...

Hi, It has been a while since I have used advanced formulas in excel and i am having some difficulties so any suggestions would be appreciated! *The...

I did have this working and now it's...

Good day everybody, I would like to know how do I make the Pivot table in my Excel file auto-refresh data when the file is open? This will ensure that my...

I really appreciate your help with this but it gets a liitle more complex. Here is the breakdown: We have more than 2 market segments that will base our...

13 teams, saved team players in pivot table format (also first time user for pivot...

I am using Excel 2003. I have created a spreadsheet that will be shared with other users.There is a particular column in the workbook that displays an order...

Hi, I found the following in the Help file which I think explains a problem I am having, but can't find how to make the change it says to make in the...

I don't think I explained the previous question very well. If I have a worksheet and the first seven rows of information I only want 4 people to access and...

Is is possible to give one person access to locked cells and deny another user. I know I can stop them from saving any changes, but I'm afraid if they make...

Thank you very much! Greatly appreciated! :) -- Jettero2112 ------------------------------------------------------------------------ Jettero2112's...

Biff, that works perfect for me, thanks a million. -- scottymelloty ------------------------------------------------------------------------ scottymelloty's...

Hi, I used to be able easily to call Excel functions from outside Excel, like MS Access with a simple statement as follow: var =...