Linking Merged Cells

[Guest]

I know that the first response to my question is going to be "DO NOT use
merged cells!!"

However, with that being said, is there any workaround to linking a merged
cell (b1-b2) from sheet 2 to a merged cell (a1-a3) on sheet 1?

I'm trying to update/create our company's travel request form (sheet 1) and
link it to the travel expense voucher (sheet 2) so that some information
(name, address, destination, purpose, etc.) does not need to be entered
twice, but will automatically appear on the expense voucher once it's been
entered on the request form.

The reason I want to keep my merged cells is because these will be online on
our company intranet, and they need to have very specific formatting to be
printed and processed by our accounting department. Without the merged
cells, data gets entered into one of maybe 5 or 6 possible columns, depending
on where the user clicks to enter the data. Plus, as a user myself, I've
found it frustrating when it appears that I have a 3 inch area for my data,
but I have to click on the very first part of the cell in order to access the
entire field.

Please let me know if there is any way of making this work.

Thanks,
C. Cunningham

 

[Guest]

Have you tried

=Sheet1!A1

Works in my test

 

[Guest]

Aha!! So that's the trick, to reference only the first cell, i.e. A1, instead
of the range, i.e. A1:A3. When I had entered the formula before, I just
clicked on B1:B2, hit the equal sign, and went back and clicked on the merged
cell A1:A3, which enters the formula =Sheet1!A1:A3

Interestingly, the above formula with the cell range does work sometimes,
but not consistently. Using only the first cell reference works consistently
for me.

Thanks so much!