Hi...
I have two worksheets.
I need to copy the data from column 'A' to 'F' worksheet called "FIN" to the worksheet called 'Rlt_Pendencia' case in column 'F' worksheet called "FIN", has cells equals "In debito"
Thank you!!!
Please Login or Register to view this content.
Last edited by marreco; 09-08-2012 at 11:14 AM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Hi.
Any idea?
Thank you!!!
Hi, marreco,
you donīt give order what is to be copied in the code-sniplet. Please try it like this:
Ciao,Please Login or Register to view this content.
Holger
Hi.
was great!!
how do I remove the filter (called the planiliha ("FIN")), after running the macro?
thank you!
Hi, marecco,
as you do not leave the sheet within this sniplet please add this line at the end (just before End Sub):
If you have switched to another worksheet, please fully qualify the Sheet Name and the range before you use Autofilter to switch it off. I would recommend you check in advance if any filter is active:Please Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
Hi.
Great, thank you very much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks