Spreadsheet Automatically Adds an Entry to Separate Spreadsheet in Workbook

[larajolly]

I have a spreadsheet that basically outlines a list of changes. This spreadsheet lists things like Date, Description, Type, and if there is a cost change.

I have a separate spreadsheet in the workbook that needs to list each item from the first spreadsheet that has a cost change. Basically I'm thinking there might be some kind of "if" the line shows a value in this cell, then auto fill in the next cell on this spreadsheet.

This would help me to not forget to include entries from the first spreadsheet onto the second, or have to cross reference the first with the second.

Example:
Spreadsheet 1

DATE A ITEM NUMBER DESCRIPTION $
7/27/12 RFI 0451 Add lockers in basement room $

Spreadsheet 2

CM # Priority Status XPCI # Date Initiaited Date Submitted DESCRIPTION
0001


So, the description in the second spreadsheet should automatically match the description in the first spreadsheet. And as I add items to the first spreadsheet with the $ under the $ column, items should ad automatically in the second spreadsheet.

Is this possible?

Thank you!
Lara

[jason_lee_91]

sorry i am slightly confused. does the second worksheet already exist?
where is CM, #, Priority Status ... coming from?

if the second worksheet already exists, then you could use a vlookup to the first worksheet. this would be If you have information on both sheets and you only want certain information to be pulled from the first worksheet?

if the second worksheet doesnt exist, then you could use a pivot table. As in when you fill in information on spreadsheet 1 then spreadsheet 2 will automatically insert a new row of information based on the first worksheet?

they are both quite simple. If you explain with a little more detail then I could try to help you.

[olasa]

As already mentioned, =VLOOKUP() is probably your answer, or alternatively INDEX/MATCH.
Attach an example if you want to an 'example reply'.
//Ola

[FDibbins]

just to add my 2 cents worth for the OP...for a vlookup (index/match - which is essentially the same as a vlookup), both tables need to have at least 1 range that is common to them for the search to succeed. if description is what you will be using as the common criteria, and these are being entered manually, you stand the chance errors creeping in due to typos

if you have a known/fixed number of descriptions, you could put the in a table and then use data validation in both tables to help eliminate typing errors