| Thread | Last Post | Replies |
|
| Keep text at top line of cell | 28 Mar 2008 21:38 GMT | 3 |
Is there a way to keep text on the top line of a cell? For example, If in Cell 1A I have the number 1000 and Cell 1B I have text that takes up two lines (text wrapped) the number in 1A automatically drops down to the second line (as the cell becomes two lines high as well to ...
|
| running macro in entire workbook | 28 Mar 2008 21:36 GMT | 7 |
I have written a macro to hide rows if the value in a row is false. I put this macro in "ThisWorkbook" code window, instead of a worksheet window. The Macro starts after an user makes a selction from drop down Control box in worksheet ONE. This macro works fine. I have 50 more ...
|
| Switching custom view when filtered | 28 Mar 2008 21:33 GMT | 1 |
I have a very large spreadsheet that I navigate using custom views. I change views using macros because I have a couple of other commands that I want executed as well. I also commonly filter the rows of the spreadsheet. However, when I switch views, the filter is turned off, and ...
|
| Tab delimited text file import on double click | 28 Mar 2008 21:28 GMT | 2 |
I have tab delimited text files containing data. The first 30 lines are header lines and do not have tabs and have spaces between words. The following lines have tab delimited columns.
|
| How to count grayed out lines in excel | 28 Mar 2008 21:06 GMT | 3 |
I am trying to track the progress of a project where we have over 1000 line items to review. We would gray out the line that has been completed. Is there a function where excel can count the number of lines grayed out so that I don't have to manually count since they are
|
| Return a number from a list of date ranges | 28 Mar 2008 20:59 GMT | 1 |
I have looked and looked and I am now stumped. Help! I want a percentage rate to populate into a cell based on a date entered in another cell. Example info:
|
| do you have a 365/360 loan amorization schedule | 28 Mar 2008 20:55 GMT | 1 |
I am looking for a 365/360 loan amortization schedule for excel 2000. Does anyone have one?
|
| Automate printing | 28 Mar 2008 20:48 GMT | 3 |
I would like to automate printing in excel. I have an Excel worksheet that has one worksheet that lists Employer Numbers. I have a second worksheet that looks up (vlookup) various employer related statistics on various other worksheets after I drop in the Employer Number. The ...
|
| How to create a dynamic named range? | 28 Mar 2008 20:47 GMT | 3 |
Would like to create a named range that increased when I added rows - please assist!! Look forward to any help. Merci!
|
| combining data with a common cell value | 28 Mar 2008 20:40 GMT | 1 |
I don't know what this is called but I have two worksheets, column A in worksheet a is a subset of column A in worksheet b. I want to find all of the values in common in column A and move the row with common A values from worksheet b to that matching row in worksheet a. Or end ...
|
| Sumif with multiple columns in sum_range | 28 Mar 2008 20:25 GMT | 17 |
I have a set of data that has a label in column A the sales in column B, C & D: Column A Column B Column C Joel 500 677
|
| GROWTH formula | 28 Mar 2008 20:09 GMT | 7 |
I am trying to create a formula that I can use that will mimic using the Edit -> Fill -> Series -> Trend & Growth values. Is there a way to do this? Basically, I know my starting X is 10 and my starting Y is 16.53509 and my ending X is 30 and my ending Y is 5,
|
| General query on use of Excel | 28 Mar 2008 19:58 GMT | 3 |
How does one subdivide a column on an excel spreadsheat?
|
| Filter drop down lists | 28 Mar 2008 19:54 GMT | 1 |
I am new to Excel and so please can you be very exact in any answers you might be able to give to me please. I have made a database/spreadsheet and at the top of the columns I've put filter arrows. That's fine. I can use them but now I find that in the drop
|
| copy macro | 28 Mar 2008 19:04 GMT | 2 |
Can a macro be created in a spreadsheet and the spreadsheet be sent by email to someone? I didn't know if the macro would still work. Thanks,
|