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

Hi,
I'd like a formula to select data where first letter in a name = U
example
                               formula
UABCD   46            =46
ABCD     32            = 0
ACDE     46            = 0
UACDE 50              -50

Many thanks

Ian
0
Why Diversity in Tech Matters
LVL 19
Why Diversity in Tech Matters

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

I need to know how to turn a URL (link) into a document that I can put on Google Drive in a shared folder.  I'd like people to be able to double-click on this document and it sends them to the destination URL.

Thanks
0
Hi, Please see attached. I am looking for a formula that will look at the values in a row and write whatever is in the header of the highest value to a cell.  Kind of hard to explain so I included an example file.
TestExample.xlsx
0
I want to change a text in a function.
I have $A$2 Want to change to $A2.

Thank you,
0
In SCCM I created a new Office 365 installer using the latest Semi Annual Channel build. It installs fine but doesn’t automatically activate. I’ve racked my brain for almost a week on this. The existing O365 installer activates fine when the logged in user opens an Office program for the first time. I’ve tried creating multiple installers with different settings but none of them will activate. I’ve checked GPO settings, updated the ADMX files for Win10-1903 and Office 365 in the sysvol central store. Any idea what the cause could be?
0
The ribbon changed in Word.  How do I get it back to normal.  Please see picture.   ribbon
0
I have a customer that needs to access an Excel file by a group of employees. they all work on this file and would like to collaborate on this file. They use Office 365 on each computer. They have an old server that stores their files.  
I am moving everything to Office 365 and need to know what can be done to allow all group members to access the file at the same time?
0
Hi

I need to uninstall the latest update of Office 2019. I am worried that if I choose uninstall on the item in the image that it will uninstall Office 2019 completely

1
0
EESampleRevA.xlsx
I would like to create a button to jump certain cell by clicking a button.
there is a date in row and a cell shows a certain date.
0
I want to update my 4 Office computers to Windows 10 Pro.  I just want to update the OS from Win 7 Pro to Win 10 Pro and leave existing applications and data as is.

I thought purchasing would be very straightforward but I see many options and prices.

On Amazon I see a Win 10 Pro on a USB for $189.  I see other offers for Win 10 Pro OEM for much less.

Question:
Where to buy Win 10 Pro?  I want to get a good price but some of the prices I see are suspiciously low.

Is there a difference between the OEM version and the others?
0
Ensure you’re charging the right price for your IT
Ensure you’re charging the right price for your IT

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 have a excel file with all the data in Column A. I wanted to separate this to more columns. The pattern of the data is always the same. Attached is the file I am working on. Here are the columns we want

Column B: First Name and Last Initial. This always the 1st word in the cell then the 2nd initial.
Column C: The 8 digit number after the name
Column D: The first name after the 8 digit number
Column E: The last name after the 1st name
Column F: The part in Parenthesis
Column E: The 1st Date Listed
Column F: THe 2nd Date listed
Column G: The 3rd Date listed
Column H: The last number - it is between 1 and 99.
List2.xlsx
0
Attached we have an excel file with all the data in Column A. I want to seperate this to 5 different columns.

Column B: 1 1st Numeric digit that is always 8 characters long - the 1st 8 characters.
Column C: The first name -always the 1st word
Column D: The Last Name - either the 2nd word or the first word before the parenthesis.
Column E: The parenthesis part
Column F: The date - which is always the last part. List1.xlsx
0
trying to post data from a recordset to sheet.

I have the folloeing recorst created in code:

But trying to loop through the data and place on the worksheet properly


dB2.CommandTimeout = 400
                With rs2
                 .ActiveConnection = dB2
                 .Open strsql
                End With



 
J = rs2.RecordCount

ActiveSheet.Range("A2").Select
      
For i = 1 To J  'rng.Count
    

Do Until rs2.EOF

      
        
        ' place data into sheet
        rng(i).Offset(1, 0) = rs2.Fields(0) '
        rng(i).Offset(1, 1) = rs2.Fields(1) '
        rng(i).Offset(1, 2) = rs2.Fields(2) '
        rng(i).Offset(1, 3) = rs2.Fields(3) '
        rng(i).Offset(1, 4) = rs2.Fields(4) '
        rng(i).Offset(1, 5) = rs2.Fields(5) '
        rng(i).Offset(1, 6) = rs2.Fields(6) '
        rng(i).Offset(1, 7) = rs2.Fields(7) '
        rng(i).Offset(1, 8) = rs2.Fields(8) '
        rng(i).Offset(1, 9) = rs2.Fields(9) '
        rng(i).Offset(1, 10) = rs2.Fields(10) '
        rng(i).Offset(1, 11) = rs2.Fields(11) '
        rng(i).Offset(1, 12) = rs2.Fields(12) '
        rng(i).Offset(1, 13) = rs2.Fields(13) '
        rng(i).Offset(1, 14) = rs2.Fields(14) '
        rng(i).Offset(1, 15) = rs2.Fields(15) '
        rng(i).Offset(1, 16) = rs2.Fields(16) '
     
 

        ActiveCell.Offset(1, 0).Select ' move down to the next row 
       
      rs2.MoveNext
    Loop
 Next i

Open in new window



