| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert rows based on criteria
--------------------------------------------------------------------------------
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] |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert rows based on criteria
Sorry for the double post. I do not know how to remove the duplicate post.
"MP" wrote: -------------------------------------------------------------------------------- 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] |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert rows based on criteria
Not sure about others, but I couldn't see your attachments.
Wouldn't it be easiest to add the Saturday and sundays at the bottom of your report and just doing a sort by date to put them where they need to be? Maybe not if the report isn't one solid table of data... "MP" wrote: Sorry for the double post. I do not know how to remove the duplicate post. "MP" wrote: -------------------------------------------------------------------------------- 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] |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert rows based on criteria
the report is one solid table of data.
Thanks for the suggestion.. now how should I code, the adding of all the saturday an sundays in between each week at the bottom of my table? :) "Sean Timmons" wrote: Not sure about others, but I couldn't see your attachments. Wouldn't it be easiest to add the Saturday and sundays at the bottom of your report and just doing a sort by date to put them where they need to be? Maybe not if the report isn't one solid table of data... "MP" wrote: Sorry for the double post. I do not know how to remove the duplicate post. "MP" wrote: -------------------------------------------------------------------------------- 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] |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
