| Thread | Last Post | Replies |
|
| new, old, difference | 30 Apr 2004 17:14 GMT | 2 |
This is most likely a very basic question, since I am a relatively lo level excel user. Three columns: New Old Difference
|
| hide / unhide details | 30 Apr 2004 16:36 GMT | 4 |
I have a spreadsheet with some "basic" data in rows and some "detail" data in other rows. These two types of rows are intermixed throughout the spreadsheet. I'd like to provide this data to others and include the ability to easily hide and unhide the rows containing the "detail" ...
|
| Excel macro !! | 30 Apr 2004 14:51 GMT | 1 |
I want to write a macro in an excel sheet wherein I want to copy a few cells from my source worksheet and paste their link ...not teh HYPERLINK.....to another worksheet.
|
| Problem with scrolling a worksheet | 30 Apr 2004 14:21 GMT | 2 |
I have created and coded text-boxes ( using the design view and VB-code) in excel that enables me to jump from one text-box to anoter by using the Tab-button, but view of the worksheet does not follow the tab Thanks !
|
| Insert Line en between | 30 Apr 2004 14:10 GMT | 1 |
I have a list of about 5500 names and I need to insert 5 blank lines for every customer, could somebody help me with this macro. Fernando Gomez
|
| Exit button. | 30 Apr 2004 13:37 GMT | 1 |
I want to put a button on a worksheet that closes Excel. I have worked out how to create the button and attach a macro to it but not how to create a macro that exits Excel. Orf Bartrop
|
| F4 key | 30 Apr 2004 13:01 GMT | 2 |
I use the F4 key alot to repeat actions. But when I copy and paste,the go to a new area and paste using the F4 key it only does it once. then have to use the copy and paste command again and then I only get paste again with the F4. Is there a way to have the F4 key not run ou
|
| Copy cell down with automatic updating from cell above | 30 Apr 2004 12:56 GMT | 1 |
have put this question in New Users forum as this probably a very basi question that I should know! I want put something in a cell that will take the cell above that look in a cell on another worksheet and add something that makes it look i
|
| Weight display (LB & OZ) | 30 Apr 2004 10:34 GMT | 3 |
Hope somone can help. I am looking for a way of displaying weight (LB & OZ) but have so far been unable to find anything. I am currently using this method to display 9LB and 5OZ
|
| Office Clipboard in Office XP and Office 2003 | 30 Apr 2004 10:17 GMT | 1 |
How do I turn this off permanently? If I click on Options when it appears and select 'Don't show Office Clipboard automatically', it only gets rid off it until I restart Excel at which time I have to do it again. I'd like to turn it off permanently.
|
| How to create a report from a data table | 30 Apr 2004 05:09 GMT | 1 |
I haven't worked with Excel very much in the last several years, bu understand spreadsheets and formulas... I have a workbook that consists of a worksheet that is one data table roughly 15 columns and about 300 rows. I am tracking IP addresses
|
| Help with Macro looping thru columns | 30 Apr 2004 05:03 GMT | 4 |
Below is the macro that I currently use and it works well Starting at column(i) it draws a graph with Y axis of column(i) and X axis of column(1) The macro starts of by declaring the value of i
|
| counting characters | 30 Apr 2004 04:21 GMT | 6 |
I have a spreadsheet with cells containing strings of characters. eg DWDE or WWN or ENWEE etc. Strings are not necessarily the same length but are 5 characters maximum. I want to count the numbers of each character in each string. so for the 1st
|
| Wildcards in If Statement | 30 Apr 2004 03:45 GMT | 2 |
It's driving me bonkers. I need to retrieve a true value if the text in a cell contains the word "Rows" plus an * wildcard in an If statement. I am at a loss on what syntax to use to retrieve this value.
|
| ISBLANK query... | 30 Apr 2004 03:25 GMT | 4 |
...for example, I am trying to get cell A1 to return a particular value if cell A3 is blank using the ISBLANK formula in A1 =IF(ISBLANK(A3),"blank","full") However, cell A3 in turn is linked to another IF statement, returning a
|