How can I copy comments to other sheets in a workbook using VBA

[paulcarr1974]

Hi,

I have a workbook. First sheet has dates September 1st 2023 to September 30th 2023 (a2 to a31). I have 6 comments in each cell of each row. (columns B,C,D,E,F and G). The next 30 sheets are for the thirty days of September, titled September 1st 2023, September 2nd 2023 etc. Using VBA I want to copy my six comments in each row of Sheet 1 to specific cells in the corresponding sheet. So, the 6 comments on the same row as September 1st 2023 to 6 cells in the corresponding sheet, titled "September 1st 2023". Those six cell addresses are the same for all 30 sheets. Let's say B5, G3, H4, I3, L10, A14.

How do I do this? I think I'll need to make use of a for next statement. Is there some way I can match the dates listed on sheet 1 with the dates on the sheet names and use that to transfer comments to the correct sheet?

Paul Carr

 

[mumps]

By "comments" do you mean just plain text in each cell or do you mean Excel comments that appear when you hover over each cell? It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach screenshots (not pictures) of your first sheet and at least one of the daily sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).