office365 excel

I am working on a time card template in excel. I want to use a formula to determine if the date in Column A is a workday (that is not a weekend, Sat / Sun, and not on our list of holidays/closures) I was looking at the Workday function but it did not return a true/false value it just returned a...

Hi, As part of a larger VBA project, I need to check 4 columns to see if any values have been incorrectly entered - values need to be entered by the user as whole numbers without leading zeros, so "3" not "0.03". As such, I need to check to see if there are any cells in the column ranges...

Hi all, I have created a partial formula that calculates the amount of EMI going towards interest and principal. I am, however, looking to calculate the outstanding balance after each period as well. The formula for outstanding balance for each period would be - Example Period 1 ost bal =...

Hi, I am in the process of creating a personalized budget (Office 365). I am using the following formula that works perfectly. I am planning on using this budget for the foreseeable future. How will I make provision for 2024 leap year? [=SUMIFS('Details 2022'!$D$2:$D$2001,'Details...

Good Afternoon, I'm working on a macro to activate a named worksheet when a cell with the corresponding name on a separate worksheet is double-clicked on. I tried to use a macro suggested in another thread but it doesn't seem to work. For reference I am working in the O365 desktop version of...

I have tried the following and get no syntax errors: Sub Delete1000() Dim lngCol As Long Dim ws As Worksheet Set ws = ActiveSheet With ws For lngCol = .Columns("T").Column To .Columns("CYL").Column Step -1 If WorksheetFunction.Sum(.Columns(lngCol)) <=...

I am working on a file with this Macro. This macro copies the data from a form (sheet1) and pastes it horizontally on a blank row in the next sheet. But this is awfully slow..is there anything you guys would recommend to make it run quicker? Office version: 365 Sub SubmitDataWAF()''...

Hi Everyone, Hope you all are doing great. I want to keep importing 5 columns of data from Sheet A to sheet B, whenever I open sheet B. Though I can write simple macro for it, but I think there is an easier route as well through excel connections, importing data from an excel file is...

Hi guys, I have a set of data as shown below which has from and to range and a corresponding value- Input Data Range From Range To Value 0.00 46.35 3.8707 46.35 72.17 2.4149 72.17 458.61 2.4149 458.61 486.38 4.2 486.38 631.56 10.1 I want to compare from and to range...

I have the following sub that unhides all sheets in a workbook. I would like to use the button I assigned to the ribbon to hide all of the sheets when I click it again. Sub Unhide_Multiple_Sheets() Dim ws As Worksheet 'The For-Next is a loop that loops through 'each sheet in the...

Hi all, So this one may be a bit confusing to explain so I'll try my best! I'm on O365. I have a table, which will grow by rows as time goes on. ID1 ID2 ID3 ID4 ID5 ID6 ID7 ID8 1 2 aaa bbb ccc ddd 100 100 2 2 eee fff ggg hhh 400 400 3 3 iii jjj kkk lll 700...

Hi! I need users to enter a date into Excel cell. However it needs to be in a controlled, but user-friendly manner. So, I can't just let users manually edit the field for date formatting problems as well as typos. I'm thinking of some nice graphical calendar view perhaps. I have another...

I would appreciate if I can get help in creating this macro. I have two workbooks, and want to compare the specific column from 1st workbook, Ex: Column H with next work book, Ex: column A. After comparison highlight the matching cells in 1st workbook.

I'd like to insert multiple blank rows into my excel data which is thousands of rows long. The amount of blank rows needed to to be input will be from a value in the cell thats activated. At the moment i have code that only does 1 row which is shown below but its only a start. Any help would be...

When I protect/unprotect cells and then protect the worksheet I allow users to Sort / AutoFilter / Insert Rows. They are only able to perform these functions once and then that ability is removed and they can no longer perform those functions. Is there a way to override this and always allow...