Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|