Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula from a single cell to a merged cell
Hi All,
I have a sheet with raw data(single cells) and a cover sheet linked to the data by formulas. My cover sheet has merged cells and when I try to insert a formula into one of the merged cells(linking back to the single cells) and then drag down to copy the formula I find the formula skips a row. For example, merged cells A1 and A2(cover sheet) will pick up single cell A1(raw data) but when I drag the formula down to merged cells A3 and A4 it will pick up the data in single cell A3 instead of A2. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tabbing from single cell to merged cell | Excel Discussion (Misc queries) | |||
Very Basic Problem - Merged Cell Equals Contents of a Single Cell | Excel Worksheet Functions | |||
How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
Formula to transfer text from merged cells to single cell? | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) |