General
in [Excel]
|
Macro from cell specific to whole column Hello All, I have recorded the following macro... ActiveCell.FormulaR1C1 = "=RIGHT(RC[-3],1)" Range("O286").Select ActiveCell.FormulaR1C1 = "=IF(RC[-1]=""-"",(LEFT(RC[-4],15)*-1),RC[-4])" that basically takes a text stored number such as 100.54- to -100.54. What I want to do is make this auto ... 27 May 2010 18:11
Use Macro To Change Which Macro Assigned To Command Button I'm trying to create a macro that will change the macro associated with multiple Command Buttons on my spreadsheet. I've been able to use the macro recorder to change the macros associated with "regular" buttons on the sheet; however, the recorder does not track the changing of the macro associated with Command... 25 May 2010 17:59
CellinFooter() Specify Which Sheets are updated I have spent much of the morning looking at various forums & threads but had no luck finding exactly what I need. As you can see the code below updates the right headers for all sheets in my workbook with the value in sheet = VBlookup, Cell B1. I have several sheets in the work book that I don't want updated. Is ... 26 May 2010 12:29
Addition function of multiple cells Does anyone know if there is a function that will take a list of numbers in different cells and run various addition combinations on the list to detemine which cells will add to a specific number? For example: A1 = 1 A2 = 2 A3 = 5 A4 = 7 I want to know which cells added to gether will give me 6...answer =... 28 May 2010 15:59
Macro to Cut and paste Values I have a workbook with many lookups to external workbooks via function. INDIERCT.EXT This works fine.....but is very slow; as it cycles every associated file everytime I open my workbook (there could be 1000's). In Column P (titled) Complete? A "Y" or "N" indicates status of any given ROW of data. If t... 25 May 2010 17:59
Subtract colums in pivot table I have a pivot table that has the following characteristics (Excel 2007): -rows (down the left) are values: "# Employees", "Total Pay" -Columns (across top) are Dates I want to calculate the difference between different date columns. Example: I have: Date 5/23/2010 5/16/2010 5/24/2009 Total # Emp... 25 May 2010 14:40
Best place/book to get advanced training? I've been using excel for a long time, but my new job requires me to be more of a power user than I currently am. Any suggestions on online course/tutorials? Books? Free websites that can assist in my learning? I'm comfortable with using most excel functions, but need to improve most in the advanced functio... 25 May 2010 15:47
Command Buttons I am trying to insert a command button so that when the user fills out the form and clicks the button, an amount will calculate. For example, the sales price is in A1, when the user clicks the command button, the sales price will be divided by 1000 then divided by 2 and the answer will appear in A5. Can anyone ... 25 May 2010 14:40
keyboard recognition has slowed down in excel, help/ When using excell my keyboard recognition slows down to the point I have to sit and wait for a few seconds. Does anyone have any idea why this is happening in Excell? ... 25 May 2010 12:26 |