Display data based on selected column name

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have two worksheets in my excel sheet.

The first sheet contains data as shown below. It has data for each month.

Jan-2010 Feb-2010 Mar-2010
Calls Received 200 220 190
Issues Successfully Resolved 140 130 165
Issues Escalated 29 45 19
etc.,


The second worksheet will have a graph and the data corresponding to a particular month.
On the top, I need to select a month that is available in the first sheet. I have created a list for drop-down based on the months names inb the first sheet.
For example, if I select "Feb-2010" form the drop down menu, then I need the graph to display data for that month and also the information as listed below.

Calls Received 200 Issues Successfully Resolved 140
Issues Escalated 29

The information displayed on the second worksheet is not listed in a single column like the listing in the first worksheet. There are too many pieces of information in the first worksheet and to show it all in a single page printout (when printing the second worksheet), the information will be displayed in multiple columns and rows in the second worksheet.

How can this be done?

Thanks,
Eric



2 replies

Can someone give me ideas on how this can be accomplished?

Thanks in Advance
Eric
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
769
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like