Autopopulating multiple sheets from one main sheet

Hi

Is it possible to upload a sample spreadsheet because my first thoughts are to use a formula to attain your desired result?

Cheers

Thanks for replying so quickly! Here's a streamlined version of the spreadsheet. At the moment, if I enter a name into Column B on the Master sheet (say David) the entire row will copy to David's sub sheet. However, if I then update the delivery date or any data in any other column, those updates don't copy across to David's sub sheet. Any help much appreciated!

I've attached an example showing how you can achieve this using three formulae, rather than a macro.

In the Master sheet I have this formula in cell I3:

=IF(B3="","-",B3&"_"&COUNTIF(B$3:B3,B3))

which can be copied down as far as you need to (I've copied all formulae to row 10 in the example, as well as colouring them blue). This will set up a unique number for each record as it is copied down (you will see that I've added some more data to your file to help illustrate this).

Then in each of the subsidiary sheets I have put the name of the sheet in cell I1 and this formula in I2:

=IFERROR(MATCH($I$1&"_"&ROWS($1:1),Master!I:I,0),"")

This tells you where in the Master sheet there is a matching record (for David_1, David_2 etc. as it is copied down). Then in cell A2 I have this formula:

=IF($I2="","",INDEX(Master!A:A,$I2))

and this retrieves the appropriate data from column A of the Master sheet. When it is copied across into B2:H2 it will bring the data from those columns of the Master sheet, for the row identified in I2. Then the formulae in A2:I2 can be copied down as far as you need them.

As this is a formula-based solution, then if you change any of the data in the Master sheet it will be reflected in the subsidiary sheet automatically.

Hope this helps.

Pete

Pete, thank you so much, that's exactly what I needed! It works perfectly. Really appreciate your help. H

Glad to hear it, Hayley - thanks for feeding back.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete