VBA Code To Cut A Row From One Sheet To Another

[FLani]

VBA Code to cut an entire row(range a-bj)with the criteria of cells containing the word "adjustment deleted" and "reversal adjustment" in column c to another sheet named Deleted adjs. The number of rows differs everyday.

[arlu1201]

Do you want the cut paste to happen on the click of a button or on the selection from a dropdown?

[FLani]

from a click button

[arlu1201]

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

You can also assign the code to a button and run it.

[FLani]

what if there were no deleted adjustments for the day?

[arlu1201]

Then it will check for reversal adjustment. If nothing there too, it will not show any data.

[FLani]

i tried inputting reversal adjustments in one of the cells but it still doesn't work

[arlu1201]

Check the spelling in the code v/s the spelling in your file and if both match, it should work.

[FLani]

Oh. I thing it's copy-pasting for cells that are tagged "reversal adjustments" and "adjustment deleted." problem is it should filter for the cells containing for those words as that Column are for comments such as "adjustment deleted due to erroneous upload."


The code below pretty much captures the gist of what the code should be:

Please Login or Register  to view this content.

The problem with the code above is that i need to click yes for deleting the deleted adj sheet and the code above debugs when there is no deleted adj/reversal

[arlu1201]

Is this data in 2 separate sheets? Its better you explain with the help of a sample file. You didnt attach one at the beginning so i actioned according to your 1st post.

[FLani]

Is this data in 2 separate sheets? Its better you explain with the help of a sample file. You didnt attach one at the beginning so i actioned according to your 1st post.

Hi.

I'm attaching the file. But the lookup files are in a shared folder though. The deletion of cells containing those words are in Day1 button.

[FLani]

I think the problem is that when there are no deleted adjustments and reversal adjustments, the code debugs. And with your code, it only filters "deleted adjustments" and "reversal adjustments" as is. I need to filter it with words containing the two criteria.

[arlu1201]

I am not able to open your zip file since i have an issue with zip files. Maybe you can attach the excel file directly.

And you can also try this code to pick up rows containing that text -

Please Login or Register  to view this content.

[FLani]

Can't upload it file is too large

[FLani]

for some reason this one is not working

[arlu1201]

Are you getting an error?

You do not need to upload your entire file. Just a sample file with dummy data, as long as the format matches the original file.