| Thread | Last Post | Replies |
|
| Go to end of column of data | 14 Sep 2007 20:08 GMT | 4 |
I have 9000 to 25000 rows of data depending on the file and the macro I am running must sum a column. Currently I sum the column down to over 30000 rows. I want to be able to sum the column in the first blank row of that cell regardless of the number of rows I have without ...
|
| macro for button option | 14 Sep 2007 19:48 GMT | 9 |
I have a command box on my worksheet and I wanna record a macro like scrolling down a file and then choosing a button option for the command box.I do the same after selecting "record new macro" but only scrolling down is saved in the macro!!and the button is not chosen?
|
| Run macro in another Excel workbook | 14 Sep 2007 19:20 GMT | 1 |
Is there a way in VB to run a macro or function from another Excel workbook? If so how can I do this?
|
| Make an Excel Spreadsheet to stop working | 14 Sep 2007 19:18 GMT | 2 |
Is it possible to make an Excel Spreadsheet to stop working after a certain date? If so, how? Many thanks.
|
| Formating | 14 Sep 2007 18:50 GMT | 1 |
I have a long list of dates example. 01/15/2007 03/13/2007 04/04/2007
|
| Command button | 14 Sep 2007 18:32 GMT | 2 |
I have a userform(1) with 12 textboxes, in each textbox there is a name. Userform2 there are 12 commandbuttons which will open userform to amend details. Is there a way that the commandbuttons reflect what is written in each
|
| Lost Autofilter option | 14 Sep 2007 17:56 GMT | 5 |
In EXCEL 2003 when I click on Data then Filter, I no longer see the Autofilter choice. How do I get it back?
|
| How do I add a blinking effect to cell in an Excel spreadsheet? | 14 Sep 2007 17:53 GMT | 2 |
I want a cell to show a blinking effect in excel. Thanks
|
| COUNTIF not counting | 14 Sep 2007 17:50 GMT | 3 |
If I am using COUNTIF to compare 2 sets of data (e.g. 2 lists of names) that I have copied from 2 different websites, COUNTIF does not recognize some names that match. I use TRIM and match the formats and of the 2 data sets, still does not work 100%. Of Course, when I copy the ...
|
| page break view watermark | 14 Sep 2007 17:49 GMT | 1 |
How do I remove or at least fade the watermark that is big and annoying in middle of page when I'm in page-break view?
|
| VLOOKUP anchored cell reference changing when macro runs | 14 Sep 2007 17:48 GMT | 2 |
I have a vlookup formula in a cell that looks up a record ID in another workbook and autofills certain data. I have the cell range as $A$2:$Z$30000. The macro that adds new record #s to the other workbook copies a row of info. and inserts the row above Row 2 of the sheet. When ...
|
| Excel 2003 - How do I change which sheet in my workbook opens firs | 14 Sep 2007 17:48 GMT | 2 |
I have a multiple sheet Excel workbook that I reference often, but it opens to a middle sheet, not to the first sheet like I want. Any ideas?
|
| Forgot my password to protect the sheet | 14 Sep 2007 17:48 GMT | 4 |
I just read in a discussion that the security for sheet protection is easily broken. I hope this is the case, because my password is not working...maybe I entered it wrong in the first place. Can anyone elp me break into my Excel file?
|
| Help with backwards lookup | 14 Sep 2007 17:45 GMT | 1 |
Here's what I'm trying to do. I'm not sure if this is possible. On Sheet 2 I have column A named Ticker and Column B named Cusip number. I have all the cusip numbers filled in. However, the correspondeing ticker for each is not. I want to go out to Sheet 1 and find the ...
|
| MOVE SPECIFIC INFORMATION TO ANOTHER SHEET | 14 Sep 2007 17:43 GMT | 1 |
I HAVE A SHEET WITH MASTER INFORMATION FOR A CLUB CONTAINING NAMES, ADRESSES, ECT... WHEN MY CLUB GOES ON TRIPS OUT OF TOWN I NEED TO MAKE NEW SHEETS FOR THE MEMBERS THAT HAVE CHOSEN TO ATTEND THE TRIP. THE PROBLEM IS THAT NOT THE SAME PEOPLE ATTEND EVERYTIME, SO I NEED A ...
|