Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
--------------------------------------------------------------------------------
How do I code a Macro to insert new rows by criteria? Im using an excel spreadsheet to keep track of Account names Column (A), Id numbers (B), date received (C), date entered (D), date completed (E). Now I need to go back and include rows for Saturdays and Sun days once in between each week throughout the entire report. See attached sample #1 and sample 2# (desired output). The inserted rows only need to be inserted once each week. If they're duplicate accounts received the same date, the inserted (Sat/Sun) rows can be attached to the bottom of the week. Thanks [IMG]file://C:\Documents and Settings\Mperciac\My Documents\jeanie.PNG[/IMG] |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
insert rows based on criteria | Excel Discussion (Misc queries) | |||
Insert text from another workbook based on criteria | Excel Worksheet Functions | |||
Creating function to insert data based on criteria | Excel Worksheet Functions | |||
Insert text in Cell A1 based on keyword criteria | Charts and Charting in Excel | |||
Insert Criteria Based on Current Month | Excel Worksheet Functions |