Pulling data from one worksheet to another based on certain values in certain columns
I have a spreadsheet attached where I have a main worksheet with lots of data for numerous vehicles based on a code. I want to pull the data from the main worksheet to another worksheet based on the values of Column C/Vehicle code. On the new worksheets I only want to see data for one vehicle based on a value in Column C? This is a living document so I want it to automatically update the new worksheets as the main one changes. What is the best way to do this.
Last edited by foxkevinj; 05-28-2013 at 04:49 PM. Reason: Solved
Have you considered using a pivot table?
In A4 and copy down, this ARRAY formula. Modify the red part of the formula for the other columns.
=IFERROR(INDEX(Sheet1!A$4:A$1000,SMALL(IF(Sheet1!$C$4:$C$1000=$B$1,ROW(Sheet1!A$4:A$1000)-3),ROW(Sheet1!A1))),"")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I am not totaling any of the data.. It is just static data so I don't think the pivot table will work, but I don't have a lot of experience with them. It didn't seem to work for me when I tried to create one.
A Pivot table does not need to be used to total values. You can use it to just show information dynamically. The problem you're going to have is the fact that you have pictures in your raw data tab under "Comments/Information".
Try using the spreadsheet I attached.
On the "Vehicle Data" tab, there is a pivot table where you can filter for the which vehicle you want to see the data for. The pivot table is using a dynamic range that will update whenever you add a new record in Sheet1. All you have to do is refresh the data by hitting F9.
If this works for you and you want to understand what I did, let me know and I'd be happy to explain.
ECI Tracking Form.xlsx
Thats exactly what I was trying to do.... I couldn't get the items into individual columns? When I try to do this, everything goes into column A only????
Last edited by foxkevinj; 05-28-2013 at 01:25 PM.
That's because you're using excel 2007/2010. If you want the classic pivot table look, you need to right click inside of the PT --> select PivotTable Options --> select the "Display" tab --> check the box next to Classic PivotTable layout --> click OK.
Since you're happy with the solution you should mark this thread as [SOLVED] by editing the first post, selecting advanced and update the thread prefix.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks