isoalting cells with data and copying to worksheet

[Guest]

Hi All,

I have a document spread onto 3 worksheets. The first worksheet is 600 rows
and 22 columns and is a report/checklist. In one of the columns are comments
which I need to capture on the third worksheet because they are detailed as
items to be corrected.
I do not want to continually copy the comments from one page to the other
and would like to do this automatically. There is a problem with copy and
paste as the cells are merged into 3 columns on the first sheet but are
single columns on the report sheet ( 3rd sheet)

I need to use either a function or solution to allow the data in the
comments column to generate another list on another worksheet.

Would appreciate some help from Excel specialists..my knowledge is average
but not sure how to deal with this one.

Thanks

Dave

 

[Guest]

I would look into using the VLOOKUP() function on the 3rd sheet.

It would work for you IF there is also information on both sheets that
provides a unique identifier for the entries on the first sheet.

Let us say, for example sake, that column A on the first sheet has a project
number or other unique piece of information. The comments on the first sheet
are in column F (which is merged with G and H - you may need to consider
breaking these up, and I don't think I need to go into details on the
problems the merge has caused to convince you this may need to be done).

On the 3rd sheet you have the project numbers in column B and want to see
the comments in column R.

On the 3rd sheet in column R, and we will use row 2 on 3rd sheet for this
right now, you could have a formula like this:
=VLOOKUP(B2,'Sheet1'!$A$1:$H$600,5,FALSE)
That would echo the comment from column F on the first sheet when a match to
the project number in B2 was found in column A of the first sheet.

But breaking that comment up into 3 cells on the 3rd sheet is going to take
more work.