How to create several roster by moving one row each time?
Good Morning,
I have a rota (roster) is there any way I can create 7 more, but keep moving one row up each time .like number 2 goes to the top and number 1 goes to the last row and so on.my original roster is with 52 rows ,but if you can help me with VB code would be much appreciated.I have manually made some desired result in my workbook to explain more clearer.
Much appreciate any suggestion in advance.
use vlookup (since the column A is a unique number), find the result from A3:I10.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
You can try this logic
Please modify your desired number to start (Mentioned in Yellow)
Last edited by ramananhrm; 09-05-2013 at 12:10 AM.
Please click 'Add reputation', if my answer helped you.
hi Ramanan,
thanks ever so much for your perfect solution,very very .....very much appreciated.i added to your reputation.
Wenqq3 thanks for your suggestion but i'll stick with Ramanan solution.
have a good day.
Sem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks