I have data in a workbook that I need to extract into several workbooks. For simplicity sake: data = "Sam, Paul, Ann" etc. How can I extract the data that...

Using Excel 2007 on Windows XP: Monthly I select hundreds of Excel files from Windows Explorer, right click and select Print. It would open an Excel file,...

I was wondering which statistical function would be the best to use when trying to see if their is a relationship between temperature and glacier length...

Need formulae to convert decimal degree (lattitude/longitude) into Degree, Minutes, Seconds format. I have the following: Lattitude data of 0.1741463938 and...

Very good pics please visit 'http://about-interracial-threesome' (http://about-interracial-threesome.abada1ad.info) 'http://acimall-exhibition'...

I created a lot of user-defined functions in Excel2000 and I access them from an .xla file (add-in). I frequently send my workbooks to colleagues using...

Hi, I have an Excel spreadsheet, where I am trying to put multiple results, into a single cell. For example, I have a dropdown selector "Yes" or "No" in a...

Puxa não consigo criar um calendario perpetuo com feriados ! Alguem pode me ajudadar ? Desde de já grato;

I have a column of numbers. Looking for an array formula that will identify and highlite the "highest" three values. Does such an animal exist?

I am a bit of a novice in the workings of excel. I have created database of fungi records from the london area and have uploaded it to my website. It appears...

I copy and paste-special values repeatedly. Is there a keyboard shortcut so that I don't have to point and click the mouse to "Edit" "Paste Special" "Values"...

I have read numerous posts detailing this issue and all the replies have been unhelpful. So hopefully, I can get some actual help for this issue. This issue...

Would like to use data from an existing excel data base for use in a PDF form (W4 - witholding or similar). Can this be done, have had no luck reformating the...

I created a process using Excel 2002 and a step is to break links (Edit/Links/select all links and click 'Break Link') - however, the users only have Excel...

Hello :). I am trying to import a table from a web-page where some of the values are written for example as 7 -35. Using Data/get external data/new query. I...

I have a workbook with more sheets than I can easily navigate through. I would like to create hyperlinks that jump to other pages, but after following the...

Hi all I have a sheet, where I upload informaton - some rows are hidden (parts already in stock) So, when they sort by some coloumn, it shows all rows, and...

I have written an App which runs fine on a Windows PC (Win98 or XP) with 128 Mb or RAM It immediately runs out of memory when run on a Mac of similar spec...

I'm trying to design a worksheet that will import data from other worksheets.. I'm a relative newbie with Excel formulas. The formula that I'm getting hung up...

Any Ideas about what code would read the formula in cell c3 of every workbook in a folder and give an array of the workbook names and...