Copy/Paste formulas in merged cells

E

Excel User 123456

I have a spreadsheet that has merged cells in the following cells: A1&B1,
C1&D1, E1&F1,G1&H1,I1&J1 AND K1&L1. A1&B1 and C1&D1 have values, E1&F1
formula is =A1, G1&H1 formula is =C1. When I copy cells E1&F1 and G1&H1 into
cells to the right I1&J1 and K1&L1 the forumla stays the same such as it
treats it as an absolute but there are no $ in the formula. The formula
should change to I1&J1 =E1 and K1&L1 = G1. When I copy this into another
sheet within the workbook it works and when I copy it into another workbook
it works but within the existing sheet it does not. Sorry if this is
confusing - any suggestions?
 
E

Excel User 123456

I forgot to mention that this workbook was originally created in an older
version of excel and this is happening in 2007 version.
 

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

Top