Create new worksheet & copy the based on date [Solved/Closed]
Raja - - Latest reply: Raja - Apr 9, 2012 at 06:25 AM
Related:
- Create new worksheet & copy the based on date
- Create new sheets in Excel based on dates and creating charts - Forum - Excel
- DOS: create filename based on date? - How-To - MS-Dos
- Copy a row from one worksheet to another, based on criteria ✓ - Forum - Excel
- Create & name worksheets from a list and copy data ✓ - Forum - Excel
- Copy a row from one worksheet to another, based on criteria ✓ - Forum - Excel
1 reply
Best answer
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
Start macro recorder
Apply the filter for date
copy the visible rows
paste
stop the recorder
this will give you a good template to work from
Apply the filter for date
copy the visible rows
paste
stop the recorder
this will give you a good template to work from
A few words of thanks would be greatly appreciated. Add comment
has helped 2574 users this month
both refers to the column on which you want to apply filter. Since you said , next calibration date, "K" should have been "L"
Now code is working as expected
Thanks again!
I find excel macro recorder is the best. It gives you a good template to start from, Plus if you study and try to understand that code, you learn too.
http://office.microsoft.com/en-gb/training/overview-RZ001150634.aspx?section=1
http://www.excel-vba-easy.com/