Explore Office on Experts Exchange

Expert Solutions for Your Tech Problems

OfficeMicrosoft Office

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a nu...

Read more
  • 73K Content
  • 14K Contributors

Expert Spotlight
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds

Over 40 years of programming experience. Expand my "Full Biography" to see links to some articles I've written.

Solution

Macro to run only if the data is present in Criteria Range

66
Hi Experts,
I am using the following macro to apply advance filter and fetch the data.
Sometimes …
Article

How to Install Microsoft Office Picture Manager in Office 2013

134
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how to install it alongside Office 2013 — at no cost!
Video
How to Create a Table of Contents in Word

How to Create a Table of Contents in Word

7
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the …
Post

i have never seen an worse program the Microsoft outlook. …

21
i have never seen an worse program the Microsoft outlook. Initially I thought it's only me, but …
Solution

Restructure Sheet Columns

byMelbut
63
Experts,

I need help rearranging the column headers on all the sheets to match the original Quote…
Solution

Determine which record has more than 32767 characters

bybfuchs
45
Hi,

I am trying to link a CSV file to my Access database file and it gives me the attached error.…
Solution

Add/change fields in Userform

byMelbut
76
Experts,

I need help making the following changes to my userform.

1. Add  a Discount % field
Post

Heads-up on the latest Office update.   Some Access users …

Heads-up on the latest Office update.   Some Access users are reporting Type Mismatches and Access …
Solution

how to file a request to Microsoft

bynobus
35
i have wiped a customers disk, on which was installed Office2016 - of which we have the code.
Solution

Adds rows to the Sheet Automatically

60
Hi Experts,

I am using the given macro to add 10 rows at the end of the database "Main1DB"…
Solution

Update existing VBA script to Breakdown Data and Transferring to another sheet

byMelbut
58
Experts.


I need help rewriting the current VBA script that will take the quote data from the …
Solution

Performing certain activities on the worksheet at the time of Opening of File using MACRO

48
Hi Experts,

In the attached file I wish a macro which performs the following when the file is …
Solution

Sort two ranges without blank rows

43
Hi
I wanted to sort data without missing rows
I have enclosed a sheet with explanations.
Most …
Solution

Excel: formula if value start with

23
Hello experts,

Could you please help me to set up the following formula:

If A1 value starts …
Post

I recently passed my Microsoft 70-346 Exam.  As part of my …

4
I recently passed my Microsoft 70-346 Exam.  As part of my revision I used Flash Cards that I …
Solution

Dymanic Mutliple List Selection - VBA Excel - Userform Query

29
Hello Team,

I request your kind support for my below example related with Vba Query on Userform.…
Solution

Preselect listbox items and map to another listbox

byMelbut
151
Expert,

I need  a script to add to a user form that maps list of items when one of the items  …
Solution

Multiple Users Working on the same Excel File (having Macro) in Excel 365

19
Hi Experts,

Kindly Advise, how multiple users can work simultaneously on the same file …
Solution

How do I have a cell equal a combination of words in other cells?

bygaz629
11
HI,

TIA.

I have 3 columns: username, givenname, surname

if givenname is Stuart, surname is …
Solution

MS Office VBA: circles shapes count

39
Hello experts,

I am facing the following requiring problem.
How to add count (same process as …

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more