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

P9678

New Member
Joined
Jan 28, 2014
Messages
2
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
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,140
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top