IS THERE ANY excel EXPERT to SOLVE my Problem???

  • Thread starter Thread starter bazish
  • Start date Start date
B

bazish

I have one workbook where i manage my grey stock, on one sheet i have
all information and on 2nd sheet i want to collect

information by manager name wise, and i want to see all of the
information regarding that manager in 1st sheet. example is
given here. please solve my problem if its possible in excel.
thanks.

1st Sheetname = greystock

A B C D E F G
1 SR Date Manager Name C.# Quality Quantity Location

2 41 14-Oct-03 Amjad Ali 2921 76x56/30x30 98" 25000 msc Processing
Godown
3 42 14-Oct-03 Naeem Hussain 2818 76x68/24x24 CTN 50000 msc Processing
Godown
4 43 14-Oct-03 Naeem Hussain 2979 76x52/36x36 66" 120000 msc Processing
Godown
5 44 14-Oct-03 Naeem Hussain 2819 - 2820 76x68/24x24 98" 50000 msc
Processing Godown
6 45 15-Oct-03 Muhammad Yasin 2500 64x56/30x40 67" 5200 msc Processing
Godown
7 46 17-Oct-03 Babar Hussain 3009 76x52/35x35 102" 7000 msc Processing
Godown
8 47 17-Oct-03 Naeem Hussain 2933 - 2976 76x68/30x30 99" 75000 msc
Processing Godown
9 48 17-Oct-03 Muhammad Yasin 2514 76x62/30x30 97" 50089 msc Processing
Godown


2nd Sheetname = Report

If A1 = "Naeem Hussain" then result should be

A B C D E F G
1 Naeem Hussain

2 42 14-Oct-03 Naeem Hussain 2818 76x68/24x24 CTN 50000 msc Processing
Godown
3 43 14-Oct-03 Naeem Hussain 2979 76x52/36x36 66" 120000 msc Processing
Godown
4 44 14-Oct-03 Naeem Hussain 2819 - 2820 76x68/24x24 98" 50000 msc
Processing Godown
5 47 17-Oct-03 Naeem Hussain 2933 - 2976 76x68/30x30 99" 75000 msc
Processing Godown

and if A1 = "Muhammad Yasin" then result should be

A B C D E F G
1 Muhammad Yasin


2 45 15-Oct-03 Muhammad Yasin 2500 64x56/30x40 67" 5200 msc Processing
Godown
3 48 17-Oct-03 Muhammad Yasin 2514 76x62/30x30 97" 50089 msc Processing
Godown
 
Sounds like you'd be better off either using filters or
Access.

For filters, highlight the data set on the greystock tab
and choose Data . . . Filter . . . Autofilter. Then you
can choose a Manager's name from the drop down box or
choose custom and type it in.

I hope this solution fits your needs.

Jane
 
Hi

When on sheet Greystock you have headers in range A1:H1, and data in range
A3:Hxxx, with row 2 empty,
and
on sheet Report the manager name in cell A1, headers in range A2:H2, then on
sheet Report:

Leave row 3 empty
Into cell A4 enter the formula:
=IF(Greystock!$C3=$A$1,IF(Greystock!A3="","";Greystock!A3),"")
Copy the formula in A4, and paste it into range in columns A:H at least for
same number of rows as datarange on sheet Greystock.
You can delete the column C from Report sheet then, as it's abundant.
Select the range on sheet Report with formulas in it + range A3:G3 (or A3:H3
when you didn't delete Manager column) and set autofilter on
(Data.Filter.Autofilter).
Set filter for any column to 'Not empty' - all empty rows are hidden now.
When you change manager name in A1, reselect 'Not empty' for autofilter.

But you can get practilcally same result, when you use autofiler on
Greystock sheet, and set filter to manager name. Special report sheet is
needed, when you want your info displayed somewhat differently, or to add
some summarized data etc.


Arvi Laanemets
 
Back
Top