Now I am using this code for running a Excel Chart Template on bar charts: Apply Saved Chart Template ActiveChart.ApplyChartTemplate ( _ "C:\Users\Bosco\AppData\Roaming\Microsoft\Templates\Charts\Bar Chart.crtx" _ ) Since this link will be decid
I have a question, is there are any way to make numbering format in excel ( 1; 1.1; 1.2.... )with formula? I need to hide second row, numbering should be dynamic and still show (1; 1.1; 1.2...) not (1; 1.2)... and i need to lock first (1) number by s
I'm quite a newbie at Excel VBA (but I'm doing my best!) to try and solve this problem I have for my Excel spreadsheet work. I've trawled other questions but haven't found a solution I understand yet. I'm trying to write a Macro that can insert a Tab
I have successfully written a VBA script for Excel which checks if column A contains a specific entry (in this case: 2016) and then copies the entire row into a new worksheet. The only problem is that it is copying the rows into the exact same positi
Hi I am reusing the code which was shared in another active question posted as below - Import Multiple text files into workbook where worksheet name matches text file name This code is working perfectly for me creating and multiple worksheets and imp
I've never used VB(A) before, so forgive me if this is a trivial question. I am trying to run the code outlined here on Excel 2016 on a Mac. Sub simpleXlsMerger() Dim bookList As Workbook Dim mergeObj As Object, dirObj As Object, filesObj As Object,
I was trying to add an automatic macro to my very large workbook to at least trim some fat off by resetting the used range. I've tried numerous codes and cannot get it to work and can't figure out why. (It seemed to work a few time when I would manua
I have a spreadsheet with recipients name in column A, recipients email in column B and mulitple others columns with the information to be emailed to these recipients. Each recipient has multiple rows, and the number of rows per recipient varies each
I have a series of subroutines (Sub1, Sub2, Sub3, etc). I want to call a subset of these subroutines based on user defined values. For example, subs 7 through 13. I thought of using a loop based on the number in the name of subroutine, but it does no
I am trying to piece together code to make my macro work correctly. This approach has served me well in the past but I cannot seem to adapt any code correctly. I found the following Sub way() Dim Cell As Range For Each Cell In Range("A1").Curren
As I am pretty inexperienced with Excel, I am struggling with the following situation. In a sheet I have the following columns Account Investment 1 a 2 b 3 c 1 d 2 e 1 a My desired output, in a different sheet, should be something like this AccountAc
I want to separate out the octets of an IP address using Formulas. I have tried some things like substitute & find but cannot figure this out. Example of what I want to achieve, by only starting with Cell A1 and Cell B1: 10.17.9.192 | 192.168.0.1 10
I have a looping INDEX-MATCH VBA that I am trying to debug, as it is constantly throwing a Sub or Function not defined error. With what I have already found on this site, I was able to check my references, but I still seem to be missing something ("S
I'm trying to generate a function with VBA that automatically adds Values from one cell of a defined range of an Excel Sheet to the cell on it's right, so that for example when you put a number in A1 that number will automatically be added to the val
I have a cell with the following content : 01/02/2015 The cell is date formated Then I copy the value and put it in my module class : Set Line = New CTravelLine Line.Date= Cells(1, 8).value Everything works fine until the moment I put this value in a
As far as I understand it they do the same thing, but while Worksheet_SelectionChange is triggered every time selection is changed on a single worksheet, Workbook_SheetSelectionChange is triggered every time selection is changed in any worksheet in t
How to get next year period based on current month and year, for example: Jan 2014 - Dec 2014 Feb 2014 - Jan 2015 Mar 2014 - Feb 2015 Apr 2014 - Mar 2015 May 2014 - Apr 2015 Jun 2014 - May 2015 Jul 2014 - Jun 2015 Aug 2014 - Jul 2015 Sep 2014 - Aug 2
I'm looking for a way to concatenate two time period values in one Excel 2010 cell. This is a Excel sheet for my office, in which my working hours should be listed. Beside other values, which are not relevant for this, there are four columns: Column
I have the following text: This is user message Message one Message two Message three where I want to replace all the bullets with numbers: This is user message Message one Message two Message three This text in available in only one cell of Excel fi
I have this excel sheet picturee below. I'm trying to get the sums of the weeks in the column of the month using a sumif or sumifs but keep returning 0. Here is the forumala I've used. Any ideas? Thanks =SUMIF(B6:B50,">=1/1/2013 && <=1/
I've been trying to find the right solution to this and greatly appreciate anyone's help. I've created a google form called "Career Progress Report Form" which stores the type of activity you've done on the day. I've created this to keep track o
I am working on a project in Excel where I want to validate a data set, whenever two cells in a column have a duplicate I want to write the location of the duplicate to a different worksheet that contains a bunch of information regarding errors in th
I've been sent a excel spreadsheet to replicate in SSRS and the calculations used are set out differently to anything I have ever seen. for example =+E2/E3 = 100 This gives the same result as =E2/E3, so to me the + does noting? Just want to understan
I am developing an app using Mono for Android. I need capabilities to read and create XLSX (Excel) files. I have tried with EPPlus and NPOI, and had a quick look at Microsoft's Open XML SDK and found the following problems: EPPlus requires the Window
In a specific column, I want to search for a specific character in cells...say "(" or "/". Once this character is found in a cell, I want to extract the part from the beginning of the string upto the point that this character is found,
I have an Excel sheet with I have around 25k rows of data in the following format: Column1 | Column 2 A | value1 A | value2 A | value3 B | value1 B | value2 C | value1 C | value2 and so on. I would like to rename the duplicate rows and put an integer
How can I extract keywords from Tridion into an Excel format? This is for the purpose of translation of the website.If you're using Tridion 2009: http://sdltridionworld.com/community/extension_overview/exporttoexcel.aspx If you're not, you'll have to
I would like to divide a worksheet into multiple files. I have a worksheet with about 10,000 rows. there is fancy formatting, conditional formatting, nice colors, and I want to preserve all of these attributes. I need to divide this worksheet up. the
I'm using xlwt to generate an Excel file which I'm returning as an attachment in the HttpResponse in a Django view. from django.http import HttpResponse def my_view(request): ... workbook = xlwt.Workbook(encoding='utf-8') #write my workbook data here
So, I have the same symptoms as described in C#/ASP.NET Oledb - MS Excel read "Unspecified error", but my my answer did not seem to fix it. Even always closing the OleDBConnection and disposing of it show the same symptoms. var connectionString
