Search threads

This Week's Hot Topics

• Efficient way to convert table into database friendly data

  • Started by gwoolley0302
  • Monday at 8:05 AM
  • Replies: 34

  Hello, To help build some effective power pivot tables, I [B]*think*[/B] I need to convert my data from Format A to Format B (demonstrated...
• Sum values by date range in multiple columns

  • Started by trimiii
  • Tuesday at 1:52 AM
  • Replies: 31

  Hi, I need help, I am using this formula =SUMPRODUCT(--(R6:R29>=D39), --(R6:R29<=D40), --(B6:B29=B41)) which counts my dates only in one column...
• Two sheets ... copy data from one sheet if criteria met ?

  • Started by lacogada
  • Wednesday at 4:55 PM
  • Replies: 30

  Appreciated the vba code to accomplish task ... beyond my skill level. [ATTACH type="full"]344[/ATTACH] [ATTACH type="full"]345[/ATTACH]
• Pull data from multiple files with multiple unknown sheet names in each

  • Started by cjouban
  • Monday at 3:12 PM
  • Replies: 26

  Sorry if I missed a thread that solves this. I am trying to copy same cell in multiple workbooks with multiple sheets to a new workbook. I've...
• Dropdown behaviour shows different data depending on selection

  • Started by TheJay
  • Sunday at 4:58 PM
  • Replies: 25

  FIrst of all, apologies for the title, I don't know how to change it and realised I wanted to use a tick box instead of a drop down as I was...
• macro

  • Started by chazzerman01
  • Wednesday at 6:16 AM
  • Replies: 22

  does anyone know a macro code that will highlight the whole row that the cursor is on. im using it to make it easier to read values in a table