move data from master list to individual lists based on value in 'Unit' cell

It will be good if you upload a sample file showing what data you have and how you want the output to look like. You do not need to upload your original file, just a mock-up of the original as long as its in the same format as the original.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Couple of questions -

In the Unit column you have numbers like 1,2,3 while your sheets are named as HU1, HU2, etc. So should the entries with units as 1 go into HU1, 2 into HU2, etc?

If you populate the data in your Master sheet and run the macro, it will populate the sheets. Now, if you have new data and want to populate the master sheet, will you copy the data to the next available row in the master sheet or will you clear the sheet and then update?

I understand. The reason i asked you was - if you run the macro the first time and then update data into the master and run again, its going to give you duplicate info in the various sheets. So i have to ask the macro to first clear the contents of the other sheets and then populate the data starting from the 1st row of the master file.

Try this code - Ensure that the sheet HU 1 is changed to HU1 before running the macro - the sheet names should be consistent, otherwise the macro will give errors.

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button