Based on a field data information moved to a new tab

[dpiatt]

I have a termination date col. When I enter in that date can the entire row be moved to maybe the next tab called terminations.

[Parth007]

Hi Dpiatt,

Please find attached sheet..
When you open the sheet please enable the macro..

Now once you open.. whatever you enter in the Column "Termination Date"

The entire row will be copied to Termination tab.. do test it..

Mark thread solved if it satisfies...

Else copy the below code & paste it in data sheet .. as shown in the jpeg image

Please Login or Register  to view this content.

[dpiatt]

I am sorry I don't understand this.

[dpiatt]

How do I get the entire row of data to move based on the termination date being filled in?

[Parth007]

Hi Dpiatt,

Just use the sheet i have attached & then after opening the file enable macro contents..
Now once the file is open.. you just fill the Termination date & then press enter.. the row automatically will be moved to other sheet..
give it a try

[dpiatt]

Did I miss where the spreadsheet is? I don't see it attached.

[Parth007]

HI Dpiatt,

Please see the second reply on this thread.. #2

I have attached the sheet "Field Change.xlsm"

[dpiatt]

Thank you Parthoo7 for your patients
I didn't see where to enable the macro just enable contents. My question is when I do enter the term date it does copy to the term tab. How do I get it to move the data and not copy. the first tab I want to be for only current employees and tab termination to have all who have termed.

[Parth007]

You mean to say that It should cut the row & then paste it to other tab????

[dpiatt]

yes that is correct. The term employees do not need to be in the same tab as the active employees

[Parth007]

HI Dpiatt,

Please find the attached Excel file according to your requirenment.....

Mark Thread SOlved if purpose meet with *

[dpiatt]

Thank you Parth007. This works and solved my question. Can you show me the formula so I can learn what you did? If not this is still solved.

[Parth007]

Hi Dpiatt,

You can open the VBA editor & see the code...

Mark this thread solved if its done