| Thread | Last Post | Replies |
|
| Hide Rows in one W/S Based on a cell value in Another W/S | 14 Dec 2006 12:52 GMT | 7 |
Hide Rows in one W/S Based on a cell value in Another W/S I have the following code in an excel spreadsheet (see below). The code correctly hides the rows when C98 in one worksheet = "Dog" but when C98 does not = "Dog" it does not unhide the cells on Sheet Blue.
|
| ASAP Utilities (Free Download--Very Nice) | 14 Dec 2006 11:12 GMT | 1 |
I'm sure most of the higher echelon people here know about this little utility, but for those who don't I wanted share this with everyone who doesn't have it. I've got a lot of good, fast and friendly help here, so if I can contribute a little something then so much the better.
|
| Excel Formula using relative position of cells in two different worksheets | 14 Dec 2006 03:36 GMT | 1 |
I want to know how a certain Excel formula would be written. Excel formulas reside in cells computing the value of the cell content. A given formula can be entered in an entire column, producing different values in each cell in the column in which the one given formula is
|
| How can I highlight a cell or row or column in excell 2007? | 14 Dec 2006 00:10 GMT | 2 |
I am using excell 2007 beta and wanted to highlight a row so I can organize the group/s in each different colour, but I could not find the highlight. How can I find the highlight, please?
|
| Cannot open Excel files. | 14 Dec 2006 00:05 GMT | 2 |
i cannot open any excel files directly from there location. When i try to access the file, it will open the program to the point just before the workbook is about to be displayed and hangs. No error messages are created and the system does not hang. I can however, open excel ...
|
| How to determine the what quarters are between 2 dates | 13 Dec 2006 23:04 GMT | 5 |
I need to determine how many days fall between a start date and an end date. I am actually able to find that information, but how do I take that total number of days and determine how many days (of the total) fall within Q1, how many fall within Q2, how many fall within Q3, etc.
|
| losing spreadsheets | 13 Dec 2006 23:02 GMT | 2 |
Hi y'all, At work we're sharing a spreadsheet with everyone saving on a regular basis so everyone can see the updates. Unfortunately, the spreadsheet keeps getting damaged.
|
| Turn off chart | 13 Dec 2006 22:28 GMT | 8 |
I created a worksheet for a friend to record receipts. He hit the F11 key by mistake and was presented with a chart. Well, try as we may we couldn't get back to the sheet I created. In the end I had to delete the xl file and reload a new copy and re enter
|
| occurence count | 13 Dec 2006 21:23 GMT | 6 |
I've got a row representing 31 days in a month. If a worker calls in sick, the hours missed goes in that cell. That could be any number up to 8 hours. That absence may carry into many days.
|
| Bloomberg add-in anomalies | 13 Dec 2006 21:16 GMT | 2 |
A discovery was reported at work today: a user has the Bloomberg add-in (http://about.bloomberg.com/software/index.html - the DDE Server and Excel Add-Ins file) installed on his computer, and Excel seems to have been affected in two ways that he's noted so far:
|
| XIRR question | 13 Dec 2006 19:44 GMT | 5 |
I have the following numbers/dates in an excel sheet A1:D3 1/1/2007 1/1/2008 1/1/2009 1/1/2010 $ (10) $ 1 $ 2 $ 20
|
| HYPERLINK OPEND FILE WITH WRONG VIEWER | 13 Dec 2006 17:19 GMT | 2 |
Excel 2003 (11.5612.5606) XP-Pro SP2 I have cells with hyperlinks to various small .JPG nd .GIF images located in a folder different from the worksheet. For well over a year the images have been rapidly opening with a lean, mean viewer
|
| header and footer in excel 2003 | 13 Dec 2006 16:55 GMT | 2 |
I want try setup repeat row 1 to 4 for header and repeat 64-68 for footer. How can setup , pls advice. That mean every page show this header and footer.
|
| Looking up data in various columns | 13 Dec 2006 15:09 GMT | 1 |
It is possible to do the following: Column A Column B Column C Column D Column E 123 456 No 789 Yes
|
| Creating dynamically arrays, is that possible in VBA? | 13 Dec 2006 11:37 GMT | 3 |
I would like to do the following, but I am not sure it is doable in VBA. I saw it in Php, so I have a little hope it is. I have a spreadsheet full of range names. They are all of the form "S1.Name3.Subname2". Basically I would like to load in VBA all the
|