Search results for query: *

Hi, I was working on a macro in Excel yesterday and I lost the macro. I know that I saved my macro but I had few excel files open and I did not save some of them. I think that what happened is that I might have closed(without saving) the excel file containing my macro without noticing it. Is...

Hi , I have a list of dates : e.g. 31/12/2003 31/12/2004 01/04/2006 24/04/2006 11/05/2008 21/05/2008 I need to count the occurence of each date (just for months/year) the result should give me: Project date Results 1 12/2003 1 2 12/2004 1 3...

Hi, we built a hierarchical flexgrid following a step by step book that showed us how to connect that mshflexgrid through data environment which works. For now, the felxgrid shows all options of a products but we need to show the options of a specific product only when that product is selected...

Hi, I have 3 check boxes of products (A B C)and a flexgrid besides it. I have a table in access containing information of those three products. (e.g. PRodID: A11 A34 B45 B45 C3 C4) where the first letter shows which product it is linked to. When I click on one check box, I need to select only...

HI How do you set the column width in the hierarchical flexgrid with custom column headers?

Hi, we built a product form that is linked to access(2000)using ADO. WE created a combo box that shows the list of products. (this part works) Every time we choose a product on the combo box, the description of that particular product should appear on a text box. (this part doesn t work). We...

Hi, I think I have seen a post on this topic before but I was not able to find it and I need to do it very quickly, if someone could help me please. I have three columns containing numbers. I want to do a conditional formating for each row (3 cells) to show the greater number in red, the middle...

Hi, I have an excel sheet in which there are data. For a specific purpose, I need to make the target cell to 0 while changing another value. I used the goal seek and this works fine. The problem I have is that I need to use the Goal Seek for almost all cells in an entire row. And I need to do...

Hi, I have an excel sheet in which there are data. For a specific purpose, I need to make the target cell to 0 while changing another value. I used the goal seek and this works fine. The problem I have is that I need to use the Goal Seek for almost all cells in an entire row. And I need to do...

Hi, Would it be possible to teach me what the indirect function does and how it works? can you for example explain to me what this formula means with the indirect function? INDIRECT(ADDRESS($G182,COLUMN(C$174),TRUE,1)) thanks in advance!

Hi, I have two sheets. I want to do 2 vlookups or anything similar from 1 sheet to the other. ex: if sheet1.colA and sheet1.colE = sheet2.colA and sheet2.colD do something (both need to be true in order to do something) else don t do anything I know I could add a column in both sheets...

I have three formulas with three unkown variables and I want to solve it. People told me to solve it by using solver in excel. Does anyone knows how?

Hi, my excel sheet looks like this A B C 1 cie name product status jan04 feb04... (through 2007) 2 X XZ shipped 1 3 3 order 5 6 4 delta X X 5 Z YY shipped X X 3...

Hi, In my database, I have many queries and tables dependent to one specific table. The problem I have is that that specific table needs to be changed. Is there a way to automatically replace that table in all queries by another one without having to go through all queries to change it manually?