Microsoft Applications

43K

Solutions

37K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Share tech news, updates, or what's on your mind.

Sign up to Post

Dear Experts,

I really need your help in applying the formula to make the Code sheet working.

I have attached the sheet for your reference.

As per the sheet I need to generate code according to combo box selection in various columns and its references are located in different sheets.

I have applied the formula but it does not work as expected.

Can anyone help me on this task?

(Remark : I have used only Index and Match functions. You may suggest VBA if required)

:)
Regards,
D Patel
Code-Template.xlsx
0
Get MySQL database support online, now!
LVL 3
Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Dear Experts:

I would like to extract the substring located between the 8th and the 9th underscore from the right, i.e. 90-235-58-22

I got a user-defined function for that, but I also would like to have a formula. Hope this is feasible!

G:\KLS_Allgemein\DMD\PM_2_3\IFU_Bos_Driver_90-235-58-22_REV_2_RD_2016-02_5s_SF_S24_bw.pdf

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
0
My Tables has the following fields:
ERRC, Stock Nbr, Count of Stock, Qty Requested and Qty of Stock.

My query needs to group by ERRC, count records for each ERRC, Count Unique Stock for Errc, multiple unique stock * Qty request
0
I am trying to migrate off of Lync server 2010 to Skype for Business server 2015.  I have created a new server have patched the server all the way with the windows updates and then started my Skype for Business install.  I was running through the Skype for Business Server 2015 Deployment Wizard.  I have already prepared AD with no issues and then moved onto Install or Update Skype for Business Server System.  However it did not detect one of the prerequisites which is KB2982006.  I have tried installing it and I keep getting "The update is not applicable to your computer"  I have tried installing all of the prerequisites for this file but cannot install one prerequisites that it needs which is KB2919442.  It gives me the same error.  I have done a sfc /scannow with no errors, tried windows update troubleshooter with no luck.  Any suggestions.
0
Columns("B:H").Select
    Selection.Delete Shift:=xlToLeft

I used above code to select columns from B to H and delete it. But its getting select from A to I and deleting all from A-I.

Please advise me code correction.
0
Hi

I need to create an Excel CSV file.  This CSV file has a column of large numbers .....  example 2100000000003   .

I wish for the numbers to be represented in full view.   I need to see the full number so that I know that each number is unique.
 Excel insists on changing the  number to scientific notation.  Of course, they all look the same then.

The application accepting this CSV file will read the numbers as text,

Question... How do I save the CSV file so that I open it again,  I will see the full number instead of the scientific notation representation.

Thank you.
0
Hi,  When I enter something new or change something in Cell B1, I would like Cell C1 to be shaded yellow.   I tried this with Conditional Formatting, but I believe that you need to have a specific value in order for conditional formatting to trigger the change.  I want this shading in C1 to be triggered if anything is added or changed in B1.   In other words, B1 could be blank or already populated, so if there is any change entered to that cell, I need C1 to alert me by shading it yellow.  I then need to copy it to subsequent rows.  

I hope my request makes sense and is clear.

Thank you!
0
Hi Experts!

I want to adjust the width of the all the columns from C2 up to the last column
these are my code

Dim LastColumn As Long
LastColumn = ActiveSheet.UsedRange.Columns(ActiveSheet.UsedRange.Columns.Count).Column
Columns("C2", LastColumn).EntireColumn.AutoFit

My problem is
  A.   I have a run -time error on this part
  Columns("C2", LastColumn).EntireColumn.AutoFit
  B.   I have a group cells and I want it to remain it group as I autofit all the cells
0
About a month ago I began having problems with booting up this computer. The computer was infected with a virus/Trojan. I was able to successfully remove the infection but at the cost of the operating system. Large chunks of the operating system damaged because of the cleansing.

I was able to manually retrieve all of the information off of the old drive to the new. I talked to a representative of Microsoft who helped me pull the emails from the old hard drive to the new for one of my email accounts.

The following day I noticed I didn't have any email addresses. I also discovered that a lot of the emails I thought should be there belonging to that account were not.

I am looking for a way to retrieve my contacts and a clean and safe way to retrieve all of the email belonging to this account and how to restore the other accounts along with their associated email.

Any suggestions and or comments are greatly appreciated!
0
Hi,

