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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - select two cells from workbook and have them join in another workb (https://www.excelbanter.com/excel-worksheet-functions/48018-select-two-cells-workbook-have-them-join-another-workb.html)

bigdaddy3

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

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.
--
BD3

Roger Govier

Hi

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

Roger Govier

bigdaddy3 wrote:
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.

bigdaddy3

Hi Roger
thankyou for that just right
--
BD3

"Roger Govier" wrote:

Hi

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

Roger Govier

bigdaddy3 wrote:
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.

All times are GMT +1. The time now is 01:28 PM.