Copying comments from one place to another...

[spross]

Hi All,
I am new to Excel Macros. I have powershell knowledge and an understanding, though basic of scripting. Is the following possible and does anyone have suggestions on how to do it.

Scenario...
2 Sheets in a Workbook
Sheet A has a list of items in it that the user will choose from a drop down.
abc
def
GHI

Sheet B has the items listed as well. In the comments on the items in sheet B are tasks that need to be completed for each item. Usually, there are 5 to 6 items such as
ABC Comments would say the following

Task 1
Task 2
Task 3
Task 4


Once a person is done selecting all of the items in the drop down from sheet A, They would then click a button and a new workbook would be created with a new sheet that would copy the comments to cells underneath the chose item.

ABC
Task 1
Task 2
Task 3
Task 4

If other items in sheet A were chosen, the tasks associated with the same item in Sheet B's comments for that item would also be copied next.

It would then look through until all of the cells have been added into a single list with the comments in a new sheet in a new workbook.

Possible?

Scott

[spross]

Bump. Can anyone help with this?

[protonLeah]

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to "Post Quick Reply" button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

[spross]

Here you go.
The first spreadsheet is the data... Second sheet has the comments. The second spreadsheet
is how it should look when it is done. The comments from the second sheet show up in line

Any help is appreciated.

Scott