Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page copy rows to another sheets using Drop down menu
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 12-17-2017, 01:49 AM
antahoora antahoora is offline copy rows to another sheets using Drop down menu Windows 10 copy rows to another sheets using Drop down menu Office 2016
Novice
copy rows to another sheets using Drop down menu 		 
Join Date: Dec 2017
Posts: 4
antahoora is on a distinguished road
Default copy rows to another sheets using Drop down menu
Hi dudes.

I'm studying to take an international English Test. I made a excel file helping me to review some vocabularies on daily basis. but unfortunately I don't know how to program it . as you can see in the attached file, there is a reference sheet, by the name "vocab" which will be containing the whole vocabularies i wanna study. other sheets, from 1 to 30, illustrate days.


in the vocab sheet, in column A, I made a drop down menu, which contains 1-30, referring to days. I want when I choose each number from each column , the row which is related to it copies to the related sheet (from 1-30) completely. regarding to the, as I repeat this order (I mean using drop down list) in other sheets they follow the rule.

note: the rows are infinite not only 23 rows.

best regards
Attached Files
File Type: xlsx 888.xlsx (195.5 KB, 9 views)
Reply With Quote
  #2  
Old 12-17-2017, 03:54 AM
xor xor is offline copy rows to another sheets using Drop down menu Windows 10 copy rows to another sheets using Drop down menu Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
If I understand you correctly.
Attached Files
File Type: xlsx Vocabulary.xlsx (254.0 KB, 12 views)
Reply With Quote
  #3  
Old 12-17-2017, 04:36 AM
antahoora antahoora is offline copy rows to another sheets using Drop down menu Windows 10 copy rows to another sheets using Drop down menu Office 2016
Novice
copy rows to another sheets using Drop down menu 		 
Join Date: Dec 2017
Posts: 4
antahoora is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
If I understand you correctly.
Yes you did well thank you.

but It cant keep formatting while I transfer them. as well as I cant transfer rows from 1-30 sheets to other sheets.
I want when I select a sheet from sheet 1 to 30, the relating row cut and past in destination sheet. but be kept vocabulary sheet
Reply With Quote
  #4  
Old 12-17-2017, 04:55 AM
xor xor is offline copy rows to another sheets using Drop down menu Windows 10 copy rows to another sheets using Drop down menu Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Sorry, but I don't understand what you mean.
Reply With Quote
  #5  
Old 12-17-2017, 05:03 AM
antahoora antahoora is offline copy rows to another sheets using Drop down menu Windows 10 copy rows to another sheets using Drop down menu Office 2016
Novice
copy rows to another sheets using Drop down menu 		 
Join Date: Dec 2017
Posts: 4
antahoora is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
Sorry, but I don't understand what you mean.
there are some errors

1- when I add new vocabularies to vocabulary sheet, it doesn't work.
2- I wanna it to be able to cut and paste row from sheets 1-30
Reply With Quote
  #6  
Old 12-17-2017, 06:44 AM
xor xor is offline copy rows to another sheets using Drop down menu Windows 10 copy rows to another sheets using Drop down menu Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
See vocab row 27 and 28 and sheet 15 and sheet 30.

If that isn't what you want you must explain better.
Attached Files
File Type: xlsx Vocabulary_2.xlsx (252.0 KB, 9 views)
Reply With Quote
  #7  
Old 12-17-2017, 07:55 AM
antahoora antahoora is offline copy rows to another sheets using Drop down menu Windows 10 copy rows to another sheets using Drop down menu Office 2016
Novice
copy rows to another sheets using Drop down menu 		 
Join Date: Dec 2017
Posts: 4
antahoora is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
See vocab row 27 and 28 and sheet 15 and sheet 30.

If that isn't what you want you must explain better.
First of all I want to thank you.
actually this file I made is such a "Leitner Box". every sheet should be able to manage 1000 to 2000 rows not only 36 ones. 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.

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.

thank you
Reply With Quote
  #8  
Old 12-17-2017, 09:44 AM
xor xor is offline copy rows to another sheets using Drop down menu Windows 10 copy rows to another sheets using Drop down menu Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
See below.

Quote:
Originally Posted by antahoora View Post
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
Last edited by xor; 12-17-2017 at 12:36 PM.
Reply With Quote
  #9  
Old 12-17-2017, 07:39 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline copy rows to another sheets using Drop down menu Windows 7 64bit copy rows to another sheets using Drop down menu Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
@ antahoora
Hello and welcome
please do not quote entire posts unnecessarily. They clutter the thread and make it hard to read
Thanks
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy rows to another sheets using Drop down menu Multiple menu for Drop Down legalis Excel 1 03-11-2016 01:56 AM
paragraph drop down menu noamsa Word 4 02-12-2015 01:36 PM
Need help with drop-down menu please cazclocker Excel 7 01-05-2015 04:07 PM
copy rows to another sheets using Drop down menu HELP -- Drop Menu for Reoccuring Data?? cscaudle Word 1 03-02-2014 10:19 AM
Drop down menu with different value to display name swsquish Word 1 09-04-2012 08:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:01 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft