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

Hi Team, Need 2 help with my excel file.

1. I have attached 2 file. Daily report should update on  as per date in utilization sheet.xlsm. See the attached Daily Report file where i have use macro record option.

Need: I need that once date get change from 07-Jan-19 to 08-Jan-19 in (E7: Daily report.xls) so update button should take data from next column (G8, G21).

2. Once we are taking the screenshot its taking TAB name in 1st row, instead of tab name, i need that it should  take (E8) "Daily Work hour report for 07-Jan-19" text.

Thanks
Utilisations.xlsm
Daily-Report.xlsm
0
OWASP: Forgery and Phishing
LVL 12
OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

Wanted to count values based on certain criteria.   For example per the attachment.

The count is on the "MAT_REC_BY_MONTH" tab and the data is on the "DATA" Tab.  I've added some values on Week 1 and week 2 to show what the values should be.

On "MAT_REC_BY_MONTH" tab:  Column D (REC), the count is based on the "DATA" Tab Column Z filtered on "blanks" on Column AB for Calendar WK 1 on column Y.
On "MAT_REC_BY_MONTH" tab:  Column E (REJ), the count is based on the "DATA" Tab Column Z filtered on "YES" on Column AB for Calendar WK 1 on column Y.

Wanted a formula to count for all the weeks listed on the "MAT_REC_BY_MONTH" tab.  See attachment.
C--Users-lfreund-Downloads-COUNT-EE.xlsx
0
Hello experts,

I have the procedure reporting at the end of my message that I use from my personal.xlsb in order to compare values from different columns.
I would like to enhance the procedure by modifying the following:
1.      Instead of selecting the various range from top to down I would like to enter the column letter and the procedure should be able to display the range from initial top range till the last of used range and display input box “Range involved is equal to :”. This process should be applied for both columns
2.      Finish the procedure with the procedure by a filtering cells based on Interior.ColorIndex = "3"
3.      Display a Msgbox if the user cancels the procedure in of the range selection.
If you have questions, please contact me
Sub Is_Na()

Application.DisplayAlerts = False

Dim c As Range
On Error GoTo exit_routine_isna
Set UsedRange = Application.InputBox(prompt:="Please Select your range source, in this range you will find the cells wich are not in your range to compare", Title:="Range Select", Type:=8)
Set ComparisonRange = Application.InputBox(prompt:="Please Select Range to compare", Title:="Range Select", Type:=8)


For Each c In UsedRange
If IsNumeric(Application.Match(c, ComparisonRange, 0)) Then
Else: c.EntireRow.
End If
Next c Interior.ColorIndex = "3"
exit_routine_isna:
End Sub

Open in new window

0
Hi Expert,
I have given anonymous access for one of my SharePoint site. In that site I have some documents but I don't want allow anonymous users to open it.

Please help

Thanks

Zahid
0
I need to insert after every single raw the value from the third column like the sheet1 attached.

Regards,

Dallag
insert_every_sngle_raw.xlsx
0
I have a list of documents in an excel file and want to use this list to move specific PDF files from one folder to another. Is there a script that can be produced in Excel VBA to assist in this task. Also, can the script be made so it can be used for any type of document transfer?

An example of the script requirements would be

A POP-up box would appear requesting the list range
A POP-up box would appear requesting the location of files to be transferred
A POP-up box would appear requesting destination of the files to be moved
0
Using Excel 2013 .....
I have a button that when double-clicked, enters today's date.
The problem is that it is entered on to the sheet in American format (mm/dd/yyyy).
For today, it incorrectly displays 12/11/2018 instead of the correct UK formatted 11/12/2018
(G46 Should read ... EE 0 Days Ago)

G47 is correctly formatted and Win10 Locale is set to UK
Why could this be happening?

(If I incorrectly set the format of the vba to American it works .... a most unsatisfactory workaround)

Private Sub CommandToday2_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    Range("G47").Value = Format(Now(), "dd/mm/yyyy")
End Sub

Open in new window


G47 Format
0
I noticed in Onenote there is always in a certain notebook a A new QUICK NOTE TAB gets created on it's own. I deleted it and then it regenerates itself back again . is there away to stop this from happening? Once again the odd thing it only occurs on one notebook.
0
Hi,

I have a user who ask how to modify the "FROM" email address in SharePoint Designer 2017. User is doing like a "Client feedback" from workflow... I'm not familiar with SharePoint Designer but I'm sure this is just a setting somewhere that we can change easily. Is someone can guide me?

Thanks
0
Need a check on cells for empty/null cells  past a column header

vba excel 2010

I have this code trying to count my rows:  The data will either be in Column 1(a)   Or Column 2(b)
While Len(.Cells(lastRow, 1)) > 0 Or Len(.Cells(lastRow, 2)) > 0
                lastRow = lastRow + 1
Wend
The column Header are always in rows 3

Sometimes in Column1 the cells will be empty and i need to calculate the rows in Column2
Both Column cells will never be both filled in:

Will always look like this:
Column1            Column2
account              track       <----   row 3
11111
22321
445436

Or
Column1            Column2
account              track           <----   row 3
                            32de4
                            656768yu
                           65tgty

The code above seems ok(working), just wanting to make sure

Thanks
fordraiders
0
HTML5 and CSS3 Fundamentals
LVL 12
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

I have a named range in an excel workbook.

The following macro will copy the data in the named range and paste it into a new CSV file .

Sub DPD()
'
' DPD Macro

    Range("SAVE").Select
    Selection.Copy
    Workbooks.Add
    Selection.PasteSpecial Paste:=xlPasteValues
    Application.CutCopyMode = False
    ChDir "C:\DPD"
    ActiveWorkbook.SaveAs Filename:="C:\DPD\Book3.csv", FileFormat:=xlCSV, _
        CreateBackup:=False
    ActiveWorkbook.Save
    ActiveWindow.Close
End Sub

I need to change this Macro so that it only selects cells within the named range that have a value. Then paste those cells into the new CSV file.
0
Somehow a birthday reminder has been placed on my Outlook 2016 calendar.

I'm not sure how it got there. I didn't put it there.

When I try to delete it I get a message that says "You cannot make changes to contents of this read-only folder."

What can I do so that I can delete this calendar reminder?

Cant make changes to contents of read only folder
0
It was ugly with Skype. Still haven't figured how how to add (or invite) external contacts to chat in Teams
0
Hello,

I have a problem with office professional plus 2016. They get the activation key with a MAK key and it works fine.

I've been installing them on many computers and my problem is on computers with windows 10 with a preinstalled office version.

First I have uninstalled it, using the tool of Microsoft since the uninstallation is not present in the add/remove software of the control panel.

Then after restarting the computer, I install it and if I look in "account", I see this


Then, the next day, I get this


and this


So I try to re-enter the key, but activation fails. If I uninstall everything, and re-install it, it works for one day and the the problem occurs again.

I've notice that the limitation date changes every day, and even though its says that most features will be disables, it stays fully functional.

Thank you for your help.
1
I am trying to convert height in inches to feet and inches to display on a SSRS 2012 report  like 5"8'  from 69.00 inches. I have the formula below that isn't showing up correctly the digits to the right of the decimal. For 69.00, it shows 5"0'.

HGT = concat(convert(int,min(HGTTO)/12),  '"', convert(int,min(HGTTO)/12) % 1,'''')

Thanks
0
Hey all,

I have a client who has moved from their standard IMAP email hosting to G-Suite. I have configured google sync client and set up correctly and added a personal live.com email account to his account. He requested to have autocomplete moved across which was an easy fix but then found out a few days later live & google sync don't like working with each other, so I have had to remove his live account. This in turn removed the autocomplete settings also. I was thinking of creating a yahoo account or similar (but this was a joke of process) so I am left now without his autocomplete.

He really should have these as contacts (i know) but I would like to try and help him out. Any thoughts on 1) being able to migrate autocomplete contacts 2) saving his autocomplete contacts.

TIA
0
I was advised to use Cntrl + Shift + F9 to unhide a hidden tab (that is password protected) on an excel 2013 document.  That is not working - please advise if there is another way to unhide a tab. I do have the password.

Thanks,
0
I'm on Excel 2016:  I recall I ever see in older Excel there's a way to import
by "space separated" but I can't locate it currently.

Anyone can give me step by step instruction on how to do this?

I have a text file (output from  'net user /domain > file.txt') that has 3
columns of text, the 3 columns are separated by spaces

After that would like a macro that reads in the 3 column data that will
automatically move columns 2 & 3 to be under column 1 , resulting in
a single column of data & if saving can be automated, save as text
0
HI Guys

Hope you can help

Ive been trying to use SUMIF, SUM PRODUCT with FREQUENCY and MATCH to sum the quantities in stock locations but ignoring duplicate entries

I have column A and Column B - column A has the stock location which can be repeated several times with the unique stock quantity against the location in Column B

Ive tried creating a formula to sum the quantities in Column B but only for each unique location so for example, if in column A Stock Location PB12345 is repeated 6 times and has a quantiity of 500 - when the SUMIF runs through the the two columns, it only includes the sum of 500 from PB12345 once and not include the six times its repeated

Ive attached a sample file and the desired result in cell F1 - the formula im using shows how many times its repeated but not the sum ?

If you could help I would be very grateful

J
0
Become a Certified Penetration Testing Engineer
LVL 12
Become a Certified Penetration Testing Engineer

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.

I installed Snip and Sketch from Microsoft Apps Store. Then I looked for it in the apps and it was not there. The store says it is owned and install button is greyed out. The recommended requirements are version 17636. Under system information, it says that I have version 17134. I did windows update to version 1803 yet it still shows that I have version 17134 and the snip and sketch app is nowhere to be found. Someone help me, please.









0
Hi,

Hope someone can help me with this.

I have a Excel workbook containing two sheet.

On the Company sheet, I am capturing Company Name, Sector and Size. The company name of each company is unique.


On Page 1, using a drop down list, we need to be able to select the company name from the list, and enter some data underneath.

The issue I have is that I need some validation to prevent users from choosing  the same company name more than once from the list on that sheet.

Can someone please suggest a way of doing it, as I am stumped ?

Thanks

GW
exchange.xlsx
0
Hi,

I have a Excel formula problem, my Excel formula knowledge is not good. Please refer to my attached JPG file.

Thomas

What is my error on cell F2? I want to get a result (IF cell A2 = "AA" , E12 will X L1. IF cell A2 = "BB" , E12 will X L2. IF cell A2 = "CC" , E12 will X L3.)

Regards,
Thomas
0
[b]SYSTEM[/bt
Asus T100 10" Laptop
Windows 8.1
Foxit PDF Editor/Reader
AutoHotKey Software

BACKGROUND
When using Foxit PDF reader, I need to magnify the document's text. This means I must scroll or pan left and right to view all the text. Foxit does not have any keys to pan left and right. I would like to use the Left and Right Arrow Keys to pan left and right when using Foxit.

PROBLEM
Can someone help me to assign the desired behavior to the Left and Right Arrow keys by remapping the keyboard? Can you help me write the script using the AutoHotKey software? If you have another solution that works, I'd like to know about it as well. Can the remapping be in effect only when in Foxit?
0
SYSTEM
Windows 8.1
Asus T100 10" Notebook

BACKGROUND
Foxit PDF Reader (Free Version) 9.3
In order to use the keyboard shortcut to pan left and right, when the screen is zoomed in, I had to disable Windows Hot Keys so that CTRL+ALT+ARROW would not rotate the screen. (My previous EE post focused on that problem.)

PROBLEM
Is it possible to assign a different Hot Key combination (other than ctrl+alt+arrow) that allows you to scroll (or pan) left or right in Foxit? Can you assign just the Left and Right Arrow keys without the control keys? That makes it so much easier to use the arrow keys to navigate the page with one hand.
1
On my work computer w/Windows 10, when I open Task Manager, the computer hangs.
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.