Merged Columns and filling cells with data

[thatlem]

I have a spreadsheet where I was forced to merge cells together. I then have a second spreadsheet in which I enter data. The first sheet with merged cells autopopulates when the data is entered into the second sheet.

I know I can write a formula to pull in the data, but because the spreadsheet now has merged cells, dragging the formula across the sheet skips every other cell (Ignores the merge). So instead of data from d3, d4, d5... I get data from d3, d5, d7....

Is there a way to force the merged cells to function as a single cell with regard to dragging the formula. I really don't want to have to manually manipulate 5 years worth of data.

Thanks

 

[chergh]

Get rid of the merged cells I've never seen a real reason to use them yet.

 

[thatlem]

Well bully for you. I can't believe you even took the time to respond to my query. Fortunately I identified a solution without your "help"

 

[chergh]

Well bully for you. I can't believe you even took the time to respond to my query. Fortunately I identified a solution without your "help"

Well I had expected you to come back with what you needed merged cells for so I could give you a worksround. If you want to do anything in future you still have to deal with the same issues.

Anyway enjoy your bad design and it's great to see you posting your "solution" to help other people with a similar issue.