Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Particulars data Filter from sheet 1 to sheet 2 automatically
In the Sheet 1 I create a List of with their datas, suppose,
Manager Rs. 10000 Customer Care Rs. 5000 Accountant Rs. 3000 Accountant Rs. 2500 Manger Rs. 7000 Customer care Rs. 6000 Manager Rs. 8000 I need only the Manager Data in the Sheet 2, and I will reentry the all type data in sheet 1, new entry of Manager Data only will come in sheet 2 automatically, and update. How I could do it. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Particulars data Filter from sheet 1 to sheet 2 automatically
use datafilterautofilterfilter on "Manager"(note your SPELLING
BELOW)copy to the other sheet. Record a macro while doing. -- Don Guillett Microsoft MVP Excel SalesAid Software "Sudipta Sen" wrote in message ... In the Sheet 1 I create a List of with their datas, suppose, Manager Rs. 10000 Customer Care Rs. 5000 Accountant Rs. 3000 Accountant Rs. 2500 Manger Rs. 7000 Customer care Rs. 6000 Manager Rs. 8000 I need only the Manager Data in the Sheet 2, and I will reentry the all type data in sheet 1, new entry of Manager Data only will come in sheet 2 automatically, and update. How I could do it. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Particulars data Filter from sheet 1 to sheet 2 automatically
Assume your source data as posted in Sheet1, in A2:B2 down
In Sheet2, In A2: =IF(TRIM(Sheet1!A2)="Manager",ROW(),"") In B2: =IF(ROWS($1:1)COUNT($A:$A),"",INDEX(Sheet1!A:A,SM ALL($A:$A,ROWS($1:1)))) Copy B2 to C2. Select A2:C2, copy down to cover the max expected extent of data in Sheet1. Hide/minimize col A. Cols B and C will auto-return the dynamic results that you seek, ie only the "Manager" data, with all results neatly packed at the top. As Sheet1 is updated, "Manager" data will continuously stream over and display in Sheet2. Easily adapt & extend to suit. Any good? hit the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Sudipta Sen" wrote: In the Sheet 1 I create a List of with their datas, suppose, Manager Rs. 10000 Customer Care Rs. 5000 Accountant Rs. 3000 Accountant Rs. 2500 Manger Rs. 7000 Customer care Rs. 6000 Manager Rs. 8000 I need only the Manager Data in the Sheet 2, and I will reentry the all type data in sheet 1, new entry of Manager Data only will come in sheet 2 automatically, and update. How I could do it. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Particulars data Filter from sheet 1 to sheet 2 automatically
Hi,
You may refer to question 7 of http://ashishmathur.com/knowledgebaseII.aspx -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Sudipta Sen" wrote in message ... In the Sheet 1 I create a List of with their datas, suppose, Manager Rs. 10000 Customer Care Rs. 5000 Accountant Rs. 3000 Accountant Rs. 2500 Manger Rs. 7000 Customer care Rs. 6000 Manager Rs. 8000 I need only the Manager Data in the Sheet 2, and I will reentry the all type data in sheet 1, new entry of Manager Data only will come in sheet 2 automatically, and update. How I could do it. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Particulars data Filter from sheet 1 to sheet 2 automatically
Hi,
Define the range as list or table and then create a pivot table from it and place the pivot table on the second sheet. Click Refresh or Refresh all when data changes in Sheet1. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Sudipta Sen" wrote: In the Sheet 1 I create a List of with their datas, suppose, Manager Rs. 10000 Customer Care Rs. 5000 Accountant Rs. 3000 Accountant Rs. 2500 Manger Rs. 7000 Customer care Rs. 6000 Manager Rs. 8000 I need only the Manager Data in the Sheet 2, and I will reentry the all type data in sheet 1, new entry of Manager Data only will come in sheet 2 automatically, and update. How I could do it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Carry data from sheet to sheet automatically | Excel Discussion (Misc queries) | |||
Copy/filter data in a sheet from another sheet | Excel Discussion (Misc queries) | |||
How to Automatically transfer specific Data from Sheet 1 to Sheet | Excel Worksheet Functions | |||
create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
can entered data in sheet 1 be automatically pasted in sheet 2 | Excel Discussion (Misc queries) |