select two cells from workbook and have them join in another workb

B

bigdaddy3

i have cell D6 and cell F6 to select in 1 workbook and then when another
workbook is opened by a macro i want to paste D6 and F6 into 1 cell together
G5 ie name fred and bloggs becomes fred bloggs.Both workbooks would be open.
 
B

bigdaddy3

Hi Roger
thankyou for that just right
--
BD3


Roger Govier said:
Hi

Try
=[Book1.xls]Sheet1!D6&" "&[Book1.xls]Sheet1!F6
Regards

Roger Govier

i have cell D6 and cell F6 to select in 1 workbook and then when another
workbook is opened by a macro i want to paste D6 and F6 into 1 cell together
G5 ie name fred and bloggs becomes fred bloggs.Both workbooks would be open.
Click to expand...
Click to expand...
 
Top