Relative addressing
 

Hi

What I want to do is as follows.

In an EXCEL file which I get every month
with a changing number of lines in it, at the
top of the file in any 2 cells, I want to put
the beginning row number in one and the
ending row number in the second,
i.e., 4 in P1 and 688 in P2.

Then in a blank column I want to use the
TEXT function =TEXT(A4,€�000€�) to convert
a number like 4 to text 004. (in the past I
have done a cut and paste down the entire
column).
It would be easier to be able to use the P1
and P2 cells as relative addresses in the
TEXT function, but I cant seem to convince
EXCEL of that.

I would also like to be able to use the
CONCATENATE function to combine
columns A, B, C, G, H, and I into one
column also using the relative addresses
of the beginning and ending rows.

I am hoping to put this into a MACRO to
make it a €œquicker clicker€�.

Thanks,
Dot

Relative addressing
 

DOGMA-DOT wrote:
Hi

What I want to do is as follows.

In an EXCEL file which I get every month
with a changing number of lines in it, at the
top of the file in any 2 cells, I want to put
the beginning row number in one and the
ending row number in the second,
i.e., 4 in P1 and 688 in P2.

Then in a blank column I want to use the
TEXT function =TEXT(A4,"000") to convert
a number like 4 to text 004. (in the past I
have done a cut and paste down the entire
column).
It would be easier to be able to use the P1
and P2 cells as relative addresses in the
TEXT function, but I can't seem to convince
EXCEL of that.

I would also like to be able to use the
CONCATENATE function to combine
columns A, B, C, G, H, and I into one
column also using the relative addresses
of the beginning and ending rows.

I am hoping to put this into a MACRO to
make it a "quicker clicker".

Thanks,
Dot


Hi Dot,

I think I don't understand what you're trying to do, but I think you can try
to use the INDIRECT function...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy