Relative addressing

[DOGMA-DOT]

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

[Franz Verga]

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