Microsoft Office

68K

Solutions

42K

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.

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

Sign up to Post

I have an Excel spreadsheet that I would like to update the Count column (E) with a sequence number starting with 1  when the OMHA Appeal Number column (A) value changes.

Image
0
Should you be charging more for IT Services?
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

I need to add a fourth key to this simple sorting macro but it bugs when I add a fourth key. Is there a way around that?

Sub SortSelection()
Selection.Sort key1:=[A3], Order1:=xlAscending, _
               key2:=[B3], Order2:=xlAscending, _
               key3:=[C3], Order3:=xlAscending ', _
               'key4:=[L3], Order4:=xlAscending
End Sub

Open in new window

0
I have been trying to write a macro that searches across date headers and then on correct date will search down that column for selected time.
  See the attachment.  
The date column headers will of course change with the date.  
Check out the workbook and see if you can help me.. I have been struggling with search functions..

Thanks,
NormExperts_Exch_help.xlsm
0
my manager is trying directly sending  excel file by opening file going to file -send
send as attachment , it attaches in outlook, but when he tries to open excel file when attached in outlook before sending it takes pretty long time in fact it doesnt open, while on the other hand if he opnes outlook and attach excel file , it opens right away, is there any reason

I disabled the add in but it didn't help
0
Hello experts,

I have the attached document related to my shortcuts.
I was wondering how to:
1-Set up print zone and define front related to sheet 1 and back related to sheet 2
So the result will be two sheets in a the same doc.

This will allows me to have in a single doc if I generate a pdf or if I print document sheet 1 and sheet 2.
If you have questions, please contact me.
Thank you for your help.
1-Key-shortcuts-LDI.xlsx
0
Hi,

How can I set conditional formatting in excel to highlight a cell based on the value max/min of within it's own range? (I have included an excel that does this but I had to include additional formulas outside the conditional formatting in order to get the effect I want.  I'm trying to get the same effect but only using conditional formatting.
ConditionalFormattingMAXMIN.xlsx
0
I am running Office 365 on my Windows 10 laptop.   I have the "Auto-Complete" option checked in my Options under Mail.  The Auto-Complete works fine, but every time I close down and restart Outlook it seems to automatically empty the Auto-Complete data ... and I need to manually re-enter the email addresses again (just once).  I can't find any setting that tells it to empty the Auto-Complete when Outlook shuts down.  This never used to happen.  Please help.

Thanks,

Phil
0
Is there a way to PREVENT users from downloading and installing the Microsoft Teams app on Windows 10?
0
Word 2016 Reading View disabled editing in most recent version.

Is there any hack / registry hack / add-on that can bring it back?

Thanks!

OT
0
In office 365, on OWA, it has an archive folder.  Exactly what purpose does this serve?  Isn't archiving to alleviate the space from the server?  Then what is the function of this folder.  Is it extra space from Microsoft?
0
CompTIA Cloud+
LVL 13
CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

I have a date in cell A1.
It's the hire date of one of my employees: 9/12/2014.
Her paid vacation days -- if not used -- always expire 364 days later.
Today is 9/17/19.
How do I write a formula (not an array) to return the expiration date -- and for every future year as the year changes -- in my spreadsheet?
For example, in today's case the result cell A2 should return the date 09/11/2020.
In a few months on January 1, 2020, I would still want the expiration date to remain 09/11/2020.
On 9/12/2020, I would want the expiration date to change and then be 09/11/2021.

Hope this makes sense, and thanks in advance!
0
Hello experts,

I am looking for a procedure that allows me to delete blank sheets:

Sub Delete_Blank_Sheets()

Dim oWS As Worksheet
    
    On Error GoTo Error_Routine
    
    For Each oWS In Worksheets
        If WorksheetFunction.CountA(oWS.Cells) = 0 Then
            Application.DisplayAlerts = False
            oWS.Delete
            Application.DisplayAlerts = True
        End If
    Next oWS
    
Exit Sub
Error_Routine:
    MsgBox Err.Description, vbExclamation, "Something went wrong!"
    Application.ScreenUpdating = True

End Sub

Open in new window

I would like to take as a reference to cover the following:
-Msgbox: "Are you sure you want to delete all sheets except active one?" If cancel exit sub
-Delete all sheets except activesheet
If you have questions, please contact me.
Thank you for your help.
0
Hello experts,
I was wondering how to manage the following issue with excel tables:
I select row 2 and send Ctrl + to insert a new row above and I get format of header instead of having format of row 2.
20190917_230123-screenshot.pngIf you have advice on this please let me know.
I attached dummy file.
Thank you for your help.
Table_20190917_225900.xlsx
0
Folks,
I need a way to designate that when a workbook opens cell G27 starts blinking. I've looked around and found some examples but I couldn't get anything to work.
0
I have a daily workbook that starts out with five blank worksheets with the same 7 cells designated for data to be entered in each worksheet.  As a sample is tested and data is entered in the 7 designated cells, the worksheet is renamed with the lot number of the sample.  

I would like to add a summary worksheet that will contain the data from the five worksheets, and list the 7 values from each worksheet on a single row.  

In the summary worksheet, is there a way to address the different worksheets even though the worksheet name has been changed from Sheet1 to LotNo123, Sheet2 to LotNo456, etc.?  The lot number will always be something different.  Also, on some days, there may only be 4 samples, and Sheet5 would not be renamed.
0
Outlook / Office 2010 on Windows XP  crashes with error "The procedure entry point EnumCalendarInfoExex could not be located in the dynamic link library kernel32.dll"

Greetings,

A client I recently started working with has a legacy app they need to run on Windows XP SP3.  Outlook 2007 was running OK on that PC for several years, and the Exchange email provider recently advised that we needed to upgrade to Outlook 2010 SP3 to maintain compatibility with a planned Exchange upgrade.  After implementing that upgrade to Office 2010 SP3 I am now getting the above error whenever I run an Office 2010 app, whether it is Word, Excel, or Outlook.  I have dealt with this issue before by removing KB KB4462157 but in this instance that didn't help.  Overall I've removed the following Office 2010 updates and rebooted, but am still getting the error message:

KB4462157
KB4461579
KB4461625
KB4462172
KB4462187
KB4661521

Appreciate any thoughts on what else I can try.

Thanks.

jkirman
0
Hi,

How to create a time line from Excel? I just want something simple like:

Contains:

Date in the horizontal line.
Should show event: from x date to x date with different color


Thanks
0
I have a situation where we have two law firms sharing office space. Both have their own ISP provider, phone system and network
However, they want to share a new leased copier so that the good print, scan via SMB and make copies.
-      the copier has only one network port and a USB port.
-      Confirmed that this copier does not support an external wireless adapter which I was hoping it did so I could allow one of the network to communicate to the wireless adapter using their IP subnet. That is not an option
-      I do not want to add a second NIC to every PC under one of the law firm’s network

I was thinking about purchasing a USB to network converter that I could attach to the copier/printer and onto one of the networks. Not sure this is a feasible workaround

Would appreciate any feedback
0
Excel:  I have random dates in column A, with a format of   3/15/19
In column B, I would like the date converted to the day of the week. (I can do this part with formatting)
*Issue: There are rows where there is nothing in column A, so I need B to be blank if A is blank.

Example:

Column A      Column B
 3/15/19            Friday
   blank              blank
  6/5/19         Wednesday
0
CompTIA Network+
LVL 13
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

Is there anything you can do within an *.xlsx file (created using excel 2010) to determine each time someone has accessed it, and keep the log somewhere of access times etc. I am told the file server on which the file is hosted is not one where at the OS file level access/auditing is enabled and cannot be due to the amount of events it was caused. I was just wondering if anything could be done inside the document itself. Reason I want it enabled is we have put some xlsx files in a 'shared' area and for whatever reasons permissions cannot restrict access - but I want to ensure nobody is generally snooping on access to these files just because they have access to them.
0
Hi,
I don't know why there is "Type mismatch" error when I run 1st Macro (pressing Alt-F8), vs attached Excel file.
ZCOM-QRL-112N.xlsm
0
Why are all cells desired to have the same green background color the same. Some are not solid.
 o
0
I am running Office 365 on my Windows 10 laptop, and work from an Outlook.PST file on my Desktop.   I noticed there were a lot of "Deleted Items", so I right clicked on the Deleted Items folder and hit "Empty Folder".  Somehow, for some reason, my Calendar was emptied ... and I've now lost all my Calendar items.  Is there any way to recover my Calendar data?  

Thanks,

Phil
0
Hello experts,
I have the following AutoHotkey which allows me to send Alt + Y1 to directly select my Add-in tab on Excel .
I don't understand why it works one computer equipped by Win 10 Excel 2019 and it doesn't on my other computer equipped by Win 10 Excel 2016.
!y::
SetKeyDelay , 10 ; time to wait between send
WinGetActiveTitle, Title
IfInString, Title, Excel
{
	Send, !Y
 Send, 1
}
Return

Open in new window


Any recommendation or advice?
Thank you for your help.
0
One of my associates has been uploading files once a week via FTP for the past 5 years from his home office to one of my websites. There's never been a problem of any kind.

Today, as he went through the usual process, an error notice popped up. He was able to ascertain that the FTP program he uses, Filezilla, was denying access because of the username and password he was using.

He's been using the same one for a long time, and it does contain an assortment of letters, numbers, and special characters.

I'm guessing that there may be a variety of possible reasons for this problem, but I'd like to hear from the pros as to what steps I should take to address this.
0

Microsoft Office

68K

Solutions

42K

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.