excel script

Hello, everyone, I hope I'm right here :) I've been working with Power Automate for 2 weeks. Goal: Combine multiple CSV files in one Excel file in different worksheets. Convert CSV files to Excel workbooks - Office Scripts Combine workbooks into a single workbook - Office Scripts...

Hi All, I've got a workbook saved to a SharePoint folder. In the workbook is a script. See below. Its the part in bold i need help with. Basically the script needs to add a header to the sheet and a footer at the bottom of the set of data (row number can change daily). The script adding...

I am trying to use Office Script to i) delete a column with a header named "Object Type" and ii) sum up the cells (all the visible filtered cells) in the column named "Hits". I'm new to Office Script and am stuck. I get the following error for getColumnByName: Cannot read properties of...

So im creating a spin button that connects to a macro. The button would increment a cell by 1 based on the hour of the day and what day of the week it is. The code im using is: Sub OneClick() Dim strTime Dim LWeekday As Integer strTime = Time LWeekday = Weekday(vbUseSystemDayOfWeek)...

I am trying to move a whole row(B thru K of the row) to a different sheet when in column (B) on worksheet named Promises, you put either; PAID which would move the row to worksheet named Kept; BROKEN to worksheet named Broken; FOLLOW UP to worksheet named Followup. On the next blank line in...

Hi, I have 2 work sheets in the same file sheet one contains following info name, address, city, state, phone sheet 2 contains following information I downloaded form Australia Post webstite City, PostCode I want to add a extra column to sheet 1 that contains the post code for that city. I...