Hi Guys,



I have some code that i'm having bother with and could really do with some help please, this is what it does:

In sheet 1 I double click on the row of column B and that then sends that row to B33 on sheet 2, or if you click on the row of column C it will send the same row to B61 on sheet 2.

The rows on sheet2 are hidden and unhide one by one when the row/s above get populated.

The problem is, i have merged columns B,C & D and the code has stopped working, also i don't understand how the code references where the "copy row" starts at?

Any help would be much appreciated



Thanks

Attached Files

BDC SAMPLE.xlsm (209.0 KB, 12 views)