| Thread | Last Post | Replies |
|
| Create "a thing" that shows vba code running | 10 Nov 2007 11:35 GMT | 7 |
Is it possible to create "a thing" that shows for the user that some vba codes are running? For example, I have four vba codes and it takes a few minutes to process, but the user can get confused if it is working or not.
|
| Auto fill multiple worksheets | 10 Nov 2007 09:34 GMT | 5 |
I have created an Excel Workbook, made up of numerous Worksheets. These worksheets are used to record daily information, at various locations, for bi-weekly periods. One cell, ‘J3’ is used to establish the beginning date of the period. The first date of the period is ...
|
| How to change default zoom Excel 2007 | 10 Nov 2007 05:19 GMT | 10 |
I have a large desktop and would like to change the default zoom to 75% when I open a new spreadsheet. I can't find where to do this. I have Vista and am on a network. I thought the secret might be to modify book.xls or some default template but I can't seem to find it. Any ...
|
| Copy from one list to another in different time scales. Confusing? | 10 Nov 2007 03:22 GMT | 2 |
Would anyone know what type of code to use so that it copies 1981q1 into Jan 1981, Feb 1981, Apr 1981 and then moves on to 1981q2 and copies the value there to paste it into Apr 1981, May 1981, and Jun 1981....
|
| calculating pay rates for different times of the day | 10 Nov 2007 01:58 GMT | 4 |
hi there i am new to this so please dont shout at me,i'm using office 2007. i'm after an easier way for me to calculate my pay i work odd shifts crossing over time zones. what i'm needing is to be able to calculate different pay rates.
|
| Hide column is empty, not including header (row 1) | 10 Nov 2007 00:27 GMT | 3 |
I'm lost on this one, but I'm sure there is simple macro code to do this. I need this in a macro as I'm massaging data that beyond removing empty columns.
|
| if creteria is not found | 10 Nov 2007 00:23 GMT | 5 |
I need help with two questions I have the following Column A 1 PASSAIC CNTY N J Callable 06/08@101
|
| Cell contents? | 09 Nov 2007 22:23 GMT | 10 |
Is it possible for a cell to contain a numerical value, which is used for various calculations, and an alphabetical designator that prints but does not affect calculations? Example:
|
| long cell spilling into next cel | 09 Nov 2007 22:18 GMT | 1 |
I have a cell with about 30,000 characters of html code, I removed the line breaks, but when I save the file, either as xls csv or to tab delimited, then reopen, some of the characters appear in other cells. How can I prevent this?
|
| Function to display formula in specified cell | 09 Nov 2007 21:08 GMT | 2 |
I am trying to display in a spreadsheet, the formula in an adjent cell. Any suggestions? EXAMPLE: cell A2 contain formula: =Mid(c3,5.2)
|
| Replace Defaults | 09 Nov 2007 20:12 GMT | 1 |
I'm sure this is something amazingly simple that I need to change, but I've never come across it before and I can't find it in the Help. Whenever I pull up Replace, Match Case and Match Entire Cell Contents are automatically checked now. How do I change this? Thanks,
|
| How can I assign a data for one cell from another fixed cell? | 09 Nov 2007 17:46 GMT | 3 |
I can assign data to one cell by put formular, for example: =H5. But if I add a row, my cell will get data from H6, Excel automatically modified my formular to: =H6 And now I want the data always come from =H5, no matter how many rows I add
|
| Microsoft Excel | 09 Nov 2007 16:14 GMT | 11 |
I am quite impatient and would like to watch a tutorial on excel that takes one through the basics to advanced spreadsheet management. soes such a thing exist?
|
| Doesn't anybody else have this problem with Excel 2007??? | 09 Nov 2007 15:58 GMT | 3 |
Excel 2007 kicks into Autosave on my PC, and basically, the CPU goes to 100%, and Excel is unusable until autosave is done. This actually is taking 5+ MINUTES!!! Its a real hassle, drives me up the wall! Cuts significantly into my ability to get work done, when i have to ...
|
| Would like an explanation of a formula: | 09 Nov 2007 15:52 GMT | 4 |
=("1/1/"&(IF(LEFT(DQ10,4)*1<20,2000,1900)+LEFT(DQ10,4)))+MOD(DQ10,1000)-1 The other day I needed a formula that would change a Julian date to a calendar date, e.g., 2006031 to 01/31/06. I googled the question and found the answer, for which I am grateful, in a formula provided by ...
|