Explore Excel on Experts Exchange

Expert Solutions for Your Tech Problems

ExcelMicrosoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user int...

Read more
  • 144K Content
  • 12K Contributors

Expert Spotlight
Finance Analyst

30 years in Financial Services and Management Accounting. CIMA trained but prefer the technical or system aspects of accounting.

Troubleshooting Solution

Macro to segregate space tab separated fields - meeting specific text condition

60

Dear experts,

 

[For the purpose of this explanation, let me say when I open the file with file type

Article

How to quickly and accurately populate Word documents with Excel data, charts, and images (including Automated Bookmark generation)

33
How to quickly and accurately populate Word documents with Excel data, charts and images
Video
Post

The Course of the Month for May: Comp TIA A+!  Prepare for …

The Course of the Month for May: Comp TIA A+!
Prepare for the 220-901 & 220-902 exams in the month…
Troubleshooting Solution

Excel Zone Expert Discussion, Number 33

353
This thread is for general discussion about all things related to the Excel zone and its experts. …
Article

Getting your EE Ranking statistics in Excel

byQlemo
90
The code described here does no longer work. Please see replacement Article:
Troubleshooting Solution

Excel VBA

23

I have a spreadsheet with a number of columns and rows as an exported set of values

I need to carry

Article

Six Reasons Why Your VLOOKUP or HLOOKUP Formula Does Not Work

21
by Patrick G. Matthews


Introduction

VLOOKUP is a tremendously useful function …
Article

Creating a custom Welcome form in Excel

Not too long ago I wrote this article on doing the same thing in MS Access (https://www.experts-exchange.com/articles/38421/Making-your-Database-More-User-Friendly.html). I found that a similar "Welcome" screen makes Excel worksheets "friendlier" as well.
Troubleshooting Solution

Amendment of MAcro to include the filename from where the records has been copied and pasted

31

Dear experts,


Below is a macro which was put together to perform the operation of putting all files

Article
Oh no

A Guide to Writing Understandable and Maintainable VBA Code

14
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Video
Video
Video
Post

Once upon a time at a core conference this …

1
Once upon a time at a core conference this
Troubleshooting Solution

Display if item is new

bybfuchs
18

Hi Experts,

I have a list of items which contains many duplicates.

List consists of ASIN's and many

Video
Post

New member today got a solution today.  After searching …

New member today got a solution today.

After searching the net for help it became apparent
Post

Archiving with tar and VBA The old Unix archiving and …

Archiving with tar and VBAThe old Unix archiving and compress tool tar also comes …
Article

Collating worksheets from one or more workbooks into a summary file

byDave
29
IntroductionOne of the more common requests in the online VBA forums is for code that …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more