Group:  Microsoft Excel ยป microsoft.public.excel

Geek News

Threads Replies Last Post
484 Pages: <<  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  >>  
Keep defined colors in Pivot Chart Report
Dear all, When using this code to refresh in 2 datasheets in Pivot Chart Table for the Chart Reports. Private Sub Worksheet_Activate() ActiveWorkbook.RefreshAll End Sub the colors off my Pivot Chart Report are changing back to original colors. Also when I close the workbook, and open it again, the colors are changing back... before this I tried to use the tab "refresh when open...
2 11/10/2008 4:19:05 AM
Paste Special Link between Word and Excel
First time. Let me know if I am in the wrong site. Is there a way to maintain link when both files are moved to another location? If not, is there an easier way to update than one link at a time? ...
2 11/10/2008 1:40:31 AM
Conditional Format
I have a 5-character sting in all of the cells in row H. I would like to conditional format the sheet to highlight those cells where the third character in the text string equals "D". Is there a way to do this? Any help will be appreciated....
5 11/9/2008 11:33:18 PM
Lookup
Hello I have a huge spreadsheet that has results ranging from 1 to 7 in apx 50 columns . I need to convert them to Letters. 7=A 6 =B etc down to 1 which is G. Amongst that there are decimals which for example 1.2 to 1.4 =G 1.5 to 2.4 =F 2.5 to 3.4 = E etc I tried doing a VLOOKUP but although most of them are correct, there some that aren't and I can't work out why. This is wh...
4 11/9/2008 4:21:06 PM
Problem with price per item calculator that needs to apply volume based prices that stack
I'm trying to build an excel sheet that asks for the amount of lines you have A1 then takes that number of lines and applies one of 3 prices per line, assigning a volume discount based on the number of lines you have the rules are for the first 10 lines, you pay $22 a line (B1) for lines 11 - 20, you pay $18 a line (B2) for line 20+ (up to 100) you pay $15 a line (B3) but the pri...
5 11/9/2008 2:07:22 PM
Help?
Ok this is for all the formulae gurus out there. TIA I have a list in a particular column, lets say column A This is a list of dates I have another cell which uses data validation to reference this list. Say B1 In cell B1 the only acceptable entries are that which are in column A Can anyone supply me with a formula for my data validation which will only allow 8 entries. Thes...
4 11/9/2008 8:54:30 AM
Excel Macro Problem
I have a database with 98 sheets. One sheet for each bus in our fleet. I need to updated the links for each sheet from xls to xlsm without changing the bus number in the link. I used to be able to create a macro to make a change in a few sheets in the old Excel and run it a couple of times until I had changed each sheet. In the new Excel , I try to do that & it also changes the bus n...
4 11/9/2008 8:12:00 AM
Floating Window - Playing with Scenarios
I've got a spreadsheet that comprises about ten worksheets. The spreadsheet allows for about five different scenarios to be reviewed. At the moment to change scenarios, I have to change a cell in a particular worksheet. But what I want to be able to do is have a small window (that always stays on top of the open worksheet) where I can switch scenarios by changing the number in that w...
7 11/8/2008 6:53:51 PM
VBA Excel: Move rows which match a certain feature between tabs
Hi, I have a hughe matrix of numbers. Such matrix has headers in its columns (first row). Say that headers are A, B and C (). What I want to do with a VBA script is to look into the rows to check if what of them have the value "30" in the column header. In such case, I would like to move the row from that tab to another one called, e.g., "Tab_30". An important point is that I need that...
4 11/8/2008 3:55:02 PM
Automatically Changing to Upper Case
Somewhere on one of my spreadsheets everytime I typed in text it would change it to upper case. I have no idea how I did this. I did a Google search, but I coudln't find anything that works without using macros. Is there a way to type in text to a cell and have it change automatically to upper case without using macros? Thanks...
8 11/8/2008 3:46:02 PM
url links not working in Excel
Hi I am having trouble getting url links to work correctly within an excel spreadsheet. I've tried several ways and still cannot seem to get them to open correctly in a browser. Here is an example: http://www.orthohelp.com/upload/problem.xls when I just enter the http://...... portions in a browser they open correctly but when I click on them within Excel, I get a notice the item ...
5 11/8/2008 12:06:37 PM
Simpler function for DA
I use vlookups in a worksheet and realize that if two of the cells in the 20 cell lookup range are left identical (usually by accident), it will find the first one only, which may be the wrong one I'd want to find vlaues for. In order to prevent that from happening, I would like to create an error message to the user that makes sure that no two entries of the 20 are identical. I'm sure I co...
4 11/8/2008 1:44:00 AM
Sum of row excluding hidden columns
Hello, I am trying to take the sum of say B5:AZ5, excluding hidden columns. The SUBTOTAL function, using funciton #109 would allow me to do B5:B50, but not the B5:AZ5 (it allows for taking the sum of a column, excluding hidden rows, but not the other way around). Is there a *decent* alternative? I have thus-far found a macro that can handle this, but a re-calculation is needed on t...
2 11/8/2008 1:27:00 AM
Excel
I have a database with 98 sheets. One sheet for each bus in our fleet. I need to updated the links for each sheet from xls to xlsm without changing the bus number in the link. I used to be able to create a macro to make a change in a few sheets in the old Excel and run it a couple of times until I had changed each sheet. In the new Excel , I try to do that & it also changes the bus n...
5 11/7/2008 11:32:02 PM
How do I change dd/mm/yy to dd-month-yy?
I use Excel 2003. I enter 10/12/08 in a cell wanting it to mean 10 December 2008. However, when I change its format to 14-Mar-01 United States Locale or to 14 March 2001 United Kingdom Locale it displays 12-Oct-08 and 12 October 2008 respectively. What do I have to do to change dates entered as dd/mm/yy to dd-month- yy? Regards, Jan Nordgreen...
7 11/7/2008 9:47:00 PM
split column with titels, names, sexe etc into five new columns
Excel specialists, I have a question. I have a column "name" with someone's name and titels and sexe like: Sir bacchalor Van Halen or Woman drs. A.J.C. Johnson. I want to split those information in 5 new columns with the columnames: 1 Sexe 2 Title 3 shortNames 4 Namebetween 5 Name. Sexe has the possible values (Sir, Woman) and Title the values (drs. and Bacchalor) and namebetween the val...
3 11/7/2008 9:15:23 PM
VBA MACRO Emergency!!!!
My spreadsheet has hundreds of rows with blank rows in between. The only way I know that I am at the end of the data is to find 20 consecutive blank rows. Example below. I need to evaluate row, if this is not the last row then proceed with my other logic so forth and so on. If it is the last row, I need to return to A7 and proceed with my other logic. A 1.XXXXXXXX 2. 3.XX...
5 11/7/2008 8:20:01 PM
Excel VBA Macro count values
Can somebody please tell me how to write the VBA code for this. Thank you. The following is a security log indicating a bunch of differents events that occured (sample data). The actual list is much longer. I have 4 workseets corresponding to 4 different computer logs. Event ID Category 529 Logon/Logoff 537 Logon/Logoff 681 Account Logon 565 Directory Service...
4 11/7/2008 8:11:09 PM
Assign a Macro to a Command Button
How do I assign a macro to a command button. I already recorded the macro, and I would like to know how to assign the macro to button? Thanks in advance for the help!...
2 11/7/2008 7:49:04 PM
Splitting up multiple lines in one cell to one line per cell in multiple cells
I have cells each of which contains multiple lines of text (use Alt- Enter at end of each line when entered). Is there an easy way to copy these lines in a single cell and past them into multiple cells, with one line per cell? Thanks, Alan ...
7 11/7/2008 7:41:07 PM
Assign a Macro to a Command Button
How do I assign a macro to a command button. I already recorded the macro, and I would like to know how to assign the macro to button? Thanks in advance for the help!...
3 11/7/2008 7:35:43 PM
Mixed references
In Excel 2003 Help it says: "Mixed references A mixed reference has either an absolute column and relative row, or absolute row and relative column. An absolute column reference takes the form $A1, $B1, and so on. An absolute row reference takes the form A$1, B$1, and so on. If the position of the cell that contains the formula changes, the relative reference is changed, and the absolut...
3 11/7/2008 4:44:03 PM
Newbe Question ON Min, Max
I have a calculated value in cell A1 which changes daily. In cells B1, B2 I need to place the upper and lower (High & Low) values that appear in A1 over time but I'm not sure how to do this. Suggestions greatly appreciated. ...
6 11/7/2008 11:43:32 PM
Excel 2000/Change Default Opening Location?
I'm using Excel 2000. When I open Excel, and the click on the Open button to open worksheet, it goes to a default location I'd like to change. How can I change that default location? I have searched under Tools > Options, but find no means there. Thanks. -- ---------- CWLee Former slayer of dragons; practice now limited to sacred cows. Believing we should hire for qua...
3 11/8/2008 7:40:39 PM
dates before 1900
I'm using Excel 2003 with current updates under WinXP Pro, SP3. I have genealogy data with dates before 1900 with which Excel 2003 does not work. I want to play with the data, for example: 1. calculate difference between two dates 2. sort dates 3. create charts that would show periods of time and their overlap Has Microsoft addressed the issue of data that uses dates before 1900 by rel...
3 11/8/2008 9:21:13 PM
484 Pages: <<  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  >>  

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net