Hey there,

I'm working on a spreadsheet to create header sheets for batches - basically it's a skeleton document to be filled out over and over.

on each row I have the file number, the status of the file and the date of the file.

Each file number is copied to another range of cells for ease of copying to another spreadsheet (a row instead of a column) and I want to be able to run a quick macro to enable me to add the date of the file as a comment on the alternative format of file numbers.

I know I ramble but wanted to be thorough, so I'll summarise:

I want to run the macro and have cell values (range = F11:F24) added as comments on other cells (range = G11:T11)
(F11 as a comment in G11, F12 as a comment in H11 etc.)

If there's no date, I don't want a comment added.

As you may be able to tell - i'm new here...be gentle with me.

Cheers