7. current community

    your communities

    more stack exchange communities

    company blog
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

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

175,881 questions
info newest 2 featured frequent votes active unanswered
-1
votes
0answers
11 views

Macro to filter table based on a criteria and copy/paste into a new sheet

I am new to Macros and VBA but I think I have a grasp of what to do but I have trouble writing the code. I have a list of items in a table from Column A to G, I have to filter data based on Column A, ...
0
votes
0answers
5 views

excel4node add comment work around?

Is there any work arounds to add comments to the cell using the package, excel4node? It is currently not a feature for this package and I find this package to be the best for making excel files with ...
-1
votes
0answers
20 views

VBA - Excel 2010. Loop if then based on cell color and content

Barely a novice in VBA. Excel 2010. I have a (PHI = HIPAA = confidential) report that I paste data into. The data comes from a PDF. Often, when splitting the data using text-to-column, things don't ...
0
votes
0answers
6 views

Extracting .currentCellRow fields from SAP to Excel

I have been using vba with SAP for a while now and have never run into this particular issue. Usually, when script recording in SAP, I click on a field and am left with some string of code with a ....
3
votes
1answer
29 views

Excel maximum minimum value from a range across multiple sheets

I have the following formula drawing the maximum value from the data in column F over multiple sheets. =MAX('Aug242018LB3STRDF$000'!F5:F39004,'Aug242018LB3STRDF$001'!F5:F39004,'Aug242018LB3STRDF$002'!...
0
votes
0answers
17 views

How to have a calculation update automatically with a file with a date

I have a vlookup that I have to update every week with the current date. Is there a way that this can automatically update? =VLOOKUP(B26,'C: Inventory\[Inventory Weekly 2018 (08-13).xlsx]Sheet6'!$...
0
votes
1answer
20 views

Compare two dates and times in excel to return the max biggest of two columns

How do I return the most recent of two date columns, columns also contain N/As. Does the columns have to be in a certain format? Does it have to be date only and time only or can I calculated the max ...
0
votes
2answers
18 views

Filling rows in Excel with alternating formulas referencing different sheets

I'm trying to fill the rows of an Excel sheet with alternating sheet references in each row. For example, row 9 references row 2 of sheet A, row 10 references row 9 of sheet B, row 11 references row 3 ...
0
votes
1answer
41 views

applying a border to a single cell with VBA

I'm iterating over a sheet and printing cells one at a time, and to build a larder nice formatting I need to dynamically add things such as borders. I am familiar with Range.Borders, but is it ...
1
vote
1answer
31 views

How can I locate the cell and do math by the data resulted from other cell in Excel-VBA?

I am trying to create excel Macro for my company. It looks like simple but I keep failing to get the result. I'm not a good VBA user so it would be big help for me if I got your assist. The first ...
0
votes
0answers
27 views

Print to PDF not working

My code is suppose to check cell j2 for an email address and if found, convert that specific tab to pdf and save it in a file path that the user chooses. It works fine on the original workbook I made ...
0
votes
0answers
14 views

Extract text from cell in Excel between two different characters

I am trying to pull the following Z:\Family\Animal\Food\Type\[Food_Type.xlsm] from the this formula: =INDEX('Z:\Family\Animal\Food\Type\[Food_Type.xlsm]Berries'!$10:$10,MATCH(E4,'Z:\Family\Animal\...
0
votes
1answer
28 views

Change the color of x number of cells based on the numeric value from another cell (in multiple rows)

My question is basically the same as this one (Change the color of x number of cells based on the numeric value from another cell) with one extra condition: for multiple rows. enter image description ...
0
votes
0answers
17 views

Solving for 170 Variables in MS Excel

More so a logic question than code question I'm currently working on identifying how long a given product our plant produces takes. Rather than going out and conducting a time study, I'd rather take ...
0
votes
1answer
41 views

daily task automation - copy & paste 2 cells from 1 workbook into another workbook last row

So I receive a daily data excel workbook that has two cells of data I need to keep in a folder and save it as todays date - 1. So for example, if today is 8-24-18, I receive 8-23-18 data. I then ...
0
votes
0answers
10 views

Merging cells in excel report created in Java

Well, I'm trying to create a excel report in java, the response I get is "java.lang.IllegalStateException: Cannot add merged region A18:B20 to sheet because it overlaps with an existing merged region ...
0
votes
1answer
10 views

Line Breaks when reading excel file on html

I am having problems introducing break lines for my bullet points. I am using a meteorjs application that is hosted on heroku, and using readxlsx. I am reading entries from an excel file, but it is ...
0
votes
1answer
45 views

Keep getting a Run-time error '13': Type mismatch

I keep getting a Run-time error '13' type mismatch and I do not know why. I have a sheet (Sheet1) that has data on it that I want to copy to another sheet (Sheet 6) only where info in a column has ...
0
votes
1answer
10 views

Connecting two tables that have a many-to-many relationship in powerpivot

I have a question for you guys on how to connect two tables that have a "many-to-many" relationship. Please see the two tables below: SKU_NO CATEGORYsku_1 hair sku_2 skin sku_3 hair ...
1
vote
0answers
38 views

VBA: Overflow error?

My code is designed to test each agent (turtle) with its respective agent (ninjaturtle). It checks for three parameters. However, I keep getting an overflow error. I have converted my d1 and d2 to ...
0
votes
0answers
36 views

Can't union two tables even though ADODB confirms equal field counts

I'm not able to union two csvs even though ADODB confirms via .Fields.Count that they both have the same number of columns. Here's the query that's failing: select * from csv1.csv union select * ...
1
vote
0answers
16 views

Check if a shared workbook is already open by another user

I am developing a program where some data is saved in an Excel file. It's a shared file, so everyone can use it. Before I open the file, I want to know if the file is already open for write by another ...
-1
votes
0answers
14 views

How to make a drop down list on excel with selection determining the input of data into a row in a separate workbook? [on hold]

When selecting from this list it should enter a specified set of data into a column on a separate workbook. For example when selecting 'delay 1' from the drop down list it will add to a database a ...
0
votes
2answers
34 views

Grouping rows in Excel with similar values

I have a table with the first column containing some numbers and I want to loop through and group the rows of my table based on the values in this first column so that they can be collapsible. So ...
-6
votes
0answers
39 views

Storing variables into memory using a counter

I have an excel workbook that has a master listing of our companies cell phone numbers, and the associated Ledger account strings for finance to record the charges to in the financial records. Some of ...
0
votes
0answers
14 views

ActiveWorkbook.Connections(Query).Refresh makes excel crash

I'm unable to run a macro with more than one query connection refresh without making excel crash. Sub Refresh() Application.EnableEvents = False Application.ScreenUpdating = False With Sheets("...
0
votes
0answers
32 views

VBA code has too many loops which makes it run slower

I have a VBA code which copies same data from Multiple sheet and then paste it in "Main" Sheet. It then auto fills the blank cells for values from above and then it delete all the rows Where H:H is ...
0
votes
0answers
33 views

Sum-product in R for specific conditions

I'm looking to do sumproduct in r as we do in excel. It's a little challenging as i have to apply some logical conditions meanwhile. Excel code looks like this SUMPRODUCT(--(ID=A2),--(INDIRECT(A1)&...
0
votes
1answer
28 views

VBA- How to start pasting to a certain cell

I Have a code that chooses a certain code copies its row and pastes it into another sheet. I need to make each code word start pasting into a certain cell in the new sheet. Ex: for the code PP to ...
0
votes
1answer
18 views

Excel - Extract All Dates from Text

Let's say I have the following cases: Today's Date is 08/20/2020 and tomorrow's date is 30/10/2018. Status = N/A Yesterday's Date status is stuff/things but it is 2020/08/31 and today is 8/20/18. ...
-1
votes
0answers
9 views

NPOI does not recognize CellStyle

Hi i have to use VB (old project) and i wonder why NPOI does not recognize the Cellstyles, the bluecell cellstyle results in grey dots, and the redcell Style results in no background, whereas the ...
0
votes
0answers
12 views

PhpSpreadsheet foreach loop through multiple sheets

I'm new to PhpSpreadshheet, I have a file with multiple sheets (all the same), I cheched all the examples in the Reader section of the documentation, but each example ends with a code like $sheetData ...
-2
votes
0answers
21 views

vba macro for pdf attached auto to mail in specific folder

I have the below code but I don't understand how it will work. I have a number of PDF files in a specific folder on my system and I have another Excel file with Number of Email id with PAN Number ...
0
votes
0answers
9 views

Editable Excel and text on Local Website

I have been given the task of updating a local website that has been running for the last 10 years, I've run into two problem while doing this. Problem 1: The old site has links to download important ...
0
votes
0answers
15 views

How to prevent malicious Excel macros while generating Excel document ? (Using phpExcel)

Security analyst noticed a security hole in our custom-made CRM: Excel documents which are generated by PHP package phpoffice/phpexcel can have malicious macro commands. Data for Excel documents, ...
2
votes
1answer
22 views

Sending an input file from Excel VBA to Raspberry Pi without change in content

I am sending a text file from my Excel to a Raspberry Pi, where the Pi will read that file and get the input inside. The input is just one line and it is a simple number and nothing else (40,38 etc.) ...
0
votes
1answer
19 views

Flash Fill in Excel result in columns - and not in rows

I want Flash Fill results in columns. Data is like this: Could VBA help here? The VBA could transpose the data in one row, Flash Fill that array, and then transpose it back in the next row.
1
vote
1answer
34 views

How to interact with Excel files using C# ASP.NET

I hope someone can point me in the right direction. I'm planning to build a web application using Webforms in ASP.NET. In the application, I'll be interacting with Excel files stored in a shared ...
0
votes
0answers
36 views

How can I remove the rows that matches from one Excel column with another Excel file? With VBA

Hi and thanks for your help. I've two Excel files, lets call them Excel 1 (active one), and Excel 2 (which I just need to compare if there's duplicates). I want to remove the matches from Excel 1 ...
0
votes
0answers
18 views

Excel VBA workBook property for last modified vs SaveDate

I am noticing users modify'ing excel workbooks. But the date for the SaveDate is not being updated. We would like to know when the last updated their workbooks. As far as I can tell the Workbook....
0
votes
0answers
19 views

Excel Or Macro Help - Data need to fetch from data sheet based on input

I need help on my excel work not sure I need to create macro or I can do it in excel trying in excel at first- Exple: I have list of names,adress,other details in one sheet I need to create a excel ...
1
vote
0answers
10 views

Excel shared file randomly locking specific cells

I have a shared file with 6 cells that are unprotected (D2:F3), with all other cells being locked under sheet protections. We have employees entering into these cells once a day, but occasionally we ...
-1
votes
0answers
23 views

Match a set of values in Excel from one column to their position in another column so that I can sum them?

I am trying to match a range of values in Excel to their specific position in another column so that I can sum that specific range of values however they are not consecutive. I.E.: The first set has ...
0
votes
0answers
16 views

VBA Stop Application.OnTime Method

I've encountered a slight issue while using the Application.OnTime method. As per the below example the code should run every 10 seconds (which it does) however it doesn't stop on button press. After ...
0
votes
0answers
11 views

Shade areas under the stacked area in Excel

I want to be able to shade certain areas of the graph, where the graph is based on this data enter link description here Specifically, I want to be able to point out some interesting periods for ...
0
votes
1answer
18 views

Using Match to return column number

Trying to use .Match to identify the column value which searching a row. Basically, I have 3 worksheets, each with different headings, and I am looking to identify which headings are the same from ...
-1
votes
1answer
24 views

Excel: How do I use one or another separate formulas in one cell, based on values in another?

How do I use one or another separate formulas in one cell, based on values in another? Link to image below will show the issue. Thanks Update to new Formula: =IF(OR(E292="",F292=""),"",IF(F292<=...
1
vote
0answers
21 views

When inserting a PDF Object into my Worksheet using VBA it displays no icon and im not able to save my WorkBook afterwards

I'm trying to insert objects in a new table row. It works for images, word documents and outlook email messages. But when I try to insert a PDF the object displays no icon and I get errors when I try ...
0
votes
2answers
20 views

Convert Date to UK for Excel

Please help, this has been driving me crazy for months. I am querying data from an MS SQL DB that is not very well constructed and has many challenges. One particular challenge that has so far got me ...
0
votes
1answer
39 views

Sort Values A to Z

Hi I have created a code which adds values to certain ranges. These ranges already have a formula which allows the range to become dynamic. What I am wanting to do is to sort just one of these named ...

1 2 3 4 5 … 3518