Auto-copy rows based on their values to a new sheet

Closed
Posts
1
Registration date
Tuesday May 20, 2014
Status
Member
Last seen
May 20, 2014
-
Posts
2848
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 25, 2022
-
Hello,

This is my first time in a forum like this but I have already browsed through a lot of sites regarding how to do this.

I have been using excel for a while now but know I am pretty good at formula writing and now diving into Macros and VBA (mostly with the help of internet forums and articles).

I am currently using Excel 2013, the workbook I am currently working on is an employee database that has 6 sheets (probably add more if needed), one for each employee status (eg: active, inactive, etc).

3 replies

Posts
2848
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 25, 2022
491
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
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.
Posts
2848
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 25, 2022
491
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
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.
Posts
2848
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 25, 2022
491
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