A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Drop Functions and Sorting



 
 
Thread Tools Display Modes
  #1  
Old April 13th, 2009, 10:46 PM posted to microsoft.public.excel.worksheet.functions
dicko1
external usenet poster
 
Posts: 8
Default Drop Functions and Sorting

I am creating a report card for work performance. Right now I have
several worksheets that contain the different data that I combine onto
the report card worksheet. Since there is more than one type of
employee and classification of the type of work pbeing performed, I
have to filter each worksheet to the proper stats, then move it over
to the report card worksheet. This takes about 8 hours because there
is so much data.

I want to know if there is a way to either use a pivot table to do
this or perhaps some way to assign a macro or function to
automatically sort the data on the other worksheets and the report
card to auto pull the data. Things I experimented with were making the
title of the report card a drop down box and trying to write something
that said If the drop down equaled "Title", then sort worksheet A to
equal report card title. Obviously wasn't successful.

Thanks for any help.
Ryan
  #2  
Old April 14th, 2009, 01:01 AM posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_]
external usenet poster
 
Posts: 1,764
Default Drop Functions and Sorting

Hi,

Could you post a clear example.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"dicko1" wrote in message
...
I am creating a report card for work performance. Right now I have
several worksheets that contain the different data that I combine onto
the report card worksheet. Since there is more than one type of
employee and classification of the type of work pbeing performed, I
have to filter each worksheet to the proper stats, then move it over
to the report card worksheet. This takes about 8 hours because there
is so much data.

I want to know if there is a way to either use a pivot table to do
this or perhaps some way to assign a macro or function to
automatically sort the data on the other worksheets and the report
card to auto pull the data. Things I experimented with were making the
title of the report card a drop down box and trying to write something
that said If the drop down equaled "Title", then sort worksheet A to
equal report card title. Obviously wasn't successful.

Thanks for any help.
Ryan


  #3  
Old April 14th, 2009, 03:31 PM posted to microsoft.public.excel.worksheet.functions
[email protected]
external usenet poster
 
Posts: 8
Default Drop Functions and Sorting

Example:

Worksheet Names - Report Card, Labor Hours, Work Orders

On the Labor Hour and Work Order sheet, the data will have many rows
and columns with data like - work order number, type of worker's
trade, labor hours, aging of work orders, etc.

If I am looking at the Report Card worksheet, can I create a button,
drop down, etc. that will automatically pull just the data I want from
the other sheets and populate the approprate cells.

So, if I want to see that avg labor hours and work order aging for
just the electrical group, not the HVAC and plumbers, can I select
electrical on the report card sheet and it will find the data from the
other sheets and populate the cells?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.