Questions tagged as 'excel'

Tagged questions
1
answer

How to change data from a chart dynamically (OFFSET + RANGE NAME)?

I'm trying to create a dynamic chart where a combo changes the chart type. In fact I created a name where I added a formula that not only changes the height of the range but also changes the columns. Explaining the process: In the chart da...
asked by 14.01.2015 / 17:02
2
answers

Create Excel file with C # [closed]

I have a problem: I have to generate a class in C # to create an Excel file, but I'm not getting it. Can anyone help me? The idea is to generate an Excel file with a menu and a line with values.     
asked by 02.03.2017 / 19:58
0
answers

Save data to excel file through Outlook

I've created a Rule , which every time an email arrives with a certain text in subject runs a scrip and store certain data in an Excel sheet. Code: Option Explicit Sub CopyToExcelMacro() Dim olItem As Outlook.MailItem Dim xlApp...
asked by 14.11.2014 / 11:23
2
answers

RANGE class SELECT method failed

The intention is that when you click on the Euro Synths tab, the macro impute the "L" character in cell D1 of the Local Synthesis tab and then return to the Euro Overview tab. I was able to solve the error problem by allocating the macro in the...
asked by 24.07.2018 / 15:55
3
answers

Remove the last name from a cell

I have a table with the full name of users and I needed the ninth column to put the last name, does anyone help me with the formula?    A2 = Ricardo Simoes       B2 = Simoes I have tried this way but it gives me error =EXT.TEXTO(A2;LOC...
asked by 01.04.2015 / 13:37
3
answers

Date format incompatible when importing data from Excel to MySQL (00-00-0000 VS 0000-00-00)

I'm trying to import data from an Excel spreadsheet to MySQL, the problem is that I have a column in Excel that the dates are in dd-mm-yyyy format and the format accepted by MySQL is yyyy-mm-dd . I want to know how to convert the da...
asked by 14.03.2014 / 21:00
2
answers

How to extract only the penultimate character of a string and then use auto-fill in Excel

I have a numeric sequence separated by spaces, I just want to extract the numbers in red, but when using auto-fill (click and drag with the cursor down) does not work! how do I extract just the red numbers from all cells? and use autofill withou...
asked by 19.10.2018 / 15:42
2
answers

Excel - How to concatenate cell range?

How do I concatenate a range of cells in Excel? For example: I have a column with many cells containing text information and would like to concatenate them, but when using the concatenate function error occurs, being necessary to select one b...
asked by 29.06.2018 / 17:30
1
answer

Difference between dates with condition (only count certain month)

Is it possible to calculate the number of days between two dates of only one month? For example 28/5/2018 to 2/6/2018 and I only want the number of days in May (result = 4)     
asked by 02.06.2018 / 10:39
2
answers

Convert HTML5 table + images to CSV or SQL

I have a big problem! I have basically 1 million and a half records including images in an HTML5 table (it starts right there, the browser does not render all the images). My idea was to convert this table to CSV, and thus play to a MySQL...
asked by 19.10.2017 / 07:34