Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Include comments on another spreadsheet
I have a spreadsheet that has lastname in column B. The lastname can be
repeated several times in column B. In column C are comments that I want to capture. (Sheet1) I want to capture the comments on Sheet2. I have another worksheet (Sheet2) that I want to capture all of the comments if lastname = Jones. So in other words, if lastname = Jones and there are five comments in column C, then in Sheet2, cells B2, B3, B4, B5, I want to put the comments. Thanks in advance for any help I can get with this. |
#2
|
|||
|
|||
Here's a little more information of what I am trying to do.
If Sheet1!B2:B1000 = "Jones", and then give me the contents of what's in Sheet1!C2:C1000. Put this result in Sheet2!B2. Now go again to B2:B1000 and if ="Jones", give me the contents of what's in C2:C1000, but first check to make sure it is not a duplicate. "jh3016" wrote: I have a spreadsheet that has lastname in column B. The lastname can be repeated several times in column B. In column C are comments that I want to capture. (Sheet1) I want to capture the comments on Sheet2. I have another worksheet (Sheet2) that I want to capture all of the comments if lastname = Jones. So in other words, if lastname = Jones and there are five comments in column C, then in Sheet2, cells B2, B3, B4, B5, I want to put the comments. Thanks in advance for any help I can get with this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I reference comments by Cell Name? | Excel Discussion (Misc queries) | |||
Some exported records do not show on spreadsheet | Excel Worksheet Functions | |||
printing spreadsheet comments | Setting up and Configuration of Excel | |||
Comments do not appear on my excel spreadsheet when printing? | Charts and Charting in Excel | |||
Applying Existing Password to New Spreadsheet | Excel Discussion (Misc queries) |