Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
isoalting cells with data and copying to worksheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
isoalting cells with data and copying to worksheet
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. "Dave1968" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Worksheet Cells Getting 0's | Excel Discussion (Misc queries) | |||
copying cells to another worksheet | Excel Worksheet Functions | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
Copying cells from 1 worksheet to another | New Users to Excel | |||
copying cells to another worksheet | Excel Worksheet Functions |