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