I have an excel file with multiple sheets, the actual data I need from each sheet is from cell B7 to F38, how can I merge all the sheets' data into one by using
I have two columns in excel, one with a date and one with a rating 'low, medium, high'. I'm trying to write a formula to put in a third column that checks: If A
i want to make a connection with a DBF file through VBA, i have installed all the drivers but i get this error message every time i try to run it Object variab
I am a real novice at VBA, so any help would be welcome. I am trying to convert certain ranges across multiple sheets into only one file. I have written code fo
Suppose we have 2 cells, one contains zero and the other is empty, see the range A2:A3 in the figure: If they pass a FILTER we get two zeros as a result, see t
I have this simple script that creates a list by taking the values out of the column of excel_1 and compares it to the values of a column in excel_2. I want it
I am trying to register some functions and have success up until the length of my string exceeds 255. I have written the below function to cycle through the lis
I have a problem reading the code with openpyxl, until yesterday it works, and now it doesn't work anymore, I tried also with a backup copy but I have the same
I am trying to generate some code that will open up an excel file on Sharepoint and copy data into another spreadsheet. I have been using the below code when th
is it possible to compare particular values from a table/report from power bi data set with another table from excel sheet? In the power bi data set i have the
Im working on creating an macro that will pull data from a specific group of ranges across many files in one folder and feed that data into a master file in the
How can I extract a range of cells (from a sheet) and extract said range of cells to an additional excel sheet based on user input (yes or no drop down menu)? T
I have an Excel sheet that has a connection to SQL server to generate some table data into the spreadsheets. There is a strange issue where the spreadsheet get
I have an Excel sheet that has a connection to SQL server to generate some table data into the spreadsheets. There is a strange issue where the spreadsheet get
I am trying to read an excel document which has a datetime column.Uploading it to the website,instead of date column i get those numbers which represent the tim
I am trying to write an array into Excel. The code snippet is below. import win32com.client as win32 import sys import numpy as np #-------------- if name=="ma
I am trying to create a PowerShell script that adds two leading zeros to all the numbers in a particular column.This script is able to add the two zeros to the
I have 1 workbook with multiple sheets and I am running into an issue copying over data from one sheet to another. Sheets - "ALL CONTACTS" & "MAA DATA" Ther
I have a list of unsigned 32-bit unsigned integers that actually are supposed to represent 32-bit signed integers. For example 62714 = binary 1111010011111010 =
Sub Copy_Worksheets_Columns_Rows_to_ALL_D2() 'PURPOSE: To loop through all Excel files in a user specified folder and perform a set task on them 'Task: