Insert text with connection to other cells

[Dani_LobP]

Hello,

I have a table with some columns, and I would like to make some text below it connected to some cells.

Example:

Name	Number	Street	Age
Bob	2​	Close	24​
Rob	3​	Far	64​
Robert	5​	Near	32​
Bobert	7​	Here	24​

Idea is to place below something like this:
Range("A6").value="Hi"&" "&Range...
in order to make the sentence "Hi Bob, we sent 2 items requested to Close."

The way i try doing it works, but I cant seem to figure out how to fill down so it uses next row of data without having to change manually all cells in formula.

Hope it makes sense.

Thanks in advance.

Regards,
Dani

 

[Muhammad_Usman]

Hey Dani_LobP

Check out this Solution!

Book1.xlsm
	A	B	C	D	E
1	Bob	2	Close	24	Hi Bob, we sent 2 items requested to Close.
2	Rob	3	Far	64	Hi Rob, we sent 3 items requested to Far.
3	Robert	5	Near	32	Hi Robert, we sent 5 items requested to Near.
4	Bobert	7	Here	24	Hi Bobert, we sent 7 items requested to Here.
Sheet2

Cell Formulas
Range	Formula
E1:E4	E1	=CONCATENATE("Hi ", A1,", we sent ",B1," items requested to ",C1, ".")

Feel to ask if any confusion.

 

[Dani_LobP]

Hey Dani_LobP

Check out this Solution!

Book1.xlsm
	A	B	C	D	E
1	Bob	2	Close	24	Hi Bob, we sent 2 items requested to Close.
2	Rob	3	Far	64	Hi Rob, we sent 3 items requested to Far.
3	Robert	5	Near	32	Hi Robert, we sent 5 items requested to Near.
4	Bobert	7	Here	24	Hi Bobert, we sent 7 items requested to Here.
Sheet2

Cell Formulas
Range	Formula
E1:E4	E1	=CONCATENATE("Hi ", A1,", we sent ",B1," items requested to ",C1, ".")

Feel to ask if any confusion.

Oh yes, great! thanks..

Already forgot about Concatenate feature... was obsessed to try make it fancy with VBA.. :D thanks again