Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I populate one sheet from another
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Finding and compiling list of cells containing data... | Excel Worksheet Functions | |||
how to populate active sheet | Excel Discussion (Misc queries) | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel |