Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 worksheet to display data from many
Ok, heres the scenario.
I have an excel workbook that is basically a risk & issue log. I have 4 work sheets in the work book - all are identical except that they display data blonging to different projects. What I want to do is have a "front" worksheet that will just display the "open" items from each of the 4 workbooks. Any ideas if I need a function, or perhaps a macro? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 worksheet to display data from many
Hi Dave,
A function such as CountIf would only tell you how many are open without the details. The way to go is to use a macro. One solution would be to use a For-next loop to select worksheet 2-5 in turn; use Excel Autofilter to select rows in the worksheet table; copy these rows onto the front sheet making sure they are copied below any existing data; then tidying up the new table on the front sheet. You will need to tweak the code for header rows as these will be copied across from each sheet. Also you will need to insert a piece of code at the beginning just to check if any old data is there on the front sheet and clear it out if so. Regards Paul "Dave Eade" wrote in message ... Ok, heres the scenario. I have an excel workbook that is basically a risk & issue log. I have 4 work sheets in the work book - all are identical except that they display data blonging to different projects. What I want to do is have a "front" worksheet that will just display the "open" items from each of the 4 workbooks. Any ideas if I need a function, or perhaps a macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display data from another worksheet | Excel Discussion (Misc queries) | |||
How do I display every 5th row of data from a worksheet in a new . | Excel Worksheet Functions | |||
how do i filter data on one worksheet and display on another. | Excel Discussion (Misc queries) | |||
How do I display data in different worksheet in excel | Excel Discussion (Misc queries) | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions |