Copying Comments from Multiple Sheets to a Master Sheet

[mcupp]

Hey All,

I am trying to create a Macro which will Copy all Comments made on sheets "Active", 'Precon", "Pending", and "Complete" to a master sheet "All".

Basically I need all the comments from these four sheets in the range C3:BN101 to appear in the "All" sheet from C2:BN101 and for this to update whenever "All" is made the active sheet. In order to avoid conflicts, I would also need all comments in "All" first deleted as comment locations may shift and I would like to avoid duplicates.

I have no knowledge of VBA and everything that I have tried from similar examples I have found has failed so any direction would be greatly appreciated.

[vcoolio]

Hello MCupp,


The following VBA code may work for you:-

Please Login or Register  to view this content.

Assumptions that I've made:-

- There are five worksheets in your workbook: All, Active, Precon, Pending, Complete.
- Headings in the All sheet are in row1.
- Headings in the source sheets are in row2 with data starting in row3.
- You only require the fixed range C3:BN101 from each source sheet to be transferred to the All sheet.

Please test the code in a copy of your workbook first.

I hope that this helps.

Cheerio,
vcoolio.