| 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 | |
|
|
Linear Mode
