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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying info from worksheet to worksheet if info matches 2
Sum data in multiple cells from two worksheets 2
Find a specified value from a range of cells in another workbook VBA 2
Formula for adding a cell in multiple workbooks 3
grab cell text from multi-tab workbook, show text in another workb 15
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Locating a Worksheet from another Workbook 12
trouble copying a cell from one workbook to a new one 2

Back
Top