Microsoft Applications

44K

Solutions

38K

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

I need to use the sumif function to do the summation for each change in column z in the attached excel sheet
sumif.xlsx
0
Cloud Class® Course: Microsoft Azure 2017
LVL 12
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

I have created a userform and for question 2 I need help writing a subroutine to:
•      Create an array and initialise it
•      Store the count of “Poor”, “Average”, “Good” and “Excellent” in the array
•      Plot a graph to show the number of count for each rating.

Attached is an example file that I have to work on. Any help is much appreciated! :)
Logsheet-8.xlsm
0
On the sample file attached I have data arranged in columns A thru E on Sheet1.  The column E with field name "Deletion Check" is used to check the status of each row for deletion, if it says "Delete" then that row should be deleted in its entirety. I tried three different VBA procedures and those can be seen in modules to achieve the deletion of all those rows that meet the criteria but all procedures raised error.

On Sheet2 I placed the original sample data so after testing the code data set can be reverted back to its original state again.  One quick note here is that initially I was using the procedure "deleteRowswithSelectedText() " without any issues, the way I was using this code from the button was that I was highlighting the column E then running it and it was working pretty good up until this morning but for reasons that are beyond me it stopped working and after that any other code trial generated error even after I tried on brand new files.  

So if any expert can offer a working code either by modifying one of the existing code blocks or adding entirely new code would be much appreciated.
EE_ROWDELETE.xlsm
0
Wanted to calculate Column J based on what's in Column H.  Also Column K based on what's in column I.  I've added some calculations manually to illustrate what it should look like in yellow.

See Attachment.
C--Users-lfreund-Desktop-COUNTING-B.xlsx
0
I wanted to count all the "cancelled" for 2018 in column D for each of the dates listed in column G and have the results on Column J for each date.

See Attachment.
C--Users-lfreund-Desktop-COUNTING-B.xlsx
0
I have tested the connection of client computers to the System Center 2016 (SCCM) 2016 server by typing in the following URL addresses from the client computers and I then receive the results shown in the screenshots below.

Are these the results I am supposed to receive indicating that everything is set up and working properly or what do the results of this test mean based upon this output?

http://<yourservername.domain>/SMS_MP/.sms_aut?mpcert
http://<yoursiteservername.domain>/SMS_MP/.sms_aut?mplist

URL test 1URL test 2
0
Wanted to see if there is an easier way to count dates from two columns.  I have several hundred rows of data that I would want to count dates from.

On column B (Create_Date) and column D (Complete_Date) i wanted to count how many times for example 6/1/18 showed up and for future dates coming up.  I did the manual count on columns G and H to illustrate what I was looking for but wanted to see if this can be done automatically.

See Attachment
C--Users-lfreund-Desktop-Excel-COUN.xlsx
0
I had this question after viewing if a sheet has duplicates rows then put the summary in sheet2.
When i am runing the code(macro) i am getting error message
Run time error '-2147417848  (80010108)':
Automation error
The object invoked has disconneceted from its clients

plz see my sample file and  i am runing the same code  in this file but i am getting error message
sample-file.xlsm
0
I am using the following formula  =INDEX(Sheet1!V:V,MATCH(E6,Sheet1!G:G,0))

Why do I get   #N/A   when it encounters a number vs. text and how can I fix or prevent this from occurring?
I have tried to re-format everything as General but that doesn't seem to help.
0
I want to convert from sheet1 to sheet2. Sheet1 could have more data.
MMM.xlsx
0
Keep up with what's happening at Experts Exchange!
LVL 12
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Hello Experts,

DocumentBeforeSave, DocumentBeforeClose, DocumentChange functionality not working in .docx, but works in .dotm.

How does one make it work?  Help!

The attached file will need its extension changed from .zip to .dotm...
ECT.zip
0
Hi,
I would like a formula modified to ignore zeros or blank cells.
please refer to attached sheet
Many Thanks
Ian
0
Hi all
I want to combine 3 sheet change events in to one macro. With the help from this site, I have a macro with two change events. I want to add one more in to the existing one. The current code is
Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Long
Dim cell As Range
Application.ScreenUpdating = False
Application.EnableEvents = False
On Error GoTo Skip
If Not Intersect(Target, Range("C6:C3000")) Is Nothing Then
    For Each cell In Target.Columns(1).Cells
        r = cell.Row
        If Cells(r, "C") <> "" Then
            If Cells(r, "P") = "" Then
                Cells(r, "P").NumberFormat = "dd/mm/yyyy"
                Cells(r, "P") = Now
            End If
        End If
    Next cell
ElseIf Not Intersect(Target, Range("AB6:AB3000")) Is Nothing Then
    If Target <> "" Then
        If LCase(Target.Value) = "completed" Then
            Target.EntireRow.Hidden = True
        End If
    End If
End If
Skip:
Application.EnableEvents = True
End Sub

Open in new window


My new requirement is to add the following code into the existing one

 If Cells(r, "AB") <> "Allocated back to TL/Site" Then
            If Cells(r, "W") = "" Then
                Cells(r, "W").NumberFormat = "dd/mm/yyyy"
                Cells(r, "W") = Now

Open in new window


