| Thread | Last Post | Replies |
|
| adding daily totals to weekly totals | 28 Mar 2008 15:26 GMT | 3 |
I have a spreadsheet called daily data it has two columns of data, at the end of the day I want to copy the values in column b and paste them to the spreadsheet weekly data. Each column in weekly data has values grouped in week ending columns i.e
|
| A little Macro Help Please ... | 28 Mar 2008 15:20 GMT | 15 |
Excel2003 ... I know nothing of VB Code ... I record Macros only & then perform a little creative cut/paste as needed ... That said ... I have the following recorded Macro instruction: Range("A2").Select
|
| Search Companion | 28 Mar 2008 15:05 GMT | 1 |
I am using Excel 2003 and and my operating system is Windows XP. Using Excel VBA,is there any way to activates the Search Comapanion? I have tried Application.SendKey ("^{ESC}") but it does not work.
|
| Obtain Name of Function or Sub | 28 Mar 2008 15:04 GMT | 6 |
Hi Experts I would like to include the name of the current function or subroutine in my error handler output. Is there any property that will provide the name or context of the current point in the call chain?
|
| Get the path of the .xls file | 28 Mar 2008 14:48 GMT | 2 |
I currently am using one workbook to open another, now the sheet I open is always located in "\HolSheets\holSheet.xls" and the original workbook is in the folder that is the parent of the directory HolSheets. This will always be so, yet not sure where they want me to copy the ...
|
| VBA problem after Excel update? | 28 Mar 2008 13:58 GMT | 1 |
I have a VBA script that I use to convert CSV-files from a TDS1014 oscilloscope. With this script I can open a CSV-file, convert it with the macro, and then open
|
| autofilter average values | 28 Mar 2008 13:38 GMT | 2 |
I have a table with the following headers Range (A1:L1) segment 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 I have a list for which I filter this table according to segment and I
|
| Finding, copying and pasting | 28 Mar 2008 12:44 GMT | 1 |
I want to get some code that will do a few functions for me. I have a worksheet with 1000's of entries and I want to find and use only about 15 of them. I can find them by their name which is displayed in column A, I then want to select the whole row and add it to a new worksheet.
|
| macro for serching syllable in a word | 28 Mar 2008 12:41 GMT | 1 |
I am looking for a macro that reads a word from one cell and gives back more stressed letter in a word..say for an example "Highwave " will have to return H,W
|
| Identify second line | 28 Mar 2008 12:19 GMT | 2 |
I have a strange issue, in a cell I have two lines which is entered by the user using alt+enter. Now I need to segregate only the second from each cell & manipulate teh data furhter. This data is full of text. for eg: NCO
|
| return item from second column from2 column combobox | 28 Mar 2008 12:04 GMT | 1 |
I am using cboMonth3(cboMonth3.ListIndex - 1, 1) but I get type mismatch can someone help please? Regards Charles
|
| adding data to one olumn to another | 28 Mar 2008 11:34 GMT | 1 |
I have two columns of data column a is always the same coloum b get filled out every week with numerical data for instance data1 10 data2 9
|
| Formula to sum non-adjacent cells | 28 Mar 2008 09:49 GMT | 7 |
Excell 2003 I have a 3000+ line spreadsheet with totals in one column every 17th row. What formula can I use to sum these totals? Thanks
|
| AutoFilter Blue Arrow | 28 Mar 2008 09:27 GMT | 2 |
I found an article here: http://www.contextures.com/excelfiles.html#Filter Article FL0014 - Colour Filter Headings -- Event code colours the filtered column
|
| Adding an input box to a custom toolbar | 28 Mar 2008 08:36 GMT | 3 |
is there a way to add not a button but an input box into a custom toolbar in excel. I would like the user to type some text in the toolbar, press enter and a macro would launch at grab the text. I think it is feasible, but I can't see any article/post/webpage on the
|