I am making a Pivot table. I have three columns - Title, CTC, and Medical.

On showing Title in Row section of Pivot, I want to show CTC, then Medical, and then Medical as PerCent of CTC.
How :)

Attached file for reference.

Thanks,
San.
Pivot---PerCent-of-Parent-Column.xlsx
0
Veeam Task Manager for Hyper-V
LVL 1
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Dear Experts:

I got the following file paths entered in column A

M:\KLS_General\DMD\PM_1\MyFile_Final_2.pdf
M:\KLS_General_17\DMD\PM_2_3\MyFile2.pdf
M:\KLS_General_2\DMD\PM_4_5_6\MyFile6_Final_23072017.pdf

Is it possible to extract the substrings after the fourth (4th) back slash using a formula. I got a macro for this purpose but I wonder whether the same could be achieved using a formula, ie. applying the formula the results would be as follows:

MyFile_Final_2.pdf
MyFile2.pdf
MyFile6_Final_23072017.pdf

Help is much appreciated.

Thank you very much in advance.

Regards, Andreas
0
Hi,

There are two columns Date and Sale. I want total of Sale for the month of Feb from date column, without creating extra column for Feb. Also without Array function. Is it possible?

File is attached.

Thanks,

San.
0
Can you please help me regarding all the cells?
What I want is To highlight cell form range ("C7" to the last row )

this is my code

Dim LastRow
LastRow = ActiveSheet.UsedRange.Rows.Count
    Dim x As Range
' How can I declare a range  from the Range ("C6 up to the last row of KHL") not just 50
    Set x = Worksheets("Product").Range("C6:KHL50").Cells
    Dim sRange As Range
How can I declare a range  from the Range ("A6 up to the last row of B") not just 100
    Set sRange = Range("A6:B100")
    Application.ScreenUpdating = False
    With ActiveCell
        If InRange(ActiveCell, sRange) Then
          MsgBox ("Cannot Mark This Area")
        Else
        ' Highlight the entire sheets that contain the active cell
          x.Interior.Color = RGB(255, 255, 0)
          sRange.Interior.ColorIndex = xlNone
       End If
    End With
  Application.ScreenUpdating = True
0
Hi,
There is a table  - its called “sub-productLevel”  - it has sales data for the combination of customer + subproduct + month

Now there is a table called productLevel – which rolls up all the subproduct underneath it.

I did create pivots on both those data. Sometimes there is a data discrepancy between the product level and sub-product level.
How do I create a pivot:
1.      which is based of the subProductLevel tab, but also references the productLevel tab.
2.      If there is a difference between the subProductLevel and productLevel, it shows it by the name “xdiff”
3.      So that finally when the diff is added up, the subProductLevel data total match exactly to the productLevel data

so explain the above, I just added a dummy xdiff row to the subProductLevel data to make the pivot show what I needed here...

Thanks
pvtSol.xlsx
0
Hi all,
we are currently running windows 7 x64, 95% of user computers have HP Elitebook laptops (850 users across few different countries), have anyone done project plan for a windows 10 upgrade? what issues were faced and whats there to avoid or take into account?

will rollout window 10 and office 2016 as a package.
0
We are looking for a good project scheduling program that is similar to the attached image below. We have a Manager that wants it a certain way and does not like Microsoft Project or other ones we have tried.

Does anyone that any good suggestions for a Scheduling Program or one that is like the one below?

Proj Example
0
SharePoint Online Question -   Regarding auto resizing of images, ppt and videos in SPO.     I currently have embedded videos, PowerPoint decks and images in a site.   What needs to be done to enable these to auto "resize" when the size/resolution is changed?
0
A user wants to know how secure the password system for files protected by Excel's built-in password protection.

They asked:
" If I use a 2003 password protected excel workbook, can it be hacked?"
0
Ms Project 2010 crashing on windows 7 enterprise.  how to fix this?  reimage didn't help.

from application event viewer:


Unexpected or missing value (name: 'PackageName', value: '') in key 'HKLM\Software\Classes\Installer\Products\C313169CB933B504A9B878815848CEDA\SourceList'

Unexpected or missing value (name: 'PackageName', value: '') in key 'HKLM\Software\Classes\Installer\Products\A1A2502679901BE4D91D71F6A2A203B2\SourceList'

