excel 365

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,

I am trying to save lots of time and headache, so any help is appreciated! There are many addresses that have multiple tenants. I need the tenants horizontally transposed into the same row so that I can use this as a mail merge. I guess part two of this is that it would be great to also have a...

I have table tblActivties on sheet Activities and tblTrainingLog on sheet TrainReg. I want to copy two columns from tbleActivties and paste them in the corresponding columns on sheet TrainReg. The amount of columns to copy is known and the number of rows to copy in tblActivities in unknown (last...

Hi, I have a table containing budgeted foreign sales data by month and want to convert this to a home currency (the fx rate is obtained via a parameter). Is it possible to multiple several columns at once in power query by a value? I know I can create new columns for each month and multiply...

Hi All, New to power query in Excel. Is there a way I can get a running count based on a reoccuring value in a column, and start a new running count based on new values? Cannot find the equivalent of count/countif in PQ. Here's an example of what I'm trying to achieve. Input Name Values...

I am looking to populate excel file metadata in SharePoint 365 from specific cells within the excel file. I am able to create the linked Advanced Properties within the file, import it into SharePoint, and auto populate the values on the initial load. The problem is, when users update the...

Hi All, I have a list of values and locations. I then go to insert, then map graph. A map appears and plots well, but the southern Ireland bit of the map is missing. I've tried changing it to towns, cities etc, but southern ireland is blanked out. Does anyone know why or how I could get...

Hi guys I am trying to do a backup spreadsheet for all the devices at work (each device has 32 "nodes" in them so its one sheet per device) I have got everything working on each sheet (expiry dates, filters macros etc) but I am trying to set up one front "Status"page that shows you if work...

Hey, Long time reader, first time poster. I'm trying to play the below code, but when I do it crashes, when I step through the code it works fine. Any ideas would be greatly appreciated. Many thanks Dim iMonth, sPath, File, sFile, vFile, mFile, Fund, iFile, FileType As String Dim row...

Approximately how many menu commands in Excel 2016 or 365? These would be things like File, Save As or Insert, Table, Pivot Table. I have seen a list of shortcuts and accelerator keys around 400, but they still don't cover a lot of things.

Hello everyone! So just so everyone knows, I am a VBA newb, self-taught through extremely helpful forums like these. This is my first post and haven't even set up my profile fully. Lol This request will help me and my accounting team here at my job out tremendously! So, thank you for taking...

Before I begin: I'm not a novice by any means, but I find myself lacking in this particular area of expertise. And because of that, I don't know exactly how to succinctly ask this question in Google or on this message board. There's a good chance it's been answered - or that the answer is...

Hello I am new to VBA and Excel so please excuse my ignorance on some terminology. My boss uses Excel 7 and I use 365, his code that he has used for 10 years for the Sort function is as follows. Range("A1:A14").Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlYes or Range("E1", "F" &...

I have a sheet with 25 columns, the active area is C6 thru U12. I need to total the Values in every 5th Column (ie:C6-C12,H6-H12,M6-M12 and R6-R12) that are >0 and then get the average for the total value. Here is what I have now, the formula being: =AVERAGE(IF(MOD(ROW(C6:C12),5=1,C6:C12,””))...

I am new to office 365 and have recently started having problems when I re-open a file that I have previously linked to. If I open the linked file while the file with the formulas is open, the link gets "broken" and has to be recreated. This is wasted time and I cant afford that. Is anyone...