289,921 questions
0
votes
0
answers
10
views
Playwright: Unable to enter formula in Excel Online cell (A1) despite clicking and focusing
I'm automating Excel Online using Playwright (TypeScript) and trying to enter =TODAY() in cell A1. However, despite clicking the cell, moving the mouse, and even double-clicking, the formula isn't ...
0
votes
1
answer
27
views
EXCEL: Transpose data from row to column?
I have a table that contains attendance of one year, now my dates and values are in row and i want it to be in column for each student. Student name will repeat untill his one year attendance fall in ...
0
votes
2
answers
27
views
Using the filter function to return all instances in which criteria matches two other cells, one of which has multiple lines of data
I have seen many posts for using the filter function for multiple criteria and the solutions works great if both cells that you are looking for a match in only has 1 line of data. I have a spreadsheet ...
- 11
-1
votes
3
answers
40
views
display 'Received" if a row contains referenced loan number and doc type
I have an Excel sheet that lists all the documents that have been received.
Loan number
Last Name
Doc Type
354
Smith
Title
354
Smith
Deed
354
Smith
Mortgage
765
Wilson
Mortgage
765
Wilson
Deed
...
- 23
-1
votes
1
answer
13
views
auto updating excel sheets across workbooks [closed]
My hospital has a rostering workbook that is stored in 2 different locations. Each ward has their own ward roster in their own ward and then admin collates all the sheets into 1 workbook for all the ...
- 1
0
votes
0
answers
28
views
referencing spilled ranges as the table array in lookup... but not spilling
in row 4 from D4 onwards i have a transposed spilled range of stock tickers (UNIQUE from a table reference). Each has their stock price history on a sheet of its own, the matching sheet names are ...
- 13
1
vote
0
answers
33
views
How to identify if Windows is running on a Mac in a virtual machine
I know that when using Excel VBA, there can be a slight difference in how font sizes are rendered between a Windows and Mac system, due to the different operating system's handling of pixel density ...
- 11
1
vote
2
answers
58
views
Generating set of random numbers
How to generate sets of more than one random numbers from a given set of numbers. For example, lets say a given set of numbers is {1,2,3,4,5,6}. I want to create a 100 sets of two numbers (or 3 or 4) ...
- 111
0
votes
2
answers
43
views
Powershell Script issue opening Excel using Com Object
I have a Powershell script that opens an Excel workbook, gathers and processes some information from it then closes it.
The issue I have is if I have the workbook already open in Excel it works as ...
- 1
1
vote
1
answer
37
views
Counting non-hidden rows which contain a value other than zero in Excel
I have a table in Excel called TMarks.
It includes a column called AdjustedMark, which contains values between zero and 100.
Sometimes the data in this table may be filtered. I want to count the ...
- 337
0
votes
0
answers
51
views
Error with Excel Lambda function in Name manager
I have set up a Lambda formula that calculates interpolated values from a given set of coordinates
similar to existing trend/linest/forecast functions
handles non consecutive inputs as well as errors ...
0
votes
1
answer
44
views
Excel - Adding a zero infront of decimal with TEXT function
Im am using the TEXT function within a formula, for numbers over 1 it works fine. For anything below e.g. 0.89 it returns .89 missing the zero which i would like included.
Have the following in the ...
- 27
0
votes
1
answer
39
views
Having issues with an Excel 2019 sort pulling in the row above the selected area to sort, can anyone help me fix this
I am trying to help out my golf league to automate their weekly schedule spreadsheet manipulation by writing some VBA code. The process involves recording macros to mimic their process. When trying ...
1
vote
1
answer
56
views
Compare values in one sheet to alternating columns in another sheet
I'm an absolute beginner to VBA with no coding background, and trying to make a sort of inventory application. I got stucked and tried so many code snippets found on internet to no avail.
I'm trying ...
- 17
0
votes
0
answers
25
views
Protect cells from editing with password unknown to all except an outside user
I want to create an Excel file that is meant to be filled out weekly by users inside the company and then then sent for verification outside the company. The file needs to:
Allow our users to enter ...
2
votes
3
answers
110
views
Excel VBA If statement is not working, even though the values match
In my code, the If condition is not working and I can't find the reason. I've tried using the cell's value, text, formula, etc., but none of them work. I have also tried converting these values into ...
- 21
0
votes
0
answers
17
views
How to structure an Oracle XLS excel template to display repeating child elements in separate rows?
Question:
I am working with an XLS (Excel) Template in Oracle BI Publisher (BIP) and need help structuring my template to handle repeating child elements properly.
I have an XML data structure where ...
- 599
1
vote
1
answer
67
views
Reference Outlook in Excel VBA: User-defined type not defined
Sub Alerta_email()
Dim meuoutlook As Outlook.Application
Dim criaremail As Outlook.MailItem
Range(“E14”).Activate
Do Until activateCell.Value = “”
If ActiveCell....
- 11
0
votes
1
answer
55
views
Find the number and update the value in second match cell
I have a typical requirement. I came across multiple sources but somehow i dont get the answer for my query.
My requirement is, i have 3 columns with item, color, type. Item column contains name of ...
0
votes
1
answer
31
views
pixel to excel cell conversion by xlwings
I am trying to convert pixel value to spreadsheet cell_id, but the conversion is not exact, meaning it's not so close, any idea what is wrong with my code ?
import xlwings as xw
from openpyxl.utils ...
- 21.3k
1
vote
1
answer
47
views
Problem with cleaning csv data before Importing in PostgreSQL
I started studying SQL a month ago. I'm trying to import a .CSV file but I have a problem.
In the that file, there are numbers written in quotes and where decimals are divided by commas.
In Excel, if ...
-1
votes
0
answers
35
views
Excel offset - referencing other sheet [closed]
In my "Scenario Summary", at cell B6 (I move the formula to cell H10 just to make it easier to see), I want to enter formula such that:
Go to sheet "Project Valuation"
Then in ...
- 1,081
0
votes
1
answer
57
views
VBA Option Buttons Clearing for Unknown Reason
I’m building off a workbook someone created years ago where Sheet 1 has primary equipment info entered into ActiveX text boxes and option buttons, with matching ActiveX controls below it for secondary ...
- 3
-1
votes
0
answers
40
views
Excel lookup formula to reference cell and not row [closed]
For this formula I want to reference the cell name instead of the row on the tab. When i reference the cell name it doesn't work for me. What do I change to make it reference the name? I want it to ...
- 13
-2
votes
0
answers
13
views
Referencing to an entire column and ignore blank values [duplicate]
I have some raw data in Sheet1 of my excel file. We are trying to reference to column A : "Experiment_ID" from Sheet1 in Sheet2. However, we would like to get rid of all the blank values in ...
- 329
0
votes
1
answer
72
views
VBA Subscript out of range when closing a UserForm?
I'm relatively new to VBA and still learning - but finding lots of helpful information on here so thank you!
I'm having a bit of a problem with a userform I am creating... It all runs okay and the ...
-4
votes
1
answer
83
views
VBA for loop exercise with merged cells. How to get it right?
I need to write a VBA script using a loop or a few loops, which in the end will print the data, by debug.print looking like this:
can, kg, green, pea, 24.79
Here is the image of how my sheet looks ...
- 11
-1
votes
1
answer
60
views
How to identify in Excel all blank cells as well as each cell's column header and row header?
Please can you help advise whether I'd need to use either VBA or lookup to produce an Excel table which details each employee's department, name, and their available dates?
I have an Excel spreadsheet ...
- 1
0
votes
1
answer
65
views
Excel Filter Function based on a variable sized array of conditions + inputting results into a 2x2 grid
I am looking to make a pre-existing function more dynamic such that the user can readily change the filter conditions without needing to delve into the formula and changing manually. I would prefer a ...
-2
votes
0
answers
28
views
Write and fill Excel file with scraped data using Puppeteer and Node.js [closed]
I have a bunch of data stored in an array of objects and now want to fill it into an already existing Excel file. Each property has its column where it needs to be filled into and it should start ...
1
vote
1
answer
48
views
Macro with erratic behaviour on copy function
EDIT: The trigger seems to be when LastRowNo is 3, which is the same value as Const StartRowNo, which makes the macro copy a cell into itself. I inserted If LastRowNo = StartRowNo Then Exit Sub right ...
- 31
2
votes
2
answers
49
views
Running SQL query from excel and refer to specific cell
I'm using excel to run sql query and i want to refer the WHERE command to a specific cell in excel. For example, my code is:
SELECT [Value]
FROM [Sheet1$]
WHERE [ClientID]=2>
Instead of 2, i went ...
- 21
0
votes
0
answers
64
views
I get a #CALC! error when I add the BYROW() function around a working formula that returns a single result?
I have a formula that creates several embeded arrays that get anyalysed to return a single result.
When I feed this formula with the "concatinated string" row by row it works perfectly, as ...
0
votes
0
answers
23
views
Powerquery not able to access data behind slicer
Beginner with powerquery sorry!
I'm trying to access trade data in a workbook where a slicer is filtering according to exports/imports etc.
The result is that I can only access the 'default' set ...
- 95
1
vote
1
answer
64
views
INDEX MATCH Function Inconsistent
I have an excel table (Sales Table) that uses an INDEX MATCH function within a few columns. There are 2 specific columns (Product and Part Number) which are using a material number column to pull ...
- 39
0
votes
1
answer
37
views
Update notes (comments) looping through range
I have a workbook with several sheets.
The "HVAC TOOL" sheet houses a pricing worksheet for our sales staff.
Each unique equipment type is listed on this worksheet in
Sheets("HVAC TOOL&...
0
votes
0
answers
25
views
Tabulator: How to export an image and a hyperlink as XLSX download?
I have an image in my Tabulator table. I want to download the table into Excel, including the image. How can I put the images into Excel cells from Tabulator?
If I cannot export the images themselves, ...
- 2,444
0
votes
1
answer
41
views
Create Dynamic Named Range, based on adjacent value
Without using VBA (need to save as .xlsx), is there a way to create a dynamic named range?
Name Include
Dr. Nick Yes
Dr. Hibbert No
Dr. J No
Dr. Spaceman Yes
I am ...
- 23.3k
0
votes
0
answers
56
views
How to Run Excel VBA Macros with Power Automate without logging into Windows
I currently have several Excel VBA macros that open the desktop Outlook application, download specific files from received emails in certain email accounts, perform operations, and send an email back.
...
0
votes
1
answer
59
views
Excel vba mail merge first and last record not working
I am creating a spreadsheet to automate mail merge from a selected line in a listbox.
My function opens the word document ok but the first and last record section is not working and the mail merge ...
0
votes
1
answer
39
views
Export to Excel head row format filter
Tell me how to add the filtering option to the head row as in the screenshot? Using Visual studio, SDK DocumentFormat.OpenXML.
WorksheetPart worksheetPart = workbookPart.AddNewPart<WorksheetPart&...
- 1,259
-3
votes
0
answers
58
views
Need inject an appointment into a shared calendar in outlook
I use this VBA code, from Excel, to inject an appointment into a shared calendar in outlook, this code works perfectly with my email, but with the email of the person who shared their calendar with me ...
0
votes
1
answer
38
views
Copied cells does not always apear at the top av the pasted sheet
I am trying to move specific rows according to earlier formulas from one sheet to another but there is no continuity in where the cells get pasted in. I would like them to start at the top but ...
- 3
2
votes
2
answers
59
views
How to get common data from a large data set sheet into a small data set sheet with common entry in first column and match them accordingly
I have two sheets, Sheet 1 which has all the entries of Part Name in the system and specialized data of that part like sequence, due date and quality.
Sheet 2 consists of Part Name which is common in ...
- 35
0
votes
1
answer
115
views
Selecting a dynamic range of cells, dependent on another cell in Excel
I am looking to perform a calculation to ascertain an employees overtime hours per week. There are a number of factors that I need to take into consideration when calculating:
The number of hours per ...
1
vote
1
answer
57
views
SendUsingAccount of Shared Mailbox
I am trying to find the equivalent of MailItem.SentOnBehalfOf for an AppointmentItem. My extensive research tells me AppointmentItem.SendUsingAccount is the only option.
After re-thinking my e-mails (...
- 23
0
votes
0
answers
34
views
pipx installed xlwings module not found
I have an Excel workbook that uses an xlwings RunPythonScript() call to an external python script. As I want to run this python script outside of my vdev I've installed pipx and through pipx installed ...
- 11
2
votes
2
answers
89
views
Flatten a hierarchy with recursive LAMBDA formula, or with Power query?
In excel I have this table with 2 columns :
Table called T_DATA
dataset
datasource
APP1
DTM1
DTM1
Dataset1
DTM1
Dataset2
DTM1
Dim1
DTM1
Dim2
Dataset1
Raw1
Dataset2
Dataset3
Dataset2
Raw5
...
- 21
1
vote
1
answer
27
views
Excel automatically renames back ActiveX controls when reopening XLSM spreadsheet file
I had added an ActiveX control (in my case, it was a ComboBox, but it might as well be a button or something else) to a spreadsheet, and named it Analysis1_FileAction_ComboBox. Later I renamed it to ...
- 3,539
0
votes
0
answers
20
views
Unable to Navigate to URL from Excel DataRow in Power Automate Desktop
I'm currently working on a flow using Power Automate Desktop, and I'm encountering an issue accessing a URL from an Excel DataRow.
Here's the scenario. I've successfully read data from an Excel ...
- 15