Faulting process id: 0x504
Faulting application start time: 0x01d30f8cdf069df9 Faulting application path: C:\Program Files (x86)\Microsoft Office\Office14\WINPROJ.EXE Faulting module path: C:\Program Files (x86)\Microsoft Office\Office14\WINPROJ.EXE Report Id: 286b3f04-7b80-11e7-8ba1-e09d31314280

Faulting application name: WINPROJ.EXE, version: 14.0.4751.1000, time stamp: 0x4b8e2648 Faulting module name: WINPROJ.EXE, version: 14.0.4751.1000, time stamp: 0x4b8e2648 Exception code: 0xc0000005 Fault offset: 0x004a1b22 Faulting process id: 0x11bc Faulting application start time: 0x01d30f8c5c1ab14d Faulting application path: C:\Program Files (x86)\Microsoft Office\Office14\WINPROJ.EXE Faulting module path: C:\Program Files (x86)\Microsoft Office\Office14\WINPROJ.EXE Report Id: c2c8ddf3-7b7f-11e7-8ba1-e09d31314280
0
Will your db performance match your db growth?
LVL 3
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

I did setup DFS replication between two folders from two servers. After a week, I created diagnostic report and there were no errors and there were no backlogged files on both servers.
Then I went and compared those two folders in size, file/folder numbers. They all matched.
Then I dismantled the replication by deleting the replication group.
When I checked DfsrPrivate folder, there were so many files in staging folder.
What are they? Are they going to be disappeared or do I need to delete them manually?
0
Hi,

How do I reliably calculate the number of weeks past since the last Monday of March, so for example this year on todays date would be 19, as week 1 would include 27/3/2017 which is the last Monday in march.

The below formula I created works fine up to end of the year, but then for 2018 it goes mad!.

=ROUNDDOWN((E1-DATE(YEAR(E1),1,1)-((DATE(YEAR(E1),4,8)-WEEKDAY(DATE(YEAR(E1),4,6))-7)-DATE(YEAR(E1),1,1)))/7,0)+1

Whereas E1 currently contains todays date 5/8/2017 and correctly shows 20.  This works until 25/12/2017 where it shows Week 40.  For 1/1/2018 it shows minus 1 and increasing.
0
We need to extract a table from a PDF document into Excel and clean it up by moving columns around and deleting unnecessary rows, and then paste the results into a new Word file. This task is done several times weekly, so we would like to create a macro to automate the task.

Details:
  1. The number of columns in Excel, and their position in the table may vary, but the column headings that we need are always named the same.
  1. The Excel table will always reside in Sheet2.

Macro steps;
  1. Move Column called IDENT to right of Column called NAME
  1. Move Column called TYPE to right of Column called IDENT
  1. Move Column called LATITUDE to right of Column called TYPE
  1. Move Column called LONGITUDE to right of Column called LATITUDE
  1. Remove all remaining columns to right of LONGITUDE that contain data
  1. Under Column B (NAME) find first row with "-" in cell, and delete this entire row and all subsequent entire rows to last row containing any data
  1. Copy the table, and then paste `as text only`, into a new Word file

I have attached a sample of the Excel table pre-cleanup.

Thanks!
Andrea
EE_Table_Cleanup.xlsx
0
I am looking for a macro that will evaluate the contents of a cell and for each word (which will always be a state and each will be separated by a space [however some state are two words - New York, New Mexico]), convert that word (state)to its abbreviation. I assume I will need a table somewhere in my model that will show the state name and its abbreviation.

For example,
if cell A1 contains:
Alabama Connecticut New York California New Mexico Washington D.C. Florida

then the macro should return the following in cell B1:
AL CT NY CA NM DC FL
0
Hi

I am using Microsoft word 2013 and typing in English language. When I copy lyrics  from a website which is in a different language (to the same document). I get ???????? rather than the actual lyrics .
Please let me know how to resolve this. Are there any settings that I need to enable. Any help would be great.

Thanks
0
Hi All,

Thank you all for your help with this issue. We have a users that cant access a new blank word template.
Ive replaced/renamed docm.& reg key any ideas
Word-New-template-Issue.PNG
0

Microsoft Applications

43K

Solutions

37K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.