Conditional Fomatting in a macro
I can create a manual Conditional formatting rule to do what I want. Rule is that column A includes "Total". and I want all the subtotal lines to be shaded as a break between projects. Create Rule Set area and apply Adds all the formatting I want. However, when I record the Macro, the conditional formatting does not record... Anyone know what the code would be to add it manually so that we don't have to create the conditional formatting every time.
Macros- Auto Copy paste row when cell value changes
I am not very experienced with excel so need help to do the following: I have column headers in columns A:G In the row below I have blank cells for data input. When column g has text input, I want a macro to automatically copy the row (sans data) and paste in the row below. For example if data is entered in G3, macro should copy row 3, insert and paste in row 4, delete contents of copied data in row 4. This sequence should repeat each time data is entered in any cell in column G. The very last row has formulas to calculate totals. I have the following macro to copy, insert row, and paste: Sub InsertRow() ' ' InsertRow Macro ' ' ActiveCell.EntireRow.Select Selection.Copy Selection.Insert Shift:=xlDown On Error Resume Next ActiveCell.Offset(1, 0).EntireRow.Cells.SpecialCells(xlCellTypeConstants).ClearContents On Error GoTo 0 ActiveCell.Offset(1, 0).Select Application.CutCopyMode = False End Sub I have the following macro to run the insert macro when the value in column G changes: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$G$4" Then Application.EnableEvents = False InsertRow Application.EnableEvents = True End If End Sub Those work only when I change value in G4 however if I try to change the macro to apply to all of column G the macro goes crazy. I am unsure how to modify macro to run for the entire column G. Thank you in advance for any suggestions or assistance!
Auto populate html document from excel cell
I have an excel spreadsheet containing html codes that want to auto populate and auto update an html document when an "update" button is pushed in the excel workbook. I have done something similar building a macro, but this was years ago and I cannot remember how to do it Ex: Update cell A1 with a new html code which then updates A1.html document.
Need to remove columns and save file with a name ends with today date
I do a repeated task very frequently and I am trying to see whether I can automate the process. I have few products and I need to order those. I create an excel spreadsheet and I create columns as product name(first column) and multiple vendors( three different columns). I have many different products as rows. Once I work on where to order product then I have lot of rows of data. When I want to place the order(for eg vendors a, b, c) then I remove columns b and c and save the file as a_<todaydate>.xls. I create another file as b_<todaydate>.xls by removing columns a and c. How can I automate remove columns and creating a file name ? Macro can do this or any other suggestion in excel ?Add-ins//graphing programs for excel output of Aggregate data
I am looking for an add-in or macro that can help with graphing aggregate statistical data (cross tabs, banners, etc). The problem with programs like Power-pivot or platforms like Tableau is that they require up front data that has not been analyzed or they require significant amounts of programming that would only be warranted if the same simple variables were being tracked. We currently process customized statistical tables and manually copy and paste each table output into standard graphing functions within excel. We are looking for any program that could help speed up this process. Something that isn't directed at standard business development data pulled from servers, or requires additional programming between our excel output and the analysts who chart the aggregate data. If anyone has any insights to help me out I would greatly appreciate it! Thanks!
