excel 365

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

OK, so bit of a tricky one for me anyway. I have a list of data that has zero blank rows separating different values: <tbody> 100 100 200 200 300 300 </tbody> Now I've found this code to compare the cells above and...

How do I configure the File drop down menu from the ribbon on Excel in Office 365. My colleague has suddenly found that some of the shortcuts are missing after the last update. For instance, she no longer has the Save As shortcut but it seems to have been replaced with something called Save...

I want to change the background colour of a column header (cell C2) to Green only if one of the cells in the column (C3-C12) has the character C in it. Any other characters, or more than one C, etc. should not change the colour. Can SKS help out as I just can't seem to get a formula that works...

Hi All Something I cannot get my head around. I have a worksheet (Analysis1) that contains numeric data in columns 'D' to 'lastCol'. Each of these data columns has a header label in row 2. There can be anything up to 30 different column headers, but these fall into only three 'types'. The...

Dear All, I currently dispose of a working sheet which I use to keep track of my working hours. We recently have upgraded our Microsoft Office 2010 to Microsoft Office 365 and this particular sheet has stopped working correctly: it shows a lot of #value! errors. I have found how to correct the...

Hello, I am having some trouble with code I am trying to write. I need the variable LR to be redefined on each worksheet the code works on. I keep getting an error on the line underlined below. Hoping someone can help. Sub Update_Actuals() Dim LR As Variant, i As Long, NUM As Long, ws As...