Dear All,

I have been reading carefully around the forum -great resources! - BUT I couldn't find the solution of my current problem...

Please help with the following:

I want to copy a column from a worksheet to other upcoming new worksheets
- BUT the upcoming new worksheets will have more rows for some column!!
- a copy/paste will then not keep the order !! - The comments in this column will have to "move" otherwise they won't reflect to the correct line!

Still, it should be possible to do it by taking as a reference the formatting of column A (that is always merged into 1 row although the other columns shows several rows).

Please help - see enclosed - the example file I have made for this problem....
(column C will have to be moved -while keeping the lines order * Excel_myproblem.xlsxfrom worksheet 1 to Worksheet 2 in this example....)

Thanks a lot in advance !!
I need to know as early as possible if this is possible....otherwise i need to move to another strategy for doing what i need - involvment much more manual hard work

Best'