Concatenate ascending number to string

[romanzero]

Hi,

I am trying to make an automatic footnote function in Excel.

What I would like to do is to have the user enter some notes next to a column of numbers. The note is text. These wil become footnotes.

I would then like (after button click) to have the notes cut and pasted at the bottom of the report in column A. I need to have a number appear where the note was originally typed (column L). The notes would (of course) start with 1. I will never know just how many notes will be entered.

In addition, I need to have the footnote number concatenate with the text value that was typed (and cut and pasted as the bottom of the report).

The selecting and cutting and pasting I can do in VBA. I am not adepet enough to do the replacing and the concatinating of ranges.

Help would be greatly appreciated.

 

[macropod]

Hi romanzero,

If you insert your "footnotes" as comments, you can then use File|PageSetup|Sheet<Comments> to print the comments at the end of the sheet. No cutting/pasting required.

All you would need to manage then is the numbering of the comments. To do this you would either need users to exercise the discipline of numbering/re-numbering all comments or to automate this. The latter would have to go through all comments sequentially, testing for the presence of a number, then validating it or deleting it and inserting the correct number - could be a problem if a comment starts with a number or doesn't have a space the between the number and the following text.

Cheers

PS: As described, your "footnotes" are really "endnotes".