Posts by Rafael F. Silva • 16 points

• 0

  votes

  1

  answer

  525

  views

  A: 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…

  excel vba excel-vba

  answered 4 years, 9 months ago Rafael F. Silva 16

• 0

  votes

  2

  answers

  62

  views

  A: 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;"<>"&"")

  excel

  answered 4 years, 10 months ago Rafael F. Silva 16