Search threads

This Week's Hot Topics

• Search multiple spreadsheets and return value

  • Started by Ryan1uk
  • Jul 8, 2020
  • Replies: 32

  Hi, Hope you are all having a lovely day and staying safe. I recently downloaded a template spreadsheet and wanted to change it a little. I have...
• Rows to Columns

  • Started by Gerrit.B
  • Yesterday at 3:56 AM
  • Replies: 30

  In my Excel sheet I have multiple rows with data from the same customer. (orange) I need to transpose this data to one row per customer, where all...
• Advice for userform to sort then go to.....

  • Started by ipbr21054
  • Saturday at 11:18 AM
  • Replies: 26

  Hi, On my worksheet in column B i have a list of vehicles. These vechiles at present are unsorted because column D is in the A-Z sort option...
• Consolidate columns date values into a report as per period considering category variable

  • Started by Luthius
  • Saturday at 4:31 PM
  • Replies: 25

  Hello guys I need to consolidate values distributed underneath columns represented by Days. I just need the consolidation of these values by...
• Separating letters from the end into another cell

  • Started by Gautham A
  • Thursday at 10:33 PM
  • Replies: 25

  Hello In the cell A1,it has the value abcdefghSuccess I want to separate the last 7 letters into a another cell such that A1 will be abcdefgh and...
• Match multiple criteria between 2 workbooks and return "text" if there is no match

  • Started by willow1985
  • Jul 8, 2020
  • Replies: 24

  I will be building a simple Macro in an excel workbook that the user can open and run. The user will have to have the first Workbook open when...