Auto-copy rows based on their values to a new sheet
Closed
coral51talk
Posts
1
Registration date
Tuesday May 20, 2014
Status
Member
Last seen
May 20, 2014
-
May 20, 2014 at 01:09 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 26, 2014 at 11:15 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 26, 2014 at 11:15 AM
Related:
- Auto-copy rows based on their values to a new sheet
- How to stop facebook auto refresh - Guide
- Grand theft auto 1 download - Download - Action and adventure
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Little alchemy cheat sheet - Guide
- Nvidia drivers auto detect - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
May 20, 2014 at 11:36 AM
May 20, 2014 at 11:36 AM
Hi Coral51talk,
Welcome to Kioskea!
But I think you forgot to ask your question.
Please be specific with your references (rows, columns, sheet names) to better assist you.
Best regards,
Trowa
Welcome to Kioskea!
But I think you forgot to ask your question.
Please be specific with your references (rows, columns, sheet names) to better assist you.
Best regards,
Trowa
How silly of me. Hahaha! Thank you though for responding. What I'm trying to do is to have set of rows to automatically be copied to a sheet corresponding their status set in column A. If the employee is active the entire set of row with 10 columns for this particular employee will be copied over to the sheet named "Active"; If employee is set to be inactive it'll be copied over to the sheet "Inactive and so on and so forth.
I'm pretty sure that I may need to use VBA for this and I have tried a lot of formulas but unfortunately I have not been able to be successful in any way.
I think it would also be nice if I could also show you the worksheet. Is there a way for me to be able to add photo's or upload the document?
Thanks in advance.
I'm pretty sure that I may need to use VBA for this and I have tried a lot of formulas but unfortunately I have not been able to be successful in any way.
I think it would also be nice if I could also show you the worksheet. Is there a way for me to be able to add photo's or upload the document?
Thanks in advance.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
May 22, 2014 at 10:49 AM
May 22, 2014 at 10:49 AM
Hi Coral,
Having a look at your file is definitely helpful. You can use any free file sharing site, without passwords, like www.speedyshare.com or ge.tt. Careful with personal info.
Awaiting your reply.
Best regards,
Trowa
Having a look at your file is definitely helpful. You can use any free file sharing site, without passwords, like www.speedyshare.com or ge.tt. Careful with personal info.
Awaiting your reply.
Best regards,
Trowa
Thanks again for responding. I'm not pretty sure which to use so I included all.
Download Link : http://speedy.sh/Yb7fj/Demographics-Practice-Worksheet.xlsx
Forum Link : [code]http://speedy.sh/Yb7fj/Demographics-Practice-Worksheet.xlsx[/code]
HTML Link : <a href="http://speedy.sh/Yb7fj/Demographics-Practice-Worksheet.xlsx">Download at SpeedyShare</a>
I hope this would help.
Thanks again in advance.
Download Link : http://speedy.sh/Yb7fj/Demographics-Practice-Worksheet.xlsx
Forum Link : [code]http://speedy.sh/Yb7fj/Demographics-Practice-Worksheet.xlsx[/code]
HTML Link : <a href="http://speedy.sh/Yb7fj/Demographics-Practice-Worksheet.xlsx">Download at SpeedyShare</a>
I hope this would help.
Thanks again in advance.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
May 26, 2014 at 11:15 AM
May 26, 2014 at 11:15 AM
Hi Coral,
I added the code to your file. It will run automatically when you change the status in column A of the "Master Data" sheet. It will work for the status "Active", "Inactive" and "Job Offer".
In addition to make it easier/faster to input your status, I created a drop down list. The list is located on the "DDL" sheet, which you can hide if you want, or delete if you don't like ddl's.
Not sure if you wanted to include "Not Hired" to the status list, but since you didn't create a sheet for it, I assumed not. Maybe you can add it yourself once you see how it is done, if necessary.
Here is your file:
http://speedy.sh/JCKvS/Coral-Demographics-Practice-Worksheet-V2.xls
Let us know if something is unclear.
Best regards,
Trowa
I added the code to your file. It will run automatically when you change the status in column A of the "Master Data" sheet. It will work for the status "Active", "Inactive" and "Job Offer".
In addition to make it easier/faster to input your status, I created a drop down list. The list is located on the "DDL" sheet, which you can hide if you want, or delete if you don't like ddl's.
Not sure if you wanted to include "Not Hired" to the status list, but since you didn't create a sheet for it, I assumed not. Maybe you can add it yourself once you see how it is done, if necessary.
Here is your file:
http://speedy.sh/JCKvS/Coral-Demographics-Practice-Worksheet-V2.xls
Let us know if something is unclear.
Best regards,
Trowa
