Search results for query: *

I have a table with Column A setup to show topic number. I have about 25 topics listed in table but when I insert row, numbers stay same. I have to go and renumber all rows after I insert row. Is there a way to do this so that when I insert row, it will automatically update row numbering and...

Does anyone know if it is possible to have, if cell for example c8 has letter "C" then to hide that row. Or is there any other way it can be done so that if cell contains data then to hide row automatically.

Does anyone know why when I have excel file open where I link my X-Axes that shows dates from another excel file that have dates shown in one column, if I have both files open, dates show no problem. When I close the file where I link from, then in my file where I have chart, X-Axes date labels...

Can someone please help me. Thanks in advance. In Excel I'm using click button to have "Open File" window come up. I would like to do, when I click button I want "Open File" window come up always defaulting to same folder and I then I will select file I need. Right now I have...

Can someone please help me with this, I have two tables that I want to create scrap collection for 2 parts. I want to make form that would have date which would be same for both parts since I'm checking for scrap same date for 2 parts. I want to have same reasons for two parts for scrap. Here is...

I created table named "A" that contains: FIELD NAME DATA TYPE Date Date/Time Length Number Width Number Height Number I would like to create another table "B" that will have FIELD NAME linked to "A" and number will be different...

I have a sheet that I need to have check boxes for different fields. I wanted to know if I can insert check box so that if I finish something, I can double click and have checkmark to be put into that box. Thanks.

Can someone help me? I have cell "C1" reserved for date and "C2" for time. I want to put formula in cell "C1" that if there is number in cell "C5" then place today's date in "C1" and time in "C2" for current time. I want to copy this...

My question would be a little long. I have from cell A2 to A50 numbers. In cell B2 to B50 I have formula that calculates SUM of some cells. In Cell C1 to N1 I have January to February. Now in C2 I have formula that says if A2=1 (1 for January) then type B2(SUM formula result in B2), in C3 if...

My question would be a little long. I have from cell A2 to A50 numbers. In cell B2 to B50 I have formula that calculates SUM of some cells. In Cell C1 to N1 I have January to February. Now in C2 I have formula that says if A2=1 (1 for January) then type B2(SUM formula result in B2), in C3 if...

I have in cell A1 a date 1/15/02 that I entered, so I used "Format Cell"--> "Number" Tab and I choosed "Date". Now in cell B1 I want to show month January and in cell C1 I want to show number if January then 1, 1-12 according to month. I tried to use IF command but...

I have linked files under one folder. When I open one of them it askes me if I want to update linked files. Is there any way to make it update automatically all the time without asking this question. Thanks for help.

I have over a dozen files saved under one folder and one of the files contain links to rest of the files. Each one of those files reference back to each other. When I click on any of them I have a question pop up "The workbook contains linked files...& To update linked files click YES or...

I have 50 files saved under one folder and each file has password protected sheets. I was wondering if there is any way to unprotect all those files without going into each file and unprotecting worksheets individually. Thanks.

I have 50 files saved under 1 folder. File number 50 has some cells that automatically update to what I type in file 49. When I open one of these files they are password protected. My question is: Is it possible to add some information in File #1 worksheet and get this information in the rest...

I have asked for help and got answear but it was not what I was looking for. My question is: Lets say I have in cell B1 calculation (SUM A1:A10) that would give me a number if data is typed in data range and #N/A if data is not available. What I wanted to do is to type in cell C1 the formula...

I wanted to know if its possible to write formula to calculate in one cell and place that formula result in another cell. I also would like for the output cell to be empty so that I can type something there. ex. A B C D E 1 20 2 10 3 15 4 Write a formula...