Excel transfer selected rows
Solved/Closed
Related:
- Excel transfer selected rows
- Free fire transfer - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to take screenshot of selected area in excel - Guide
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 13, 2011 at 09:38 AM
Oct 13, 2011 at 09:38 AM
Hi Julz,
This is what I understand from your query:
You have a data validation list with three items.
When an item is selected from the list, all rows containing that item will be moved to its respective sheet. I.e. Calved is selected all rows contaning calved will be moved to the sheet "Calved".
Am I right?
If so which cell contains the validation list?
Which column contains the items from the validation list? I.e. Which column contains the items which determine which rows to move to it's respective sheet?
If not, then please explain again in a different way.
Consider the option to post (a sample of) your workbook using a file sharing site like www.speedyshare.com. I'm using Excel 2003 so make sure your extention is .xls for me to help.
Best regards,
Trowa
ps. What does mismo mean?
This is what I understand from your query:
You have a data validation list with three items.
When an item is selected from the list, all rows containing that item will be moved to its respective sheet. I.e. Calved is selected all rows contaning calved will be moved to the sheet "Calved".
Am I right?
If so which cell contains the validation list?
Which column contains the items from the validation list? I.e. Which column contains the items which determine which rows to move to it's respective sheet?
If not, then please explain again in a different way.
Consider the option to post (a sample of) your workbook using a file sharing site like www.speedyshare.com. I'm using Excel 2003 so make sure your extention is .xls for me to help.
Best regards,
Trowa
ps. What does mismo mean?
Oct 13, 2011 at 03:42 PM
Exactly what I want to do.
The Validation list actually contains 6 items. The list itself is in column L cell 3 to 8.
Column G contains the items from the list.
Mismo means ''same as''.
Regards
Oct 15, 2011 at 07:52 AM
Oct 17, 2011 at 08:43 AM
Glad to see I understood you correctly.
It doesn't matter where the actual list is, just which cell you use for the validation (dropdown) list. Please provide that cell reference.
Also which 6 items do you have? Excel needs to know what to look for.
Best regards,
Trowa
Oct 21, 2011 at 08:20 AM
I have uploaded a sample onto www.speedyshare.com. Hope I've done it right.
Thanks for taking the time to help me with this.
Julz
Oct 21, 2011 at 08:24 AM