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 ...

0
votes
0answers
11 views

Excel VBA NOW() pasted into cell not being recognised as date/time

Im having trouble with the NOW() function after it is pasted into a cell. To give you a brief description, I have built a Checkin window that records times of when people start end work via a user ...
0
votes
0answers
2 views

Excel Time Comparison and Subtraction

I am trying to do a time subtraction in excel of 30 minutes and I am running into a speed bump. So the table I have are as follows. Table "Schedule" Column 1 is day of the week (Mon-Sun) (formated ...
0
votes
0answers
6 views

Keep Iterating the Results on different sheets of excel with python

I have list of queries i.e. queries = ['select * from emp', 'select * from dept', 'select * from user'] Now what I want is, to execute these queries, save their results in seperate sheets. Means I ...
0
votes
1answer
7 views

How To Repeat One Cell Value X Times In Excel Another One Cell

I have a sheet like this Can you please let me know how I can loop on column A based on column B and create comma separated with -0 , -01 .... to column C
-1
votes
0answers
4 views

Merge and auto hide.?

Iam new to learn excel function,so I needed your help. Here my Qus is ? I have listed two colours in two cells.(like Cell(A) listed N.No.of colour , Same to Cell(B)).When I will select these two ...
0
votes
0answers
6 views

ASP.NET - Validate Excel File Content

I have a page with a file input where the user is supposed to upload an excel file to insert a large amount of records to a specific table. I found this Javascript code to help validate if the ...
-1
votes
0answers
11 views

Excel to interactive Web Application

I am looking for a way to be able to upload an excel sheet (with VBA etc.) from a local computer to the web so that users can interact with the input and see the outputs on the browser as if it was ...
0
votes
0answers
13 views

Index formula to copy entire row with a date range

Excel 2013 - Sheet 1 is titled "Results" and some of the data includes a date (Column L), an agent's name (Column M), and customer comments (Column N). Sheet 3 is titled "Report". On sheet 3 I need ...
0
votes
0answers
15 views

What is the excel equation equivalent to Google Sheets filter equation?

In google sheets, you can use the "Filter" equation to quickly pull information between sheets conditionally using just that one equation. Is there a similar equation (not VBA), not Vlookup, not ...
0
votes
2answers
25 views

How to find duplicates values in rows?

How to find duplicates values in rows using conditional formatting? before: After:
1
vote
3answers
27 views

Excel VBA - How to check if target is a named range. If yes, paste range

I currently have my excel coded to do the following: Whenever various specific text strings are typed anywhere in column B, a corresponding named range will be pasted at a relative offset. Instead ...
1
vote
0answers
12 views

The DAX code calculating the sum of maximum values per day

I would like to write a dax code in Power BI which calculate the sum of maximum values of each day. In one column there is a production data and on the second column there is the the date and time. ...
4
votes
2answers
30 views

Excel formula - 2 countif one in another?

That's my first question here ever, though I am reading questions here since a few year. I am looking for a way to do the following with excel formula count how many are line matching a criteria. ...
0
votes
0answers
3 views

Formula to substitute alphanumeric digits in a code for discriptions in prose format

I need to find a formula wich substitutes each digit of a code for a discription and to make it appear as concatenated text. For example: "134B2"- "Older, Tall, Richer, Bad, Boy" "1324B" -"Older, ...
1
vote
1answer
24 views

VBA Can not insert object

I have a process in Excel that adds images from a PDF file with the following code: valRef = "TabName" FilePath = "\\network\file.pdf" ' Process stops in the next line Worksheets(valRef).OLEObjects....
0
votes
1answer
22 views

Updating HTML using an Excel file

I'm creating a HTML showcase to access to an online store to show a series of main products with little data; something like an Instagram page. I already have it done and now I would like to make a ...
-1
votes
2answers
14 views

Creating an array with Indirect()

I am trying to match an email address to a list on a different sheet. Here is the formula: =IF(MATCH(B11,INDIRECT("'"&$D$1&"'!$a$1:$a$1000",1),0)=1,"No","Yes") My problem is that Indirect ...
-3
votes
4answers
16 views

Why show in a cell result #VALUE

I want to get the result from the cell in excel that if f8 = .01 to .6 then it will show E8&A and if f8 = .7 to .125 then it will show E8&B. if not anything then it will show E8. I have ...
1
vote
3answers
35 views

Copy unknown range from specific worksheet

I am trying to do a copy in VBA, as part of a bigger macro so it needs to be in VBA, of an unknown range in a specific worksheet. I have this code that work if I am in that worksheet: Sub Copy() ...
0
votes
0answers
14 views

Excel crashing problem - How to study why Excel is crashing?

We are doing Excel JavaScript add-ins development and testing. Excel keeps crashing 1-2 times per day randomly. It may crash with action from JavaScript Pane or without it just using other Excel ...
0
votes
2answers
24 views

python and mysql downloading data into a csv

im using python pandas and storing mysql queries into dataframes and then downloading the results into excel files query = """ ... """ DF= pd.read_sql(query, connection) writer = pd....
0
votes
0answers
29 views

Booth Booking to show what is available in excel

I currently have a list of vendors who is coming in to rent a booth to display their products in our event. The event rental timeline is some thing like this, 2 weeks rental - 16 Oct to 28 Oct or 30 ...
0
votes
2answers
22 views

Excel - hide the same columns across multiple workbooks

I need to hide the same columns across several workbooks. For example, I want to hide columns B, C, F, H, I, J, K, R, Q, AA, etc, and I need to hide those same columns in many different workbooks ...
3
votes
1answer
28 views

Conditional Formatting alternate rows and matching rows in Excel

I'm trying to apply conditional formatting to my data where I need to color the rows based on certain columns. If the current and previous rows have same data in 4 particular columns, I will color ...
1
vote
0answers
20 views

Add cells values to an Email when they are changed Excel

Im currently working on a small excel "database", were the cells in one of the columns can be edited by multiple people. The cells that can be edited are from a drop down-menu. Once a person changes ...
0
votes
0answers
27 views

VBA: How to choose files from a folder based on a precondition loop in same sub?

I am very new to VBA and I am trying to automate a dashboard process for my team. The dashboard takes two raw data files, I call these raw data and OP. I created a sheet with macro where I paste the ...
0
votes
3answers
23 views

VBA: Delete all slides (in PPT) except for specific ones

I am executing a code in through Excel and I would like it to delete all slides in my PPT except for slide 1, 2, 3 and 17. I can't seem to get it to work. Here is a snip that deletes all slides in ...
1
vote
0answers
12 views

Chart Templates Auto Load in Excel using VBA/Macro

I need help to establish vba or macro for Auto creating Charts using my saved templates. Problem is that I have in 1 Excel file more columns and second sheet. From those columns I need actually 4 ...
0
votes
1answer
12 views

FollowHyperlink without prompt or open a program with prompt vba excel

I have been trying to find a get around to open a program in excel using VBA to just automatically open instead of having the prompt come up. I am doing this so it will just open my e-mail in the ...
2
votes
2answers
32 views

Using VBA to find the exchange rate on a specific date with API Norges Bank

I would like to use VBA to retrieve foreign exchange rates on specific dates useing the API from Norges Bank. I tried to modify a code I have used before to retrive data from another API, but I'm not ...
0
votes
2answers
24 views

Excel VBA Macro Compile error: Expected End Sub

Trying to assign my code to a button which works stand-alone in VBA however but I'm receiving the following error when adding it to a button; Compile error: Expected End Sub My code is as follows; ...
0
votes
0answers
21 views

Algorithm used in Excel Fuzzy Lookup

I was working on matching company names of two sets. I was trying to code it in Python with Levenstien's distance. I was having issues with short names of companies, and their trailing part like Pvt,...
-1
votes
1answer
19 views

How to get the name of the currently active sheet in Openpyxl

I understand calling wb.sheetnames returns a list of the names as strings for each sheet, however I cannot see a way to get the name of the currently active sheet. There seems to be no named attribute ...
0
votes
0answers
9 views

Importing data using xlrd in idle shell

With many references I tried to get the data from a flat file in idle shell environment but something went wrong and I got only the dates in number format. How can I get all the columns as they are ...
2
votes
3answers
27 views

Counting number of cells based on month of a date

I am trying to count ¨"the number of stops during each month", and then place them in another table that contain the header as the months (Data Format). I tried many formulas, in E5: =COUNTIFS(A:A;"=...
0
votes
2answers
26 views

Hide a row (in a list) based on drop-down multiple selection on each of the rows (not on a single cell)

I have a list of "activities" in column B and each of them has a drop-down list for the status in column C. For each activity I can select "Done, In progress, TBD, Cancelled". What I want is to hide a ...
0
votes
1answer
11 views

Excel: Match 2 Items, Including if Date is Between a Date Span on Multiple Worksheets

I have 2 worksheets: Worksheet 1: Member ID, Engagement Date and other data. Worksheet 2: Member ID, Policy Begin Date, Policy End Date and other data. On Worksheet 1, I want to return a policy type ...
-1
votes
1answer
23 views

Converting cells in a collumn in one worksheet as collumn headers in another worksheet

example Worksheet 1 id category 1 dog 2 cat .... worksheet 2 name , dog , cat .... However the first worksheet will grow so I cant use a paste special and when I link the cells =...
1
vote
0answers
40 views

not able to save data into excel file

using (ExcelPackage package = new ExcelPackage(new FileInfo("jsonToExcel.xlsx"))) { ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("abc"); using (StreamReader ...
0
votes
0answers
13 views

Macro to extract data from one Excel File to another if it meets certain “criteria”

I am new to the whole macro coding and creating "smart" workbooks and things like that and was wondering if you could help me with a certain macro to extract data from one file to another. The data ...
-1
votes
2answers
47 views

SQL - Convert data type varchar DD/MM/YYYY to date format in sql

I'm working on a Azure SQL database. I'm trying to convert a field data type containing dates in dd/mm/yyyy format from a varchar(100) to a date field. I am having no luck! Any help would be ...
0
votes
0answers
14 views

Excel VBA: Error When Opening .txt File for Editing [duplicate]

I have this fairly simple code to remove lines from a text file: Public Function AltText() Dim inFile As String Dim TempFile As String Dim FinalFile As String Dim data As String ...
0
votes
0answers
18 views

VBA/Excel - Setting range name to specific value

I have the following data structure: +-----------------+---------------+ | ExcelRangedName | Default Value | +-----------------+---------------+ | Name1 | | | Name2 |...
-1
votes
0answers
10 views

Msgbox from different workbook

I have 2 different Workbook: • workbook-1 • workbook-2 I want msgbox in workbook-1 referring to values in workbook-2. For example: In Workbook-1:(sheet1) | A | | B | | C | In workbook-2: (...
-1
votes
1answer
17 views

VBA MACRO Make Variable Range

I really struggled in making this work. I have below line of code: ThisWorkbook.Worksheets("Diags").Range("$A1:$Y50000") I am successful if I will convert the last number after $Y as below: ...
2
votes
1answer
31 views

VBA keep a number to rows with timestamp

I'm new in VBA and I'm suffering to make a script to work properly. Target: I have on A10 cell a dynamic number, every few days or hours its value changing by a formula. I want to keep all the values ...
1
vote
0answers
15 views

Run VBA macro in workbook using Python xlsxwriter

I am a Python beginner so please have some patience. I wonder is there a way that I can open and run a macro Excel code in a opened workbook before I close it ? Here is a part of the code : ...
-1
votes
0answers
9 views

Excel Macro: Change an Input, Then Paste Values in a Column

I need a VBA code to change a value in a list then copy an entire column of hard-coded values and paste into 3 columns on a separate sheet. I think this is fairly simple, but I am not sure how to do ...
0
votes
0answers
15 views

Excel macro to Automatically generate the data and save file

I have a Excel macro which filters and get the data from another workbook and save as the file in a path I have mentioned. Now I need the macro to do the same for the whole list in the specific ...
0
votes
0answers
21 views

Excel VBA Message Box when there are no blank fields in an autofilter and stop macro

I have a simple macro to set one AutoFilter column(field 4) to a particular value, and a second AutoFilter column(field 5) to show only blank entries. Sometimes there are no blank entries and in this ...