Hello.
I am trying to group dates in a pivot table by pay period.
The pay periods extend from the 1st of each month to the 15th for the first half and then from the 16th to whatever the last day in the month is.
In the date grouping options I can only find the ability to group dates by the...
Hello,
I was using 32-bit Excel 2013 and had a workbook with a number of bespoke functions, some simple, some not so simple. However, after upgrading to 64-bit Office 365 all of my bespoke functions do not seem to be working.
Here is example code to work out the inverse of the tangent...
Hello Excel experts!
I am in need of a macro in Sheet A that creates a tab delimited blocks.txt file from range A36:C50 in Sheet B in directory C:\Users\user\Desktop\AsBuilt\blocks.txt
Also, since I will be using this same file to import blocks in AutoCAD, I wouldn't mind if the newly created...
Hello,
I have to migrate a very old excel file with many macros from Office 2010 to Office 365 (Office 2010 being no longer supported). The Excel file works perfectly on Office 2010.
When I run the VBA compiler, I get the following error message: Compile error Variable not defined
Here is the...
I have a file with three worksheets.
Sheet1 is a summary of all clients.
Sheet2 has a table that copies only clients with "active" status from Sheet1, Sheet3 has a table that copies only clients with "buyer" status from Sheet1.
Is it possible to write a vba code that will delete rows from...
Hey everyone,
I don't use Excel a lot, so I am quite proud with what I have come up with. Wish I could share it but it has all my financial data and crypto holdings to create a dashboard. Power queries, just trying to solve a different issue at the moment with VBA, the lot!
Besides the...
Hi i have an macro that saves a pdf and then emails out statements. But on conversion from 2013 to 365 it no longer works.
Could anyone have a look over the code and see if they can see what the issue is i.e. whats changed between versions that i need to update?
Any help appreciated.
Sub...
Hi,
If someone can help me find a way to remove or hide the time and date stamp from 'comments' in Excel 365, it will be much appreciated.
I am using the comments function to add regular updates to individual items in a workbook and am applying a date against each update in the comments field...
Is it possible to reference a math sign like plus (+) or minus (-) in a formula from another cell in excel? Example, I want to add values of cell A1 (Value: 2) and B1 (Value: 3). Cell C1 has plus (+) sign. So, my formula should be =A1&C1&B1 and the result should be 5. This of course is not...
Hi everyone,
I have been having a really hard time to figure out what I am missing.
The goal:
I have need to allow multiple business to fill out an Excel sheet privately then have that data flow into a single master sheet that I maintain. This is to overcome the constant copying and pasting...
I have the below data set
when i select the Department
I want to get a table wih all the employes working in thhat department like this
Only Vlookup formula can be used to obatain the result table. Kindly advise. Thanks for the Help in advance
I have a dataset like below
when I select Department from the Dropdown
I need to return multiple matches in atable format like below
Which Formula can i use to get these multiple matches in a table format....Thanks in advance
Hello! I'm trying to create a function which will be assigned as a macro to a "Refresh" button which will read values from D3:D59 and color the tabs based on associated cell value based on matching string text in Column B. For example: It would read the names of all tabs that match with their...
Hope everyone is having a great weekend! Ok...here we go. I have a button on several sheets in a workbook which is supposed to call one function. The function is supposed to look at a sheet named "CONTENTS" and search column B for matching sheet name. Eg. If the active sheet I'm working on is...
I've been trying to create files from Excel to our company SharePoint site on Office 365, so far without success. Here is the code:
Dim dYear As Double
Dim sYear As String
Dim sDC01 As String
Dim sDC02 As String
Dim sDC04 As String
Dim sDC05 As String
Dim sDC06 As String
Dim sDC11 As String...
Hi
On of our users has a problem which has been going on for a while now. When they copy a piece of text from the same excel spreadsheet or from something else like a filename etc, they paste it into an empty cell in excel. Excel freezes after that, then if they double click on a cell that...
Hi,
I have a button inside Excel workbook which exports certain pages to PDF with one click on a button.
The Excel version I am using is Professional Pro Plus 2019 and my customers version is the same build, but an Office 365 version.
If I hit the button in my version it works, but if my...
I have this macro with the lines below (this is also the highlighted part when error is encountered) that previously works on win7 - ms office '10 and '13. But in win10 office 365, it errors out with the message invalid procedure call - runtime error 5. I've found some online like changing the...
Good morning all,
I am using power automate to automatically populate a spreadsheet with results, those results would then be fed into a pivot.
You might be asking "why not just use Forms' visualisations?", well the person wants to only view submission results week by week and might get asked...
I am using the following formula in a spreadsheet to autofill cells with data from another sheet and it works.
=INDEX(Table15[Global ID],MATCH([@Name],Table15[Name],0))
I am using the same formula in another workbook and I keep getting a syntax error.
=INDEX(Table15[SAP...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.