Button click, cut and paste into another spreadsheet data that was filtered

Hi.

I have a code to filter data by an ActiveX textbox.
works well, but need a adatção.

I would use a button that when clicked, the line would be filtered cut and pasted into another tab.


Big File in: http://www.sendspace.com/file/nis5zh

Please Login or Register  to view this content.

thank you!

Hi.

Any idea?

Thank you!!!

Hi.

lacked a description must be re-cut line, not copied
can you do this?
thank you!

Hi.
I tried using the 'Cut' but generated this error

Run-time error '1004 ':
The chosen command can not be performed with multiple selections.
Just select a range and click the command again.

There is another way to eliminate the row that was copied?

Hi.
generated this error

Runtime Error '9 ':
subscript out of range

Thank you!!!

Hi Marreco,

What should we name the Tab and is it in the same book?

Hi.

See file...
http://www.sendspace.com/file/s7j56g

Thank you!!

Hi Marreco,

I would use a button that when clicked, the line would be filtered cut and pasted into another tab.

There's no button on the new file ????

Hi.

I had the attachment problem and had to send a new one.

but would the tab button 'Devolução - Total & Parcial'

the code posted by: rylo ok, but I need the copied data is removed from the guide 'Devolução - Total & Parcial'

Hi Marreco,

Do you want the extractions all on the same sheet or do you want a sheet for each extraction - if you want the latter:

This code goes in a module:

Please Login or Register  to view this content.

And the other code stays in the sheet.

Hi.

In my example, will always be a filtered line, that line should be re-cut the sheet 'Devolução - Total & Parcial' to the worksheet 'Sheet1'

Hi Marreco,

You just want one tab - do you want to put more than one "cutting" on it?

Just remove the naming part from the code I sent you:

From this:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

Hi.

It turns out that your code is not sending the finger to another tab

Thank you!!!

Hi,

Which book did you use? My code works on the first one????????

Hi.

Please Login or Register  to view this content.

When you enter the code in ActiveX Textbox.
A line will be filtered in the worksheet 'Devolução - Total & Parcial' I need a code that after filtering the line is re-cut to the worksheet 'Sheet1'

Hi Marreco,

Try this (all in the source sheet)

Please Login or Register  to view this content.

Hi,
Textbox while typing in the number '600150560 'the row that number has to go to another worksheet.
If I click there goes correctly, is correct?


When I press the 'Enter' key, which is another number that goes to another worksheet.
Another thing, the data must stay one beneath the other, if I filter another number the old data from Sheet1 disappears, and again sits atop the old.

Try it again - I just re-edited the last post!

Hi.
When running is giving the following error:

Runtime Error '9 ':
Subscript form interval

This line

Please Login or Register  to view this content.

Thank you!!

Hi..


When running is giving the following error:
Runtime Error '9 ':
Subscript form interval
This line

Do: i = i + 1:
Thank you!!

Hi.
I had to change so now is the way I need.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

How do I put a msgbox if the users decide not enviaar the data to another tab?
See what I tried but it did not work!

Please Login or Register  to view this content.

Thank you!!

Hi.

I'm try this

Please Login or Register  to view this content.

But....

Compile error:
Invalid use of the word Key, Me

Hi.

If I remove "Me.TextBox1.Value" the code works.

Otherwise generates the error!

Thaks for all!!!

Hi Marreco,

I guess you've got it solved - but, this works nicely - I replaced the Lost Focus with a Change event and now you need to hit the enter button for it to trigger:

Please Login or Register  to view this content.