How do I populate one sheet from another

[Whitman]

I posted this question on the Excel Worksheet page, lots of views but
now replies. If anyone has any suggestions it was be very
apprecieated.


I have been struggling with this problem.

I have a 4 sheet workbook going, sheet 1 contains four colums; Name,
Address, phone, and priority (A,B,C). Sheets 2, 3 and 4 have the same
four colums, but I would like excel to automatically popluate those
colums based on the results of the priority column from sheet 1. The
end result would be a workbook where I can enter all data into sheet 1,
sheet 2 would fill with priority A data, sheet 3 with priority B data
and so forth.

Thanks...

 

[Guest]

Do really need four sheets? Can you get away with just using autofilter to
show priority A, or B etc one at a time? Can you sort by priority so that it
is shown in groups the front sheet? Can you autofilter and then copy and
paste each group into each sheet? Sorry no "automatically populate"
suggestions.

 

[mr_teacher]

I have had a very similar issue with a spreadsheet of mine. I haven't
come up with a great solution but I have found a workaround - not very
pretty and is a bit of a pain but does work!

On the second sheet in cell D2 you could use the formula
=if(Sheet1!D2="A",Sheet1!D2,"zzz")
Then in C2 use the formula
=if(d2="zzz","zzz",Sheet1!C2)
In B2
=if(d2="zzz","zzz",Sheet1!B2)
and in A2
=if(d2="zzz","zzz",Sheet1!A2)

Copy these down throughout the spreadsheet

Then I have used conditinal formatting to change all text that is "zzz"
to white.

Finally I have created a macro that runs when the worksheet opens that
sorts everythin into alphabetical order based upon column D - so all
your priority A's will then show at the top and it will then appear as
though the rest are not there and you only have the Cateory A's
showing.

You can then apply the same ideas to your other two worksheets - just
changing the letr pattern to search for.

As I say I am sure this is not the most elegant way of doing things -
and it might not be the ideal solution for you? Hopefully it might give
yo some ideas of how to go about it - and if you think / find any better
ways round of doing this let me know too and I might be able to improve
mine!!

If this doesn't make any sense you could always email me a sample of
your spreadsheet if you like and I can show you what I have done that
way.

Regards

Carl