Questions tagged [excel]

Only for questions on programming against Excel objects or files, or complex formula development. You may combine the Excel tag with VBA, VSTO, C#, VB.NET, PowerShell, OLE automation, and other programming related tags and questions if applicable. General help regarding MS Excel for single worksheet functions is available at Super User.

Filter by
Sorted by
Tagged with
0
votes
0answers
21 views

VBA find decimals and copy

I am trying to find value that contain decimal point in the collumn F, then copy those row into another sheet. I dont know how to find the value of decimal. If i set the Value = "1" it will work, it ...
0
votes
1answer
15 views

How to log results from a single cell as I recalculate (F9/simulation) in a Excel worksheet over many trials

How to log results from a single cell as I recalculate (F9/simulation) in an Excel worksheet over many trials? I'm working on an excel sheet that does a financial simulation. The simulation produces ...
0
votes
0answers
11 views

Get values from a sheet referncing another sheet within the workbook

I have to read all the values from a sheet using apache poi. However, the sheet references values from another sheet. For eg. I have to read cells of sheet1 which reference values from sheet2. Like ...
0
votes
0answers
11 views

Excel XML custom Qat OnAction Fail

I have Excel XML with the 'Office RibbonX Editor', found here: https://github.com/fernandreu/office-ribbonx-editor/releases/tag/v1.5.1 The XML is: <customUI xmlns="http://schemas.microsoft....
0
votes
1answer
28 views

Excel if 2 column values match then merge content

I'm trying to accomplish to get the below result in Excel. I have a sheet with over 15k rows which I want to merge in some cases. I have absolutely no experience with Excel, VBA etc. What I try to ...
1
vote
1answer
15 views

Reading An Excel file from Python into memory and pass sheets to Pandas

