Easily Pull Data from 1 source to line up with another

[fort384]

Ok, so I am thinking there must be an easy way to do this without VBA code, but maybe I am wrong...

I use a planning tool that groups task counts by task code and employee name/#. I can export this report from the planning tool to excel and each task count ends up in a box in excel. But it is a 4 page report that I ultimately want to be able to pull the task counts directly to a new sheet lined up in 2 columns: Employee name in column A, task count in column B.

The hard part is the export to excel for the report isn't always consistent on exactly what rows each of the task counts is in. If I have a 0 task count against a particular employee, than that name is omitted from the list -- how can I easily have 2 columns that automatically fills the data from a 4 page report down to a simple 2 columns?

[Glenn Kennedy]

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever). Please don't attach a picture of an Excel sheet (no-one will want to re-type all your stuff before starting).

1. It does NOT have to be your real sheet - mock up a SAMPLE if you need to. But not 1000's of rows!!! It makes manual checking so tedious. Whatever you do... make sure that all confidential information is removed first!!

2. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

3. Make sure that your desired solution is also shown (mock up the results manually).

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[fort384]

Ok, so I have attached example data - what I would like to be able to do is paste in the results of an output into the report data tab, and on the next tab it pulls the information and organizes it into a quick table.

However, the hitch is that while the columns in which the relevant data will not change, the rows could change depending on who has task counts that day. If task count goes to zero, the name (and rows) will not be in the output.

Hence, referencing the specific cell to get the table in the output tab isn't a viable solution.

The representative data is about half to 1/3 of what the actual report length will be on a daily basis, so I won't be dealing with thousands of rows or anything. I just want to very quickly be able to organize data into a table vs. manually pulling the numbers from the sheet each time.

Thanks for your help; let me know what other info I can provide!