arnoldmiranda
Board Regular
- Joined
- Jul 15, 2002
- Messages
- 233
Hi,
I maintain a file which has data going into thosands, amongst several columns of data I have column reflecting "Names" and column D with Dates, I usually do a sort by name and date so it lists accordingly. Can I assign a macro which puts a number after the date for each name in the same column so 01-Sep-06 becomes 01-Sep-06 1 and 01-Sep-06 2 02-Sep-06 3 for a certain name and then just repeats accordingly for the next name. I do realise I I may have not explained this well, if not I guess I will try to explain myself again, thanks
I maintain a file which has data going into thosands, amongst several columns of data I have column reflecting "Names" and column D with Dates, I usually do a sort by name and date so it lists accordingly. Can I assign a macro which puts a number after the date for each name in the same column so 01-Sep-06 becomes 01-Sep-06 1 and 01-Sep-06 2 02-Sep-06 3 for a certain name and then just repeats accordingly for the next name. I do realise I I may have not explained this well, if not I guess I will try to explain myself again, thanks