I would like to read into several pandas data frames many sheets of an excel file. So far I use: myfile = filename myfilecomplete = os.path.join(mypath,myfile) df_data=pd.read_excel(...
0
votes
1answer
30 views

Test a range with Excel

Let's suppose an excel file composed of three cells: A1 : 1 A2 : 1 A3: A1+A2 Is there a way to continuously vary, by dragging the mouse for example, the number displayed in A1, between 1 and 1000, ...
-1
votes
2answers
19 views

rotas which turn text into number

I have a weekly rota in excel, and what I would like to do is if a cell contains any text ad 70 in another cell so if cells a3,b3,c3,c4 all have text but c5 does not the total would be 280. is there ...
0
votes
1answer
35 views

Saving a file with other file's name

I have a template file at its own folder where I copy data into from a bunch of perodic files from a different directory. The process I am attempting to automate is to copy data from first periodic ...
-2
votes
1answer
20 views

High score lists with combined result

I've been searching for a solution to create a highscore list, and found that I could use the large formula and an index match to search up the name. However I come up short when I want a list where I ...
0
votes
0answers
17 views

Add hyperlink to smartart node with interop-excel in c#

I have an c# console application which create an excel worksheet containing a smartart object with the hiearchy layout(OrgChart). I would like to add hyperlinks to the nodes within the org chart, but ...
-1
votes
1answer
12 views

How to seriazed Tm Extra Product Options Order Data while exporting using WP All Export Plugin

I am using TM Extra Product Options for adding custom/extra product options for orders. Here is my product page picture: I also used WP All Export plugin for export order data. During export I have ...
-1
votes
0answers
31 views

Excel data transfer from one workbook to another workbook

I am trying to transfer data from one workbook to another workbook (both workbooks are in the same folder). Source workbook name is "Sales_Data" and it contains many worksheets like "Sales_2018_JAN", ...
1
vote
3answers
42 views

Excel multiple IF statements or macro's to solve this problem?

I'm trying to make multiple IF statements in Excel help my club convert event registrations into a template which can import into a scoring program. The registration export places 3 attributes into ...
0
votes
1answer
47 views

Running a Macro in Excel as a VBA-Event

I'm looking for a way to create a macro that would automatically run before any other macro starts running. I know about the VBA-Events that help to create automatic macros but among the events VBA ...
0
votes
1answer
19 views

Transpose columns to rows keeping first column as it is in excel 2013 programitically [duplicate]

I have data in the below format. This is the result I am looking to achieve. As I don't find any direct way in excel to transpose the data as per my requirement, so i am looking it to do it ...
-3
votes
0answers
25 views

To check if I can find a series of character (substring) in another string using VBA? [on hold]

I have a list of author names, which is actually mixture of first name, last name, or combination of firstname and last name. Example if name is Ravi Kishen, in author name sometimes it is mentioned ...
0
votes
2answers
16 views

pandas read_excel with multiindex and parse_date; how?

I am trying to use pandas read_excel to read an excel file with two header rows, and a column which contains dates. I'm trying to use the parse_dates feature to specify the date column to parse, but I'...
0
votes
0answers
31 views

Object doesn't support this property or method, If I declare variable with correct type

I declare 2 ClassModules: Class1 Public MyProp As Class2 Public Sub MyMethod(val As Class2) Set MyProp = val MsgBox MyProp.Foo End Sub Class2 Public Foo As String Sheet1 Private Sub ...
0
votes
1answer
41 views

How to give value 0 to absent values

I have a list of tuples, including the date, and the number of "beeps" on that date. However, if there were 0 beeps on a certain date, then that date is simply not present in the list. I need these ...
-2
votes
0answers
23 views

Multiple if statements to satisfy the requirement

I need your help to automate a long manual activity which takes allot of time. Every week I have received stock transfer requests of 500 line items from Warehouse#2 and WH#3 to replenish the stock ...
-1
votes
0answers
21 views

Excel - Data entry based off value of other cell

I'm not sure if this is something possible in excel, but I'm really hoping it is. I want a script that can read the value of a cell in one column and then place a predefined (and hopefully formatted)...
0
votes
1answer
35 views

Excel - Data extract from one worksheet to another spreadsheet

I am using the below script to extract the data from one sheet to another sheet within the same workbook. Sub Test() Dim SourceSheet As Worksheet Dim TargetSheet As Worksheet Dim LastRow As Long Dim ...
1
vote
3answers
47 views

VLOOKUP with multiple criterias in different columns [duplicate]

I have the following Excel spreadsheet: A B C D E 1 Products Brands Revenue Search Criterias 2 Product A Brand1 500 ...
-5
votes
0answers
36 views

Stochastic Oscillator? [on hold]

Does anyone have the Macro/VBA code for the formula of a Stochastic Oscillator?
0
votes
2answers
26 views

Sort list by the difference between two values

I have the following Excel spreadsheet: A B C D 1 Budget Actual Sort by Variancy (descending) 2 Product ...
-2
votes
1answer
32 views

VBA code to add blank row above specific text

Need help to add a blank row on a file above the word "Costumer". Found the below one but can't make it work on the specific worksheet on the workbook. thanks in advance Private Sub ...
0
votes
0answers
23 views

Compare column value with series of auto sum value in Power Pivot?

I have problem where i need to get the number of weeks after which my stock will run-out. In my table i have: "Forecast Regulier calc." which is the total sales. And the auto generated total is the ...
-3
votes
0answers
38 views

How to refer cells only

Hi how to modify the code below code it copy the exact copy Windows("BL P - V3.xlsx").Activate Range("C5:G5").Select Range("A27:A27").Copy Range("CWD72") _ Application.CutCopyMode = False Selection....
-2
votes
1answer
31 views

Excel VBA - Paste data in a specific format to another sheet

I have the following data on Sheet1: Column A Column B<br/><br/> AA Google<br/> BB Google<br/> CC Amazon<br/> DD Amazon<br/> ...
0
votes
2answers
32 views

select value from website dropdown by vba

i am trying to select value in website drop and i try so many way but nothing works I am stuck at one point where I need to select value from the drop-down box I have four drop down and i want to ...
0
votes
0answers
12 views

Force Enable Macro + Date Expiry Macro in excel workbook?

I want to run 2 macros. one is force client to enable macro and excel date expiry after specific date. i already got the code for force enable. please kindly tell me excel date expiry code. and how ...
0
votes
0answers
15 views

Overwrite of Excel destination using drop and create table statement in SQL task is not working properly. The new data is adding as new records

I have been trying to overwrite the data in excel destination in ssis package. I use SQL Task to restrict overwrite of the excel data. I used drop statement followed by create statement. Then also I ...
0
votes
0answers
24 views

Deleting outlook emails using VBA and sender names stored in an excel file [on hold]

I am looking for a way to delete outlook emails using VBA where an excel file has list of all the sender names for whom the emails are to be deleted. Thanks in advance!!
0
votes
2answers
58 views

How do I optimize my code to delete large number of rows (e.g. ~500k rows) based on a certain criteria

I have a large number of rows and columns (e.g. 500k rows and 20 columns) all filled with numbers. I'm trying to delete all data in column I that has a certain value (e.g. less than or equal to 8), ...
0
votes
1answer
16 views

CHITEST based on another column value in MS Excel

I have a table like this: ID Category Animal Version Value 100 A Dog 1 20 100 B Cat 2 50 100 B Dog 3 50 200 A Dog 1 100 ...
0
votes
2answers
50 views

Excel: get text value of non-hidden cells

This formula SUBTOTAL(3,OFFSET($F$5,ROW($F$5:$F$400)-ROW($F$5),0)) gives an array of 0 for those cells that are hidden and 1 for those not hidden. What I'd like to have is an array of 0 or blank ...
0
votes
0answers
8 views

Randomizing the text of a question in XLSForm

I am designing a survey in XLSForm. I need to randomize not only the order of choices, but also the text of the questions. Some questions are made of four sentences A, B, C and D. I need them ...
-3
votes
2answers
43 views

Don't understand cause of this “index out of range” error

I know it is a simple question but I cant seem to figure out why it give me this error. import datetime,openpyxl,re wb = openpyxl.load_workbook("..\\test.xlsx") print(wb.sheetnames) sh = wb["July"] ...
-1
votes
0answers
20 views

To upload pdf file AND msg file in html webpage using vba codes [on hold]

I do not have codes yet for this request. But I would appreciate if someone could provide me generic vba codes and I will just tweak it to fit my needs? These are the requirements. Excel vba tool to ...
0
votes
0answers
10 views

Excel Macro stops on .csv file open with Shortcut key

I want to open a couple .CSV file and save them as an .XLSX file using a macro shortcut. When I run the macro below, saved in PERSONAL.XLSB, using View>Macro>Run all works fine. Two .csv files are ...
0
votes
3answers
59 views

Adding numbers in a column via Excel VBA

I am a beginner in VBA and i have written this code which is not working as expected. Actually it's adding numbers in a column but not adding the last cell, so for example if there are three numbers 1,...
0
votes
0answers
19 views

Need a VBA code to clear the contents of row A if the cell starts with a number [on hold]

I'm looking to clear the contents from anything starting with a number I'm new to vba so I tried copying some code and changing it around but I don't know enough of what I'm doing.
0
votes
0answers
18 views

Is there a way to apply a wildcard to locate XLS files for file conversion? [duplicate]

I am working on a project to locate an XLS file in a specific directory and change it to a CSV, which will then be imported into Sequel Management Studio. Currently, my code below will grab the file ...
1
vote
0answers
31 views

Return multiple corresponding value based on a cell in Excel

I am creating a dashboard in Excel and trying to return only certain values from another worksheets based on particular cell. I tried this in vlookup but returns only the first match. Can VBA be used ...
0
votes
0answers
7 views

Participant editable table within survey

Is there a survey platform for example, Qualtrics or Google Forms that will allow me to create a participant editable table? This is for a social network analysis where each participant has different ...
0
votes
0answers
30 views

Run-Time error '1004' PasteSpecial method of Worksheet class fialed (only when CHROME Open)

I am newly encountering this error. I am not sure where it is coming form. I have run this bit of code literally thousands of times and now today for some stupid reason it is failing. I have been ...
1
vote
1answer
28 views

Why ExcelApplication.Workbooks.Count is showing zero even when I have an Excel workbook open

ExcelApplication.Workbooks.Count is showing count = 0 even when I have a document open. ExcelApplication.Workbooks.Count shows count = 1 when the document opened is not in protected view. But when ...
-1
votes
0answers
24 views

Excel comparing Date/time to a date/time range

Cuurently I have data of incidents that occurred a a specific date and time(column A). I have personell that work differnet dates and times and I want to compare which incident fell in which ...
0
votes
1answer
34 views

How can i re-appear an object saved to a collection to Excel?

I want to rearrange some graphs in my spreadsheet! To do so, i want to save them into a collection list, delete them from my sheet and place them with the order i want! For example, if I save a number ...