Macro to combine two cells into one

[rlsublime]

Hello: How could I combine cell H8 and E10 from the cost accounting Sheet to the Data sheet into one cell from D3 to D13. The code below only pastes E10 into the D3 to D13 range

H8=Name
E10= Address

D3=Name/Address

Please Login or Register  to view this content.

Thanks

[mikerickson]

What do you mean "combine into one cell"? or "one cell from D3 to D13"?
Could you give an example of what is in H8 and H10 and what you want in D3:D13 as a result of that?

[rlsublime]

On the Cost Accounting Sheet H8= Name and E10= Address

Sure. On the Data Sheet D3 = Name & Address

I am trying to get H8 and E10 into D3

Then I just want the same data in D3 to repeat into D4:D13. we could even forget about D4:D13 for now. Thanks for the help!

So I am trying to add H8 to the following code:

Sheets("Cost Accounting").Select
Range("E10").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Data").Select
Range("D3").Select
ActiveSheet.Paste

[jaslake]

Try something like this

Please Login or Register  to view this content.

Substitute your own sheet names.

[mikerickson]

Would putting this formula in Data!D3 work for you, =Accounting!H8 & Accounting!E10

[rlsublime]

That solved it. Thanks