Your thoughts please

Regards
0
Highlighted colour is only for understanding purpose, in actual file there is no highlighted colour
I have data in highlighted colour but nothing to do with it
we have to concentrate in coloumn C,D,E,F
copy all the data and paste the data in sheet2 but If coloumn C,D,E,F    contains 124124 then don't paste that data in sheet2
see the result in sheet2
see the sample file
i have to do all this by vba
Sample-File.xlsm
0
Highlighted colour is only for understanding purpose in actual file there is no highlighted colour
we have data in the highlighted colour coloumn but nothing to do with it
we have to concentrate on Coloumn C,D,E,F
if Coloumn C,D,E,F are same then change the data to 124124
see the result in sheet2
I want the result in same sheet not in sheet2, for understanding purpose I have putted the result in sheet2
Sample-file4.xlsm
0
Highlighted colour is only for understanding purpose, in actual file there is no highlighted colour
in the highlighted colour coloumn we have data  but nothing to do with it
we have to concentrate on coloumn C,D,E,F
if alphabetical data is found  then change the data to 124124
see the result in sheet2
I have putted the result in sheet2 but I want the result in same sheet not in sheet2
See the sample file
I have to do all this by vba
Sample-file3.xlsm
0
Hi everyone!

As of now, I have created a UserForm and it works exactly as I want to but I can only have one row of data.

sample.JPG
If I try to submit another entry it will overwrite the data in row 2.

I want to have this code add the new data onto the next empty row.

I have attached an example file. Any help is much appreciated! :)
Example.xlsm
1
I was given the following macro to copy certain data from Sheet1 to Sheet2.

It basically works except that I need it to copy the values in the cells in Sheet1 to Sheet2.

Because the cells in Sheet1 contain formulas, it's copying the formulas over, which I don't want.



Sub CopyData()
Dim sws As Worksheet, dws As Worksheet
Dim lr As Long, i As Long

Application.ScreenUpdating = False

Set sws = Sheets("Sheet1")
Set dws = Sheets("Sheet2")
lr = sws.UsedRange.Rows.Count

For i = 3 To lr
    If sws.Cells(i, 5) <> "" Or sws.Cells(i, 6) <> "" Or sws.Cells(i, 7) <> "" Then
       sws.Range("A" & i & ":G" & i).Copy dws.Range("A" & Rows.Count).End(3)(2)
    End If
Next i
Application.ScreenUpdating = True
End Sub
0
I am looking for an option in excel to get the below :

1) New columns should be inserted at a click of a button between two specified columns.
2) Once we are done with our work on the newly inserted columns, there should be a button to delete the columns
0
Cloud Class® Course: Certified Penetration Testing
LVL 12
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Hi. I am trying to do something fairly simple in Excel 2010 using Vlookup but ran into the 255 character limit.  I checked posts online and found that index/match should work to do the same functionality without the 255 character limit but I am still getting an error.  

I have attached my test Excel file but I also attached an image showing the sheet, as well as the formula displays.

vlookup and match testing
testing_excel_vlookup_070518.xlsm

I have tried many iterations of index and match but I can't get this to work.  Can anyone see what I am doing wrong?

Thank you!
Alexis
0
I had this question after viewing Excel - Floating Command Button.

Hi,

How do I do the same for multiple buttons? lets say I have button 1, button 2 and button 3?
0
I am trying to use Sql Server Migration Assistant 7.8 for Access to migrate access tables from Access to SQL Server 17 and then link the tables in Access to the new SQL back end tables.  SSMA is able to create the SQL Database, create the tables, and migrate the data successfully using trusted windwos connection. However the Linking step is failing as I am getting a Connection Failed error from SQL... See Error Below:

Error Message
Research show this may be caused by miss-configuration of  TLS 1.2. I have made sure that both my workstation and my server have  TLS 1.2 to be enabled for both client and server.   Also I did not install Sql Native Client as Microsoft has deprecated it, Instead, I installed Microsoft's un-depricated ODBC for SQL driver  MSODBSSQL_17.  I can go into the Access database after the data has been migrated and manually create links to tables in the new SQL back end.

Any help getting around this error would be appreciated.
0
I have 2 sheets below and need a formula in the last Column (Cap Date) on sheet 2. When the Capped days (Persistent number) = the total count of a UPC from sheet 1 to return  sheet 1, Column2, scan date.  


Sheet 1
UPC      Scan Date
10      01/01/18
15      01/01/18
20      01/01/18
25      01/01/18
10      01/02/18
20      01/02/18
25      01/02/18
10      01/03/18
11      01/03/18
12      01/03/18
15      01/03/18
25      01/03/18

Sheet 2
UPC      Total Scans      Capped at (Days)      Cap Date
10                             3                            2      01/02/18
11                             1                            2       
12                           1                            2  
15                              2                           1              01/01/18
20                              2                           1       01/01/18
25                              3                           2       01/02/18
0
How can I remove or truncate the spaces or what I assume are carriage returns within the column? I attached an example.
Capture.PNG
0
Parse string to the right Example: "Welcome  Agency Members" Need to extract "Agency Members" to display
0

Microsoft Applications

44K

Solutions

38K

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.