• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Request for VBA Code for copying particular data and pasting in separate sheet

N

NSMURTHY

New Member
Sir

I request for VBA code for cutting and copying particular data to other worksheet and
moving below data to that position. I am uploading empdata.xlsx. In the worksheet Column A to D should remain constant and data in E to I wherever remarks are there should move to separate worksheets like transfer, promotion, resigned.

For eg. Mohan transferred. Hence the data of mohan should move to transfer worksheet.
Data of Sweta from E to I has to move in the place of mohan without disturbing column A to D
 

Attachments

  • empdata.xlsx
    9.5 KB · Views: 4
NSMURTHY
Would there be any or fixed number of remarks?
( and eg. Transfer <> transfer )

Verify:
Your eg. Mohan transferred ...
Okay, data would move (not copy) to 'transfer' sheet.
Next. E to I columns step one row up ...
And then ... Sweta will have 'transfer' remark ...
> move >
this will continue as many times as there are data to move up
... hmm?
 
Sir Thanks for ur immediate response. Data in E to J along with headers(name, design etc.) should move to ''transfer'' worksheet in respect of Mohan. Sweta data has to move upwards with remarks blank. Remarks will be like ""Transfer"", Death, Promotion etc about 10 remarks.

Thanks in advance
 
NSMURTHY
Your original was:
Data of Sweta from E to I has to move in the place of mohan without disturbing column A to D
... and if compare with #3 Reply, there are many changes!
You should have clear rules and as well as clear sample result sheets too.
 
You must log in or register to reply here.
Back
Top