VBA code to move data based on masterbill

[steve400243]

Hello, In This Workbook each master number can have 10-25 house bill numbers. There is about 8-15 master bill's per week. I'm trying to get to where after I enter the first master bill number, like in the example attached, have the data populate, then move down one row, have the same header and populate the other Master, and house bill numbers in the same way, and so on down. In This Workbook each master number can have 10-25 house bill numbers. There is about 8-15 master bill's per week.I hope this is a good explanation of what i'm looking for. my macro skills are pretty basic. Thanks for your time

 

[PCosta87]

Hello, In This Workbook each master number can have 10-25 house bill numbers. There is about 8-15 master bill's per week. I'm trying to get to where after I enter the first master bill number, like in the example attached, have the data populate, then move down one row, have the same header and populate the other Master, and house bill numbers in the same way, and so on down. In This Workbook each master number can have 10-25 house bill numbers. There is about 8-15 master bill's per week.I hope this is a good explanation of what i'm looking for. my macro skills are pretty basic. Thanks for your time

Hi,

Please see attached and let me know if that is what you are looking for.

Regards

 

[steve400243]

Hello PCosta, Thank you for this. This will work for what I need! I appreciate it!!

 

[PCosta87]

Hello PCosta, Thank you for this. This will work for what I need! I appreciate it!!

You're welcome