| Thread | Last Post | Replies |
|
| Dates | 28 Jun 2006 05:50 GMT | 1 |
Any one know how to set up dates like in roll A:1 to 31 and as you stroll down column the roll A follows down to roll M so you know where you can add numbers to date with out have to stroll up to be sure your in the right spot?
|
| Use a button to copy the values of one range to another | 28 Jun 2006 05:35 GMT | 3 |
Please give me some help with this I have a range on Sheet1 and a range of the same dimension on Sheet2 . I need code for a button on Sheet1 that when pressed copies the values of the range on Sheet2 into the range on Sheet1
|
| help creating helper column | 28 Jun 2006 05:18 GMT | 1 |
I have a situation where I need to compare week1 from one year to week1 from another year. The problem is that I have the dates, amounts, and categories in a raw dump from an external application in a text file and am able to import it into Excel. The issue that I need to do is to ...
|
| Graph Source Data | 28 Jun 2006 05:10 GMT | 1 |
Is there a way to make a graph source data pull only the last 14 days of info ?? I have a data source that gives me 90 days of info, but on one graph, I want to limit it to the last 14 days and not have to manually adjust it every day. Brian
|
| Move WorkSheets Within Same WorkBook!! | 28 Jun 2006 05:02 GMT | 3 |
I've created a workbook with 80 worksheets. Now I have added 40 worksheets. The problem is I need to move the added worksheets but I can't use the work sheet names to move the worksheets with the following code Sub ORGANIZE_WORKBOOK_SHEETS()
|
| Input Box value saves wrong WorkBook file & AUTO Sheet Numbering (1,2,3,4...) | 28 Jun 2006 04:55 GMT | 1 |
Thanks 1st to all that have assisted me with these codes thus far. RE : Below Code/s. I have a macro (macro11) that when a designated number of sheets is reached, a box states this and prompts a value to SAVE the NEW wb as "???"
|
| Close All and Workbook_BeforeClose events | 28 Jun 2006 04:34 GMT | 6 |
I've encountered the following problem that I wonder if anybody else has encountered. I have an application that is implemented as an Excel add-in. Each workbook that contains application data contains a Workbook_BeforeClose event handler
|
| Paste Append? | 28 Jun 2006 04:24 GMT | 1 |
I am trying to copy data from one worksheet to the end of the data on another worksheet. I found this macro but it only works with one row. Perhaps someone can help me modify it. Thanks
|
| Do Until Question | 28 Jun 2006 03:17 GMT | 7 |
I'm using the following code to number each cell in column A if there is a value in column B. I need help setting my variable 1 when it start. Sub count1() Dim i As Integer
|
| VBA cell values | 28 Jun 2006 02:44 GMT | 1 |
OK, I seem to be mis-coding this. Can anyone tell me what is wrong with this VBA code?.....or a better way to do it? ******* This line is supposed to return a value in a specific cell based on
|
| Open Hidden sheets to specific point | 28 Jun 2006 02:38 GMT | 2 |
Lets hope my internet won't crash before this one posts...AGAIN...lol I have hidden sheets that I have got a macro to open once the button is selected, but I want the macro to open at a specific point. Here is the END only of the macro
|
| Single Macro containing multiple subs | 28 Jun 2006 02:20 GMT | 2 |
I'm trying to write a macro that will check numerous 'If.. Then' statements and if the condition is met it goes out to a share point and retrieves a specific Excel file. As soon as it opens that file it returns to the original macro and checks the next If..then statement.
|
| lookup | 28 Jun 2006 02:13 GMT | 1 |
lookup i using three column part #, price, parts in stock. I won't to lookup part # and it wil show price and show parts in stock
|
| find each of the items in an array and save result in another array | 28 Jun 2006 01:54 GMT | 2 |
There must be an easy solution to this. I am working with an array of values and need to look up each value in a worksheet and store the value of a cell 3 columns away in another array.
|
| prevent a special cell from being deleted | 28 Jun 2006 00:30 GMT | 1 |
The cell has the content "Do Not Delete" How do I write an If statement to prevent this cell from being deleted by a macro that deletes a row? Thanks.
|