I have a macro that splits a string (list of names) using a space as the delimiter and creates a new row for each name while keeping all data the same in other
how to develop ms excel ribbon functionality not COM add-ins or VSTO add-ins. Using visual studio Thank you I want to implement excel ribbon functions to valida
Our office runs Arobat DC Pro and Excel 2016, we have been using the code below (scaled down version) in Excel VBA for years to save active Adobe PDF documents
Is there a way to identify if a worksheet has a highlighted cell at a worksheet level, without checking all the cells? Further context: I have a WorkBook with a
Is it possible to store some numbers in one cell (as an array)? Please see below: cell A1: 4,4,3,4,1,3,3,4 cell A2: 5 (5th element of array)
I have an Excel file for label template with 6,300 items (each item has a parent ID which matches the picture name that suits the child item). I found code that
I have pivot table amount columns: 0-100, 100-200, 200-300, 300-400, 400-500 How to make group by more criteria? I want until 100 group by 25, then from 100 u
I'm trying to tell python to insert "No work" in certain amount of cells, depending on how many days has passed since the codes was run. So basically, let imagi
I currently have code that inserts two columns, and copies values from two other columns into these two new columns. 'Insert 2 Column to the Left of S Colum
I have an existent graph to which I added a macros. The macros should update the axes, add a datalabel to the last point and delete the datalabel of the previou
Trying to dynamically get cell value from worksheet in same workbook, depending on worksheet name in column E =IF(E108<>"",INDIRECT(CELL("contents", E108)
I am using Read Delimited Spreadsheet.vi in LabVIEW and need to read data from other than the first sheet. How do I tell LabVIEW that want to use other than the
I am trying to download an Excel in Sharepoint site into an R dataset. But I keep getting errors. I have also tried searching for solutions across forums for th
I'm trying to get the shorten bit.y URL in my excel file, but instead I'm obtainig the following message, {"created_at":"2022-05-04T21:48:32+0000","id":"bitly.i
I am using this formula to pull the client's highest score: =MAX(IF(FILTER(Appointments!G:G, Appointments!C:C=C2)>0,FILTER(Appointments!G:G, Appointments!C:C
From our audit database I derive an Excel table like this one below. What I need to do is populate a table in a word template document with the content of the f
I am currently trying to produce a filter/summary for a data set using Sumproduct. The data is a list of codes, regions and managers each with a row value (&po
I am new to PowerShell. I have a file name as Input.xlsx file, which will contain 3 columns and we an filter on any column and save it. My requirement is to cop
I want to ask something. I have data close to the lineare in Excel but with different values: Y: 88.0 87.4 86.5 83.2 X: 2004 3002 3900 4500 I have created a gr
I'm using Apache POI 3.6, I want to read an excel file which has a date like this 8/23/1991. switch (cell.getCellType()) { ... ... case HSSFCell.CE