Posts by Rafael F. Silva • 16 points
2 posts
-
0
votes1
answer525
viewsA: How to copy data from one spreadsheet to another with VBA
Good morning, Follow code that can help: Sub CopyCurrentRegion() Dim dest As Worksheet Dim lr As Variant Dim source As Worksheet Set dest = Sheets("Receita Projetos") Set source = Sheets("Análise de…
-
0
votes2
answers62
viewsA: Get value by taking into account two columns
Can solve with the following formula: =CONT.SES(Gestão!B3:B1000;"Compras";Gestão!H3:H1000;"<>"&"")
excelanswered Rafael F. Silva 16