Creating Conditional Lists - Maybe a VB code?

Kristofer

New Member
Joined
Oct 25, 2012
Messages
5
Hi,

I am creating a spread sheet with a large amount of data.

In column a I have a list of managers, in B I have a list of employees and C, I have a list of activities that have been recorded throughout the day.

What I want to do is create a list (on a new sheet) so in column A that would bring back all the managers. Then in column B, bring back the employee that is tied to the manager from column A and finally in column C, bring back the activity that is tied to the employee.

I know how I can do this by doing list validation with INDIRECT, but with the large amount of data that I have this would take forever in a day.

Is there an easier and quicker way to do this?

Thanks in advance.
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
Kristofer,

A macro may be able to solve your request.

What version of Excel and Windows are you using?

Can you post a screenshot of the raw data worksheet, and, post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
MrExcel HTML Maker

Or, when using Internet Explorer, just put borders around your data in Excel and copy those cells into your post.
See reply #2 the BLUE text in the following link:
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045


If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,121
Messages
5,570,303
Members
412,318
Latest member
angoeyuan
Top