Search threads

This Week's Hot Topics

• VBA code giving errors and stopping Excel

  • Started by steve400243
  • Thursday at 2:51 PM
  • Replies: 26

  Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
• Disable MsgBox message

  • Started by ipbr21054
  • Tuesday at 4:59 AM
  • Replies: 25

  Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
• Macro Recorder into VBA, Copy Paste Data Filled Cells

  • Started by beginvbaanalyst
  • Feb 9, 2020
  • Replies: 23

  Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
• Number format changes while pasting into a cell

  • Started by nischal4487
  • Thursday at 3:22 AM
  • Replies: 22

  Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
• Collating data

  • Started by Nova1979
  • Feb 9, 2020
  • Replies: 23

  Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
• Sum Multiple Columns Based on Multiple Criteria

  • Started by aread
  • Feb 10, 2020
  • Replies: 22

  I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...