excel 365

Good morning, I have the below code that cycles through a drop down, prints to PDF, and output saves into a specific folder. However, I want to be able to put a number in a cell, J4 for example, so that it only prints the first X number to PDF then stops. For example, if there are 100 items in...

Below is some of the code from a VBA macro. Currently when this runs it saves all newly created docs directly onto the desktop. Instead I would like for this code to create a named folder onto the desktop and save the files within. DesktopFolder =...

Hi everyone. I asked part one of this question and it was answered quickly. HOW CAN I FIND THAT THREAD SO I DON'T DUPLICATE IN THE FUTURE?? (uggh....sorry) Goal: I have a 365 macro to save the file as a XLS file, then a PDF. Someone (thank you to that person!!) answered the question, but now...

Hi, I have a data source in the following format with date, hour and Month derived from the @Timestamp per hour field @Timestamp per hour Count of records date hour Month 01/04/2021 00:00 8 01/04/2021 00:00 Apr-21 01/04/2021 01:00 12 01/04/2021 01:00 Apr-21 The data is used in a pivot...

HI, so my issue is as follows. I have a master workbook in which I would like to track changes that were implemented in other workbooks in dofferent locations. The workbooks are all including the master saved in different locations on sharepoint. Now what I would like to track are changes in...

I've been using Break links for years, and it always worked seamlessly. I'm now on Microsoft 365 Apps for business, and I find that it no longer works as expected on some files. What I've done is gone to Data - Edit links, and selected Break link, as I always did. After doing this, "Edit...

Hi, I want to generate 20 random numbers between 1-80, but my formula always bringing duplicates also. So is there any way to generate 20 sorted numbers in ascending order without duplicates and I want to save those numbers at runtime. it will be easy if the formula can generate numbers for 100...

Good evening, I have the below sub that is set to hide all Tabs with a name that ends in h. I would like to modify it to use the same button to Hide/Unhide all tabs that contain a word instead of ends with a letter. Option Explicit 'Set tab naming convention to hide & unhide Const TABNAME...

I'm trying to create a sheet with some intervals in each row. The total of sums of the intervals of each row must be 08:00. But I'm having problems, because the excel doesn't calculate each row at time, but every row simultaneously, and the total in each row ends in a value different of 08:00...

Hi Folks, Does anyone know a way to prevent excel from 'copying a tab mark' as well as the 'string inside the cell' when you copy a cell by: right-click, copy (i.e., instead of double-clicking on the cell and highlighting the string, then copying it). For instance: if the following string was...

Hi all, I hope some of you experts can help me with this. I am trying to put together some VBA code to automatically select a source workbook from a Teams (Sharepoint) folder based on a couple of variables (folder name and filename suffix) that are provided within the cells of my destination...

Hello everyone, I need an easier way to copy cells within a certain range and then paste in the same range as values. It's just that once the cells are filled with info from the index/match, I want to paste it as values so that the values don't change (it's people records and they might move to...

Hi all, Vers office 365 (with xlookup) I am already going to implement the formula from this thread Drop Down lists but I am struggling on some mechanics of my drop-down list as I have many conditions. I want the drop-down list journey to be: Internal/External? -> Provider name -> Target...

I have a list of 2,200 spare part descriptions that need to be shortened to 40 characters. Will someone please help with a formula that will do this?

Hi all, I need some VBA to allow me to send multiple emails (same standard email body but each with their own individual Excel attachment). I'm using Microsoft Outlook and Excel 365 Workbook Entitled: 'Raw Data' Sheet Entitled 'Sheet1' Column A: Email Address Column B: First Name (for email...

Hello I have searched and attempted to implement many various macros to do what I am looking for, but I have not been successful. Could anyone give me an excel sheet that has the macro already setup for doing the following. I have a list of HEX codes I am using for a bar plot in R I want to put...

Hello Everyone, I have created a macro that gathers all the timings from a specific subfolder on a specific date from a shared mailbox and personal sent folder. When checking the timings from the personal sent folder there is no issues, but when checking from the subfolders from the shared...

I've created a combination scatter and stacked column chart in Excel 365. The scatter chart is used to show red, amber or green circles and the labels - one series for each colour and another for the label. The label contents are sourced from a range of cells. The column chart creates the...

Hi, We've got a fleet of 58 vehicles that we used to manage by registration, so for example we would get individual requests per vehicle for MOTs, servicing, breakdowns, repairs etc. Every entry is tied to an individual vehicle, so there are hundreds of entries but it's fairly straightforward...

Hello, Does anyone know a formula for getting the first and last instance of an agent in a data set, so I can record every agents log in and log out times from a big long list of all times Thanks,