Microsoft Office

58K

Solutions

119

Articles & Videos

39K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Related Topics

  1. Microsoft Excel
  2. Microsoft Applications
  3. Outlook
  4. Microsoft Word
  5. Microsoft Access
  6. Visual Basic Classic
  7. Exchange
  8. Spreadsheets
  9. Windows XP
  10. Office / Productivity
Refine results

The formula i am using is if (bk3=bl2, true, false)  I need when I copy down BK3 going to value BK4, BK5, and BL2 to remain).
If I was copying across i would need BK3 to remain and BM2, BN2, and BO2 …

57 views
Instantly Create Instructional Tutorials
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Hello,

Is there a way to automatically have entries in TAB 2 Column D moved to
TAB 1 Column H when a date is entered in TAB 2 Column D?   Matching on
LAST NAME and FIRST NAME in TAB 2 with the …

716 views

I am using PowerPoint 2016 to make a presentation for my Portuguese Class, and I've added a Wipe Animation to one of my objects, but I have noticed there is this fade as the image wipes in. Is it …

326 views

logging on to remote shared linux mailserver using windows 10
incoming/outgoing
server url, port number

username/password

ssl/tls/no security

9 total text boxes

is there a mail app that tells me …

1067 views

Hi,

I'm trying to run a macro to generate a draft email from excel.

The excel files being generated by code are fine- however when opened they display the following error message:
"Excel found …

2637 views

I have been undertaking a number of tests
Vanilla testing against a user case see attached ie script tests.
Can anyone show me examples in excel that related to

Stress Testing
Destructive …

110 views

Hi all.
Hopefully this is possible or something similar.
What I am trying to do is to make (in this case) the Function2!C3 become Function2!C4 or Function2!C5 or Function2!C6 etc based on what the…

326 views

Dear Experts:

I got a formatted table (list object) named 'My_TecDataSheet'. The table has a header row with column labels.

I would like to run a macro that performs the following action:

217 views

Hi, I have created a userform in which i use 5 columns to enter text in that. when i save that data in excel it got saved but when i close it and open it again to enter new data, then the previously …

1517 views

I'm trying to copy and paste a list of real estate homes into Excel and create a new column where the dollar value is divided by the square footage (so it would divide "$260,000" by "2,090" without …

1231 views
Create Professional Looking Email Signatures
Create Professional Looking Email Signatures

Create "Professional HTML Email Signatures" with ease.
7 Day Money Back Guarantee if not 100% Satisfied.
Affordable - Try it out for 7 Days Totally Risk Free.
Installers provided for over 45 Email clients.
Both Windows & MAC Supported.
Highly Recommended!

In an Excel Spreadsheet I have a Column with long Hyperlinks. I wish  to create in VBA a macro to place a Hyperlink with a friendly name in a new column.

Cell A2 contains the first hyperlink and I …

513 views

i have 400k rows needing this

examepl

col B-  Bryan BochesConsumer Products and Technology
col C-  Bryan Boches

desired col B- Consumer Products and Technology

NOTE- the length of col C …

617 views

i have 500000 rows on one column

i need a macro to identify which cells have the word "at" in them. BUT NOT IF ITS PART OF A LARGER WORD. just the word "at"

419 views

I need something that will produce a count value at the end of each filterable item in any spreadsheet.  Assistance is greatly appreciated.

3074 views

Hello,

It appears that having #VALUE! in the reference cell of an Excel formula sometimes results in the formula returning an error and sometimes does not.

For example, the following screenshot …

317 views

my OS is win 10 pro 64 bit and I use Outlook owa and i have the Office 365 Business Essentials account.
In my Outlook email, I use msn email, the free version.  
From time to time I get emails and …

427 views

hi experts, im getting an error with the following formulas;

formula 1.      =SUM(IF(OR(M10:M12="",M10:M12=0),"",SUMPRODUCT(M10:M12)))

formula 2.      =SUM(M10:M12="","",SUM(M10:M12)

could …

1036 views

I have this Macro that works great but I would like to add....
...the condition to delete the column if each cell in the column is empty

(CODE)

For example, these empty columns were left …

525 views

Please provide me with URL addresses explaining how to adjust and set Office 365 spam & junk email settings.

423 views
On Demand Webinar - Networking for the Cloud Era
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

I'm trying to get an output of what users have Skype for business assigned to them from a input list (csv).  I have the command to get each individual user but am having trouble getting this from a …

418 views

IN THSI CASE AN 4 NUMBERS   HAVE 6 COLUMNS PAIR

NEED SELECT SEVERAL DATES AND COUNT  EACH PAIR
EXAMPLE HERE ONE WEEK SELECTED  1W2012     ONE SHEET FOR SELECTED NUMBERS
ONE SHEET FOR COUNT  PAIR …

1214 views

Would anyone be able to help write a script to automate pasting in data from a series of workbooks (attached Questionnaire), into another, (attached 'Results') master report?  
There's one column of …

1119 views

Hi, I wondered if anyone might be able to suggest a solution to this?  I'm trying to find a way to create a chart to show four scores, but in different quadrants of an X-Y axis.  Each quadrant to be …

624 views

i have issues in here when the double 0  (00) is query

Any help on this !Please

611 views

Need to count the pair in an set of 13 rows

there are in 3 columns

like the example in here

3523 views
Show more content
201506-LO-Top-001

Microsoft Office

58K

Solutions

119

Articles & Videos

39K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Related Topics

  1. Microsoft Excel
  2. Microsoft Applications
  3. Outlook
  4. Microsoft Word
  5. Microsoft Access
  6. Visual Basic Classic