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...

[SMB BGWA]

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.

"Whitman" wrote:

>
> 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...
>
>
> --
> Whitman
> ------------------------------------------------------------------------
> Whitman's Profile: http://www.excelforum.com/member.php...o&userid=36716
> View this thread: http://www.excelforum.com/showthread...hreadid=564860
>
>

[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

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...