Search threads

This Week's Hot Topics

• find many based on a certain criteria

  • Started by Trevor3007
  • Nov 14, 2019
  • Replies: 36

  good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
• 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...
• Importing multiple excel files into one spreadsheet

  • Started by Woofy_McWoof_Woof
  • Nov 13, 2019
  • Replies: 29

  Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
• 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...
• 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...
• How to copy multiple rows using If

  • Started by Diving_Dan
  • Nov 14, 2019
  • Replies: 22

  Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...