=sumproducta1a5

This Week's Hot Topics

• VBA to find values in several columns, based on common value in a different column, then copy paste to different sheet

  • Started by mlepesant
  • Wednesday at 3:04 PM
  • Replies: 26

  Hello, New to the forum. Good excel skills but almost no VBA experience. I have a file that provides me with Bill of material for different...
• if cell has a value then copy and paste whats in that cell and to the right of it

  • Started by drop05
  • Monday at 4:27 PM
  • Replies: 25

  Hello, a bit new to this. 1. Using VBA im trying to see if there is a way to check if a cell has a value, in my case cell G52, if it has a value...
• force drop-down list only when 1 of 6 possible answers in a different cell is met.

  • Started by CaptainChaos
  • Jun 11, 2021
  • Replies: 23

  I have done some reading on dependent drop down lists, but everything I have found refers to when there are for example 2 or more choices in 1...
• Transfer table filtered data to new worksheet in respective column, 2nd tab data transferred under last row in respective columns.

  • Started by Dave01
  • Monday at 9:56 AM
  • Replies: 23

  [URL unfurl="true"]https://www.dropbox.com/scl/fi/4mp0zl1gu1fiizp6dhse6/test-macro.xlsm?dl=0&rlkey=ejd7qgpi7mcg0cfjb6u6qkcdi[/URL] Hi The link...
• Error with Loop

  • Started by Jeeremy7
  • Wednesday at 5:46 PM
  • Replies: 22

  Hello, I have a problem with one of the loop I'm trying to do and I think it's in the formula but could somoene help me ? Also I saw that some...
• VBA date in local format

  • Started by opislak
  • Jun 11, 2021
  • Replies: 21

  Hello all, As a European, my keyboard layout is set by default to show dates with '-' as in 11-06-2021 or jun-21 I would like to modify the '-'...