I have built a report that links multiple pivot tables to various access queries, it is working exactely as I need it to. Only problem now is I need to change...

Hi, I need to have a function that will search a given worksheet (or a range of cells on a given worksheet) for a string and then report back the cell name...

I want to format a code like this: ##.0001.## so then i push it down and gives me 0002 and so on, the other ## r numbers. The problem is that when i do that,...

Is it possible to get the contents of a cell and have it posted (visible) to your desktop? I don't need the whole sheet, just the contents of a single cell.

Is there a way to have a worksheet automatically change to delimited text to columns when it opens? Thanks all, Vato --- Message posted from...

First I want to thank evryone that has helped me in the past. You guys are great!!! Here is my problem: in column A I have all of my route numbers for...

i wrote this macro to create a chart with multipul axes and it works great. then i tried to run this as a subroutine using a for loop and i get 97 graphs (just...

Ctrl+A macro fix for problem in Excel 2003 ------------------------------------------------------------- Restore normal Ctrl+A before risking your data. ...

I have a cell that has been concatenated, joining cell A1&A2 where A2 is below A1(in same cell), ex. Madeira Exotica 111.1111 I want to put 111.1111 bigger...

I want to print a sheet columns A:N (rows vary) 1 page wide with pagebreaks at certain rows (91+n*90) eg 91,181,271 etc but am having trouble with old manual...

I'm trying to enter an amount in a Column labeled "Limit"...I've tried changing the cell's format but no matter what I do, the data shows up as ####. How can...

Dear all, I built a file that imports data from an external source (excel format). The code that I wrote does not only import the data but also adds...

Here's the problem I have w/ autosave - suppose I open somebody else's workbook on the LAN and maybe start changing some things. If I have autosave turned on...

Is there a way to have macros update when you change the sheet. For example: If you have a macro that does a sort and you later add rows the macro doesnt seem...

How do you execute a Macro on loading a worksheet (that is, without having to click a button or cell)? --- Message posted from http://www.ExcelForum.com/

Is there a feature in Excel that identifies duplicate numbers in a column? I have a worksheet with about 1200 lines of data, and I need to identify all lines...

I have a bunch of text with a trailing blank. How can I get rid of them? In MS word there is the ^p to indicate the end of the line. Is there something like...

I found this on David McRitchie´s site on how to do a three way lookup =INDEX(data,MATCH(A10&A11,A3:A8&B3:B8,0),MATCH(A12,2:2,0)) Where A10 contains variable...

I hate the way Excel opens spreadsheets you double-click in Explorer in the same instance of Excel that is currently running. I want to change it so that it...

I want write in a collumn (1) 1000 and this number appers in the collumn (2) beside written for extense. Ex. | collun 1 | collun 2 | | 1 | ONE |