Thanks
fordraiders
0
EESample.xlsx
snap176.pngsnap177.pngI would like to add second axis but the second bar gets clustered on top.
How could I make it separated?
0
proper passing of variables to sql server procedure in excel vba office 365 (64 bit)

Is this the correct way to pass variables to sql server stored procedure ?

Dim strStart As String
Dim strEnd As String


Dim myValue As Variant
Dim myValue2 As Variant
myValue = InputBox("Supply a Start Date Please. Format YYYY-MM-DD")

myValue2 = InputBox("Supply a End Date Please. Format YYYY-MM-DD")
 

Dim sQuery As String
    Dim i As Long
    Dim SearchCodes As String
    Dim dB2 As New ADODB.Connection
    Dim rs2 As New ADODB.Recordset

Dim dbconnstring As String
Dim strsql As String


Set dB2 = New ADODB.Connection
dB2.CursorLocation = adUseClient




dbconnstring = "provider=sqloledb;Server=B025.us.xxxxx.com;Database=PROGRAM_WORK;Uid=xxxx;Pwd=zzzzz;"

' IS THIS LINE CORRECT ? BELOW
strsql = "EXECUTE [program_work].dbo.[sp_Clm] ] N'" & MyValue & "' & N'" & MyValue2 & "' ;"



dB2.CommandTimeout = 400
                With rs2
                 .ActiveConnection = dB2
                 .Open strsql
                End With


-----  more code

Open in new window

0
Hello, I need a macro to transposed dates in five columns into one column.

Columns A-H is the raw data
Column J-M are the desired results
If possible, I need the results to only display dates because every record doesn't have dates across all five columns so sum will be blank
The key fields are A,B,C and they need to be displayed on the results, in Order of Pers.no. then ascending in date order
Transpose-Dates-in-many-columns-int.xlsx
0
Hi,

My office has mixed win7 and win10. On win10 pc, all network printers can be listed, but on win7, nothing is listed except for a disconnected printer.

On those win7 pcs, I have to add the printer by using IP.

Also, how can I remove the printer that was disconnected when I do the network printer search. thank you
0
I need to get the maximum of A1:C1. One or more of the values could be text or error condition. Please give me a formula to ignore the error cells and if all three are error then return a blank.
0
Values to be identified as duplicates will be in the second (B) column (with header). I will need to identify rows with duplicate values in that column, but preserve all values in the other columns of that row.

It would be good to insert the string, "Duplicate" (without quotes) in the column to the far left of the duplicates other than the 1st instance. For the 1st instance, mark as "First Instance", would be desirable. Then I can sort on that column. Non-duplicates should not be marked at all.

Spreadsheet has 75,000 rows.

Using an Inline Function would probably be preferred if possible, rather than a nested VBA loop type macro. But please do what you think best. I'm unable to find a reasonable solution searching the web. -- BTW:  CONDITIONAL FORMATTING hangs the program with too many ROWS.

Sample Content: (sorry, but the "Indent" tags are not working). The point is that the values in other columns of those rows do not affect the logic.
Column A is Blank

Column-B-Title   Column-C-Title   Other-Columns-w-Title
5555
Some-Value
5555
Some-Other
5555
Not Important
3333
Some
3333
Thing
XXXXXX
xyz
XXXXXX
abc
Anything
pqr
Else
stu

(Note: Sorry about all the edits. Couldn't find a "Preview" button prior to publishing. Not familiar with this new interface.)
0
Exploring ASP.NET Core: Fundamentals
LVL 19
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

Experts,

I have a group of values on a spreadsheet "Sheet 3"  Column A  Rows 2 =15 that I have assigned to a name field called 'East'.  Is there a way to check column "A" on Sheet 1 equal to one of the values in my named field and assign "EAST" to column "B' on the respective row.

Microsoft Excel 2016
Named_Feild.xlsx
0
I am running Windows 10 on my new Lenovo laptop.  All of a sudden, when I try to print from MS Office programs I get the following message (see below).  I uninstalled and reinstalled the printer, and it prints a test page fine …. and also prints from the browser and other programs, just not from MS Office programs (which is where I print 95% of everything).  This is a serious problem, and I don't understand the error message (see below).  Please help.  

Printer Error
Oh, and the next window says "Printer Not Ready" …. but it is.

Thanks,

Phil
0
How to remove multiple rows with the name "DPL" in the string in column Resource and HLR as string also in Resource Column. Another words can have DPL live as string but will still remove because it found DPL. Thanks in advance
0
Hi Experts,

I'm trying to access a cell value from another Excel file using the following formula:

='C:\Users\UserName()\Desktop\[filename.xlsx]General'!BJ6

However, it returns #Ref.

I've also tried to use:

="'C:\Users\" & UserName() & "\Desktop\[filename.xlsx]General'!BJ6"

But it only returns the path of the file.

Is there a solution to this?

*I didn't want to use INDIRECT, since it requires the data file to be open.

Public Function UserName()
    UserName = Environ$("UserName")
End Function

Open in new window



Thank you.
0
Experts,

II created sheet 2 using formulas with data from sheet 1.   My column letters    (A B C D etc. are missing from Sheet 2.  I am using Excel 2016.  How can I get the column letters to appear?
0
I had this question after viewing O365 2016.

It looks like this solution is only available for O365 not office 2016? Just want to make sure. I have not found the build 1707 or above for office 2016.

Thank you,

Kevin
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.