Search results

Thx for your reply. I'll give it a try and will let you know if this is what I'm searching for. Cheers, M

Hi everyone, Here is my problem: A file is shared by many people. Each of them need to know when an additions/a change is made to the file. The problem is that this file contains many worksheets... Could a worksheet display a summary of all the latest changes since last opening of the...

Thx Luke, I'll check your solution as soon as I can, and will let you know. Cheers, M.

Thx Hui. I'll check this and get back to you ASAP. Thx again and Cheers :) M.

Hi xld, Hmmm... A data sample would require lengthy explanations. So just to try to make it clearer, here is what I'm trying to do in one single formula: - Search a certain value with vlookup - Once the value is found, get the address of the cell that contains it - In order to use it...

Hi, I was trying to do a subtotal that contained a vlookup formula. It didn't work... I realized that subtotal needs a cell reference to function, and not a value... I've tried few things with the Address function, but if I'm right it returns the address as a string content and does not...

Hi Luke, Back from few days off without computers... Actually, you're help would still be most welcome. What you suggested needs to be ran manually... Could you think of something that would auto-adjust the worksheet ? Thx, M.

Hey, Is it possible to have vertical tables headers instead of the "default" horizontal ones ? Thx, M.

Hey folks, Is it possible to dynamically link a table to the content of another table? Here is what I have done: -Insert a table in A1:A3 -Insert a second table in C1:C3 If do this: E2=Table1[Column1] Then it copies in e table 2 the content of the table 1 That's already a really...

Thanks a lot also for your explanation (which I didn't see when I posted the post above)

Luke, Do you think it is possible to make it dynamic and self adjusting? Thx

Yeah !!! It works... I don't have a clue how it does... But it works ! (I have to learn vb !!!) Now, I will have to try to customize it to my needs :) Thx Luke.

Hi everyone, I'm here for my daily dose of help :) This is what I would like to do : If a cell of a specific row return a certain result Then Hide all the following columns For instance: If a cell in row 1 returns 1000 (lets in Z1) Then Hide all the following columns (AA, AB, AC...

@ Hui Thank you so much that's awesome ! @ Luke M: Unluckily I work on excel 2007... Thx though ;)

Really... No one here has an answer ?

I know... Accounting sucks ! LOL Surprisingly, if for instance A1 contains the sum of A2 + A3 + A4, Auto Outline will group the data upward... Therefore it should be feasible manually... But how ??? Any of you have an idea ? Thx, M.

Hi ! When you manually create an outline to group data, it groups rows "downwardly" Lets say you want to group row 2,3,4. If you select those and group them, it will do so on row 5. I don't like it this way... :( Do you know a way that allow to group "upwardly", i.e that would group...

Thanks guys. I found what I needed in Luke M's link. Cheers, M.

Hi everyone, Can somebody please tell me how to consolidate data from several worksheets into one (income statements for several years) into one excel sheet examining the trend by department? They are not of the same format necessarily, I will need the formula to lookup the first column...

I just have (infinity) words to say : Thank you very very very...(Infinity)... much ! Cheers, M.

If you have some spare time, an little explanation of your formulas would be most welcome :-D

Hi Hui, Thx a lot for your quick answer which was right to the point (I edited my previous stupid answer !!!) Thx and thx again. Have a great week end. Cheers M.

Hi everyone, This is my first post here. What an awesome website ! I am sure that what I want is already somewhere in the forum. But I don't really know how "phrase" what I am searching for... So lets go to the point : I have in the following cells : C1, D1, E1, F1 etc... What I want...