Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I believe this may be a simple loop, but I am not sure how to finish it. I
have a Worksheet("Archive") that contains a history of all product orders. The entire Worksheet is Sorted by ship date (January -- December). In the same workbook I have a WorkSheet for every month of the year, named: "January", "Febuary", "March", etc. What I want to do is build a loop that will scan down Sheets("Archive").Column(L:L), which contains the ship date, and Cut the Range("A:P") and paste values only in the month the date belongs. Is this possible? Note: The ship dates are in this format, m/dd/yy. I'm sure this loop will work much faster if there is a Do...Until loop, because the Worksheet("Archive") is sorted by ship date! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How format SUMIF formula for matching date range and column value? | Excel Worksheet Functions | |||
On opening a worksheet move focus to a cell based on date | Excel Worksheet Functions | |||
Find matching date in another worksheet, copy and paste data | Excel Discussion (Misc queries) | |||
display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
Find Matching Text In Col A move to Col B | Excel Worksheet Functions |