Need Macro for Transporting Data from "Comment" column to MasterSheet!

Hi there,

I am currently working with an Excel Workbook with many differenet Sheets, each Sheet holdding different information. In each of these sheets is a column labeled "Comments". I am looking to create a Macro that will transfer any row that has a "Comment" in the row to a MasterSheet. This way, the MasterSheet will hold all the data that has a "Comment" in the "Comment" column and will exclude the data without a "Comment" in the "Comment" column.

I am new to VBA and Macro so I do not know how to write this Macro. Can someone put me in the right direction for the language of the Macro and/or help me find a Macro that will perform the tasks I am looking for?

Thanks!

Hello leaps,

Welcome to the Forum!

Seeing your layout will help to provide a tailored solution that will work.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

File Manger Picture

Leaps,
There is a button on the master sheet, column G. When you press the button, it clears the existing data and repopulate with new data.
I am not sure if you want to copy the comments next to each other, or across. I am not sure why you have other headings in columns A-D and you did not mention if you want to copy these columns as well.