automatic copying rows to another worksheet

[Louann]

I have a worksheet with approximately 10-12 columns that contains information on all members to an organization. I would like to make separate worksheets that automatically populate with items from each of these rows when certain information is contained in one row. For example, if column g contains an "A", I would like all those rows with an A in column G to be on one worksheet and then another worksheet with contain another qualifier. I would like this to automatically populate to the separate worksheets once I have changed worksheet 1 (my main worksheet).

I am using Excel 2016.

[alansidman]

your explanation is only partly cleat. It would help significantly if you attached a sample worksheet showing the before and after and a clear explanation of your criteria for moving data to new worksheets.



Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Louann]

The first worksheet is the master. I want to be able to sort it by status and each different status be on a separate worksheet similar to the additional worksheets on my test.

[alansidman]

Try this:

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[Louann]

I don't know anything about VBA code and had hoped there would be a simple way to make a formula. I guess I don't follow all of the above.

[alansidman]

What don't you understand? Code does what you asked. Instructions for installation are clear. What you requested is not achievable with a simple formula Have you tried using the MACRO?

[Louann]

OK, I updated the information with all the extra worksheets that I have and was able to make it work. Is there a way to have the Excel file automatically update each time changes are made to the file without re-running the macro. Here is my problem. This needs to be user friendly so others can use it. For example, when I go in and re-run the macro, it creates duplicate entries under each worksheet. I know how to remove the duplicates but others will not know how to do some of these functions. I am debating whether using Excel or an Access database would be more user friendly to those not familiar with computer programs.

[alansidman]

Put this code in the worksheet change event for all names worksheet.

Please Login or Register  to view this content.