Pulling information from master sheet onto subsheets automatically

Hi, i'm have a master spreadsheet of contact details and categories. i want to be able to pull contact information onto other sheets within the same workbook, based on category. example attached.

Hi Catty, and welcome to the forum.

The following code should copy each row from the Master sheet to its respective sheet (Hot, Cold or Warm). It does not remove the rows from the Master sheet (although that is possible).

Please Login or Register  to view this content.

The code does not fill in column A on any of the Hot, Cold or Warm sheets, since that seems to be somewhat obvious. If you want it filled in automatically, that can also be done.

To add the code, right-click on the Master sheet tab, click View Code. Paste the code shown above into the VB Editor window that appears, then close the VB Editor. To run the macro, press ALT+F8, select "catty" from the list of macros, then click Run.

Hope that helps!

Yes, you could do this using formulae but if you go down that route you would should strongly consider adding some "helper" cells to avoid need for Array formulae as this will slow the file... perhaps the attached may be of interest ?
(note: .xlsx extension)

Once the file is saved you could populate A1 with the name of the active sheet rather than entering manually.

I'm not saying you should disregard the VBA apparoach - pending volume of data it may well be the best option available to you
(Note: I would however advise that you adapt pjoaquin's code such that references to Range("A65536") become Cells(Rows.Count,"A"), given you're running XL2007 65536 is no longer the definitive final row available).

You could also consider using Pivot Tables of course...

catty, please take a few minutes to read the forum rules about thread titles (and in general) before starting your next thread. This is your freeby.

Maybe run the macro again and see.