Originally Posted by antahoora

First of all I want to thank you.
actually this file I made is such a "Leitner Box".

[xor] Have absolutely no idea what a Leitner Box is.

every sheet should be able to manage 1000 to 2000 rows not only 36 ones.

[xor] That's just to copy down the formulas as needed.




added to this the important part is I need to review vocabs on daily basis. regarding to this as I review them, If I could learn them I should transfer them to the next sheet, representing next day, and if I couldn't I should transfer the row to the first day (I mean sheet 1). to give a clear example in the first day I should study a vocab and transfer it to sheet 1. in the next day, I mean day-2, this excel file should be able to transfer a row from sheet 1 to sheet 2 (and from sheet-2 to sheet-3 and so on) by drop down menu.

[xor] Isn't that a question of changing the sheet number in column A of sheet vocab?

by the way, is it possible to cut and paste each row to other sheets instead of copying them? if yes, plz program it like this. I mean every row in every sheet cut and paste completely instead off copy and pasted by drop down menu.

[xor] Not understood at all.

thank you