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]

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]

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]

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]