Say for example, I want to count how many people are in a room while others are in that room for each day. When that person leaves, I want an updated count of h
When opening Excel it looks for an add-in that I have removed from the file folder. It gives me the message that it can't find it, of course,
I am using syncfusion_flutter_xlsio library for generating excel file and saving it. When my data is so big I have to present progress. How can I perform it? Wo
I have sheet with same data in adjacent cells,I could to merge same cells on column A. now I need to merge or combine adjacent same cells beside merged cells on
The following Single line of executable code; .. Works on my work PC (Win10 Pro 21H1) .. Crashes on my home laptop (Win 10 Pro 21H1) Exact same version of Excel
I have a dataFrame with around 28 millions rows (5 columns) and I'm struggling to write that to an excel, which is limited to 1,048,576 rows, I can't have that
I have an array of non-ordered integers, and I am trying to return a TRUE or FALSE based on if x consecutive numbers can be found within the array Example array
I have 2 excel files with single sheet,there have same column name,one column name id is 'name'.I need to merge the second file data in the first file,and the '
I have the following range of values: National museum of Natural History Archaeological Museum, Art Museum, Agricultural Museum, Marine Museum National museum o
I want to run this in loop by taking two variables for example i and j. Suppose i for sheet 1 and 2 and j for Sheet 3 until I dont reach the e
I have an Excel file containing thousands of rows. There are ID, Planned End Date, and End Date columns. All IDs need to have at least one sam
Im new to VBA, and i have something i dont understand now. I've been trying to copy Worksheets by only copying Cells with a specific colour in a cell below. I w
I would like to write a dataframe to an existing .xlsm file which already has content. Write pandas dataframe to xlsm file (Excel with Macros enabled) describes
Basically, I hoping to achieve 2 things here. I want to know if there is a way to make this multiple criteria IF statement shorter/more effici
I am trying to map a SharePoint document library so I can parse it with a FileSystemObject. Here is my code ... Dim objNetwork As Object Set objNetwork =
I'm designing a datasheet that updates itself automatically. All of the macro code is working properly, but I have trouble locating the place where the data sho
I would like to use cell values on Sheet 4 to select and export Sheet 1, Sheet 2, and Sheet 3 as one PDF file. For example, if Sheet 4's A1=1, A2=1, and A3=0,
I have 2 worksheets (Input & Record), I just want to copy some data from "Input" to "Record", it worked but if I protect "Record".... Paste method of Worksh
There is a date column used in OBIEE analysis. That column is declared as 'date' datatype in Oracle table, type in rpd is also 'DATE'. However, when exported to
Could someone please help me to mask the password entered to the input box generated using the below code. I will be using Office 365 ProPlus. Option Explicit P