Hi,
I've built a macro that selects information from "sheet2" based on a vlookup formula as entered on "sheet1".
The macro then picks up the relevent field from "sheet2" and pastes it in "sheet1"
The problem is:
The target position on "sheet1" is merged cells (14Rx12C) but the source information comes from "sheet2" is in 1 cell (1Rx1C)
Is there any way that I can transfer the information across, so that it has multiple lines in it?
For example, if you edit a cell, then press "alt+enter" you can write on the "next line" within the cell. But if I do this, it transfers across with a little square in place of the gap.
Any thoughts?
Thanks,
Rusty
This message was edited by Rusty on 2002-04-09 05:51
I've built a macro that selects information from "sheet2" based on a vlookup formula as entered on "sheet1".
The macro then picks up the relevent field from "sheet2" and pastes it in "sheet1"
The problem is:
The target position on "sheet1" is merged cells (14Rx12C) but the source information comes from "sheet2" is in 1 cell (1Rx1C)
Is there any way that I can transfer the information across, so that it has multiple lines in it?
For example, if you edit a cell, then press "alt+enter" you can write on the "next line" within the cell. But if I do this, it transfers across with a little square in place of the gap.
Any thoughts?
Thanks,
Rusty
This message was edited by Rusty on 2002-04-09 05:51