Formatting concatenated columns in Pandas/Python.

I am very new to Python/Pandas and am using the Spyder IDF, via the Anaconda distribution with Python 3.6 (maybe 3.7?).I am importing an Excel file via the code below and would like to know how to get an output that looks as follows: VOLTS/PHASE Cu...
more »

2017-10-04 17:10 (1) Answers

Copy value to next empty cell

I want to find empty cells and copy there values: Values: "10/11/2017" and "Yes" should be copied to row 7 (colB & colC). What I have: Sub add_value() Dim wbA As Workbook Dim wsA As Worksheet Set wbA = ActiveWorkbook Set wsA = wbA.Workshee...
more »

2017-10-04 11:10 (2) Answers

Error re-running code

firstly, I'm having error running the code from Excel workbook directly. It leads to the error message mentioned below We looked at all the data next to your selection and didn't see a pattern for filling in values for you. To use Flash Fill, ent...
more »

2017-10-04 11:10 (1) Answers

VBA SaveAs crashes

I have an xlsm file named Summary.xlsm. The Summary file gathers data from xlsx files in the same folder it's in. The folder the Summary file is in should only contain other Excel files named IEM_######.xlsx (IEM_ plus any six digit number), but some...
more »

2017-10-03 20:10 (1) Answers

VBA, Optimize VLookup/Formulas

I have a code, largely done from the macro recorder. Runs very slow. I think this is due to the vlookups or formula, can anyone help make this code faster? I also have filtering and copy and pasting, doubt these are slowing this down. Perhaps it is ...
more »

2017-10-03 17:10 (4) Answers

How to select cells NOT containing a certain word

I have an Excel table, in which some of the cells of the C column contain the word "Rinse" (the other cells have various other contents). Using VBA code, here's how I would select all rows containing the word "Rinse" in the C column - this code work...
more »

2017-10-03 14:10 (6) Answers

Setting the Row Height dynamically in VBA

I have a requirement, where I have to set the Row Height dynamically. For Example, the Input looks like - And I want my output to look like - The String in that line will keep changing. So, now based on what characters, I should set the row heigh...
more »

2017-10-03 13:10 (2) Answers

Excel-VBA Now Value: Split Second

Please can someone assist. I've searched for this, but have not found anything suitable. I have a VBA macro which, when a character is entered in one cell, it places the current computer time in the cell adjacent. I've designed a timing sheet for rac...
more »

2017-10-03 13:10 (1) Answers

Excel VBA Nearest Value in Array

I have the following data in a array Dim numbers () numbers = Array(1, 2083, 3050, 4030, 6000) I want to get the closest value from my array when i put a number in Range("A1") ...
more »

2017-10-03 10:10 (2) Answers

Excel - Looping issue

I have a sheet that looks like this: -------------------------------------------------- | cat | cat | cat | dog | bird | dog | dog | dog | -------------------------------------------------- | | | | | | | | | ---...
more »

2017-10-03 06:10 (2) Answers

Excel Date/Time Lookup Error

I have two columns of 15 minute date/time interval data. One is formatted in 24-hour time and the other 12-hour. These come from two different sources, and reformatting the source data is not an option. All of these intervals are showing as exact mat...
more »

2017-10-03 05:10 (2) Answers

Pass parameter from sheet in Powerquery headers

I am querying a REST API in Get & Transform (FKA PowerQuery) in Excel 2016, and I want to parse the API key from a sheet in Excel with parameters. If I hardcode the API key in the query as part of the headers, all works fine, but if I import it ...
more »

2017-10-02 22:10 (1) Answers

vlookup to leave cells empty if value is 0

I have written this code so far but is says that there is an application or object error.. .Formula = "=IF(VLOOKUP(A2&""B2"",MARM!A:G,7,0),"""")=0,"""",VLOOKUP(A2&""B2"",MARM!A:G,7,0),""""))" I have used this code so far successfully but ...
more »

2017-10-02 21:10 (0) Answers

Run-time Error '1004' while pasting

I've been looking around to find out why this is giving me a Run-time error '1004' You can't paste this here because the Copy area and paste area aren't the same size. Select just one cell in the paste area or an area that's the same size, and try pa...
more »

2017-10-02 19:10 (1) Answers

Search for single item if Multiple items per cell

I'm pretty new to vba, but I do have some working code right now. I execute this code and it clears out cells on one sheet, references an assembly number on that sheet, searches through another sheet for that assembly number, copies the data I want r...
more »

2017-10-02 17:10 (1) Answers

How to download images from URLs and rename them?

I am looking for a VBA code that can save images from Urls in "Column B" and name it with names from "Column A". I have tried different Vba codes found at StackOverflow and on other forums but none of them is worked for me yet. There are about 5K im...
more »

2017-10-02 15:10 (0) Answers