SpreadsheetWeb
  • Features
  • Pricing
  • Blog
  • Customers
  • Try For Free
  • Sign In
    • Customers
    • Trial Users
Select Page
How to combine data from multiple sheets

How to combine data from multiple sheets

by Ilker | Apr 19, 2018 | Excel Macros, Excel Tips & Tricks

Although keeping the data on different sheets help organizing them in terms of look and feel, this approach may cause problems when you need to get data from all sources. VLOOKUP or INDEX functions can’t really help here, and other methods to combine data can be...
How to loop through each character within a string

How to loop through each character within a string

by Ilker | Apr 18, 2018 | Excel Macros, Excel Tips & Tricks

You’ve worked with text data before, used formulas, and created reports, but how do you up your game? Efficiently loop through text data using this simple VBA code to analyze or manipulate strings. Code Sub LoopThroughString() Dim counter As Integer Dim mystring...
Page 4 of 4«1234

Recent Posts

  • How to Roll Dice in Excel in 3 Ways
  • How to Mark a Workbook as Final in Excel - Mark as Final
  • Excel TREND Function
  • Spreadsheets Can be Effective Estimation Software for Many Construction Companies.
  • How to Perform Trend Analysis in Excel

Product

  • Features
  • Pricing
  • Demos
  • Customers

Solutions

  • Marketing
  • Human Resources
  • Finance
  • Sales

Use Cases

  • Online Calculators
  • Sales Quoting
  • Timesheet Apps

Support

  • User Guide
  • FAQ
  • Training Videos
  • Case Studies
  • Tips

Resources

  • Blog
  • Excel Applications
  • Excel Tips & Tricks
  • Excel Formulas
  • Excel Macros
  • Excel Templates

About

  • About Us
  • Contact Us
  • Services
  • Facebook
  • Twitter

© Pagos, Inc. - All rights reserved - Privacy Policy - Terms of Use