Can rows/ columns containing merged cells be transfered to another worksheet through VB codes or other means.

[P9678]

Hello,

I've searched to try and find the answer to this question but not having much joy so any help will be greatly appreciated.
I'm relartively new to excel VB codes and my seemingly impossible task is shown below:

* I have a list of data each one has 6 rows of data.

* (Rows A,B,C,FG,H,I,J,K are merged into 1 cell)
*Rows D & Eare split cells using all 6 rows.


Once the end column K on worksheet "new work" is updated to 'Complete' from a drop down box I would like all of the data on the 6 rows (containing merged cells) to be moved to another worksheet/tab called "complete".
Thank you very much for any help you can offer.
Pete

 

[JackDanIce]

Welcome to the board

It is not easy to use VBA when working with merged cells and generally speaking advice is to avoid merged cells. This doesn't give solution to your question, but I'd recommend you consider a different layout and not use merged cells if you want a macro based solution.

 

[P9678]

Hi JackDanIce,
Thank you very much for taking the time to reply i really appreciate it.
I've now rearranged my spreadsheet to only use 1 row for each entry of data.

What i'm now trying to achieve is an automated way of moving work into an allocated worksheet. In Column J i have a 'status' heading. There are 3 options in a drop down box:
New in
Allocated
Complete

I'm hoping that once one of these is selected the whole row will move to the approriate worksheet with the same name.
If the process could also be reversed that would be amazing e.g. If 'complete' work was amended to 'allocated' it would move back to that worksheet.

Thanks again!!!!
Pete