| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy date based on date -refer to date range
Dear all , One more problem this time, I have excel sheet with around 9000 rows data in 15 columns. This data is regarding the stocks at my warehouse. I keep record on the basis of the days they keep stock in my warehouse. Now I want to know daily top ten stock holders , situation is date of storage is kept on date stock kept and stock removed not on day to day basis. How can this be done? I got idea that in other sheet I will mention the date on which I want to know stock position , and there macro should search entire sheet and copy row data where the date is following between date stored and date withdrawal. And then I will apply auto filter to get top ten Please can any one help with code for this. Best regards Mind -- mindpeace ------------------------------------------------------------------------ mindpeace's Profile: http://www.excelforum.com/member.php...o&userid=28759 View this thread: http://www.excelforum.com/showthread...hreadid=548064 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy date in a cell if within a date range | Excel Discussion (Misc queries) | |||
| count a value in a date range based on a date in another workshee. | Excel Worksheet Functions | |||
| Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
| Refer to Date/Time Range | Excel Worksheet Functions | |||
| Find date and copy range based on that date | Excel Programming | |||
![mindpeace[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
