Renaming Cells

[DPeter2101]

I need to rename cells from b5,c5,d5,e5 up to af5 and down 75 rows on 12 work sheets. I started by clicking cell b5 and then renaming to b5=Name1_1, c5=Name1_2 and so on. This is taking forever. is there a faster way?

____ A______ B C D E F G H I J k L M N O P
5 Name 1
6 Name 2
7 Name 3
8 Name 4
9 Name 5
10 Name 6

[Ron Coderre]

Whatever you're doing.....STOP IMMEDIATELY!

I guarantee there's a better way.
Tell us what you're trying to do...I'm sure we can help.

Regards,
Ron

[DPeter2101]

I have a work book that I keep all my employees names in That is column A. starting at row 5 going to row 75. to the left of that I have column b4 (Jan 1) c4 (Jan2)D4(Jan3) and so on. In the cell below the dates I use conditional formatting to change the back ground color based on (V=Vacation) (T=Tardy) (A=Absent) (PH=Personal Holiday) and so on. On cell that have a T I add notes becouse I my have more than one tardy in a day (start time, brake time, lunch time)I am running a VB script I got from a link on the forum that will pull all the comments and add the to a new work sheet. It pulls Sheet name (January) Address (b5) Name (this is the one I am trying to get. It give the employee name when I add it)
Value (T,V,A,) and Comments. So with out the name I can't tell (very easily) who the notes belong to. I hope this explains.

[Ron Coderre]

Something you might want to consider....

If you have the address of the comment, then you can get the row reference from that address: =ROW(address)

If you have the row, then you can reference the Name using one of these methods:

=INDIRECT(ADDRESS(row_ref,1))
or
=INDEX(A1:A75,row_ref,1)

Is that something you can work with?

Regards,
Ron

[DPeter2101]

Thanks Ron,

I will mess with it and see what I come up with.

Dale

[jaf]

="Name " & row()-4 & "_" & column()-1
do a fill right & then a fill down


--
John
johnf202 at hot mail dot com


"DPeter2101" <DPeter2101.2093ga_1134934500.654@excelforum-nospam.com> wrote
in message news:DPeter2101.2093ga_1134934500.654@excelforum-nospam.com...
>
> I need to rename cells from b5,c5,d5,e5 up to af5 and down 75 rows on 12
> work sheets. I started by clicking cell b5 and then renaming to
> b5=Name1_1, c5=Name1_2 and so on. This is taking forever. is there a
> faster way?
>
> ____ A______ B C D E F G H I J k L M N O P
> 5 Name 1
> 6 Name 2
> 7 Name 3
> 8 Name 4
> 9 Name 5
> 10 Name 6
>
>
> --
> DPeter2101
> ------------------------------------------------------------------------
> DPeter2101's Profile:
> http://www.excelforum.com/member.php...o&userid=29726
> View this thread: http://www.excelforum.com/showthread...hreadid=494466
>