Can someone help me find a shorter formula. I would like the corresponding row's first column to appear in successive columns in a second sheet. Each F number (ie F1, F2, etc) refers to a person. the cells to the right of each person refer to a job that they will be doing (ie Team 1, Team 2...
I currently have the following list:
I want to create a formula (probably through conditional formatting i'd imagine), that basically says:
If the cell 4 turns to the left of any designated cell (A1) in row E is not = blank, color the cell in row E with a red...
I very new to using Macro.
Can some one please help me with a code to open all the below applications once I run the Macro.
Adobe Reader DC
Microsoft power point
Any help is really appreciated
Hi, my company is prepared to put me through a Power BI course and have asked me to find a course that fits our needs:
> Preferably a week / 2 week classroom based intense course
> Certification included, Microsoft 70-779, MCSA or MCSE exams as part of the course
> Preferably a Microsoft gold...
I have an Access Macro.
In this macro, Microsoft Access 14.0 Object Library is ticked in Reference.
I want to un-tick this reference.
However while doing so I get pop-up as ‘Can’t remove control or reference; in use’.
How do I find out what objects in my macro are related to this reference...
I know access is not the best at formulas, but I have certain customer names were they can have the name entered slightly differently ( like Microsoft, Microsoft Inc, Microsoft UK)..
Is there a iif contains formula so that if the customer name contains Microsoft then return the word...
Within the Visual Basic Editor on the left side there is the Microsoft Excel Objects folder tree that contains all of the sheets in the workbook.
The workbook that I am working in has many sheets and it "pushes down" the Modules folder and Class Modules folder, forcing me to scroll down to see...
I have an excel workbook which is linked to an Access Query via the Data>Get Data
Essentially, each morning, as new data becomes available I right click and hit refresh and it updates for me.
The past couple of days I have started to receive the following:
"ODBC Microsoft Access...
I have the following code but have not found a solution online. Has anyone figured out a solution?
or would this relate to an authentication issue from my company's server? how do I get around that?
I have the following references:
Microsoft Access 16.0 Object Library
Microsoft DAO 3.6...
I have a worksheet that will use a datarange of A2:A1000 within a sheet name of "ABC"
I would like a variable that will return the number of rows that contain data. Anywhere between 1 and 999 is possible.
I am using Excel 2019 which I just download from Microsoft.
I deleted the old Microsoft office which had word and excel because I was getting an error message.
I am trying to enter stock symbols in column A and in column
B I have the following =xlqprice(A3, "yahoo").
I have used this formula...
Hi all! I'm trying to activate the Microsoft Scripting Runtime Reference within my code as I'm using FSOs in other parts of the code. I don't get any errors, but it's not activating the reference either. The path below is my actual path. Any help is appreciated.
Thanks in advance!
I have some VBA macro for "Inserting Note" in Microsoft Excel. I want this prettifier to be inserted in my macro for creating a note with highlighting, is it possible (Interested in highlighting such as on StackOverflow)? Watched a video 1, 2, - on YouTube but the manual is not...
Hi Guys, I have installed the Microsoft office professional plus 2016 on my personal computer (with a subscription of course) and i signed for the insider. My question is:
Is it different from the office 365 pro plus insider?? Curious, because i am using certain keyboard shortcuts like Alt+B+M...
Newby here so not sure how much/little info to post, moderate excel skills, slowly going mad over a project I really please need help with! I have searched this forum and Google with no luck.
Heres my problem - I have a XLS with 20,000+ rows and I need to check if words match a table...