LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
MP MP is offline
external usenet poster
 
Posts: 39
Default 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]
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert rows based on criteria MP Excel Discussion (Misc queries) 0 December 3rd 08 06:36 PM
Insert text from another workbook based on criteria Tacrier Excel Worksheet Functions 4 April 9th 08 11:01 PM
Creating function to insert data based on criteria Tami Excel Worksheet Functions 1 August 18th 06 10:42 PM
Insert text in Cell A1 based on keyword criteria [email protected] Charts and Charting in Excel 1 June 13th 06 04:56 PM
Insert Criteria Based on Current Month Mark Jackson Excel Worksheet Functions 3 May 19th 06 03:16 PM


All times are GMT +1. The time now is 05:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"