0
votes
1answer
11 views

Changing DateTime format in multiple CSV files

I've got multiple csv files with this structure: text, text, 01/27/2001 01:00:00 PM I need to update ALL csv files with this datetime format: text, text, 27-Jan-2001 13:00:00 Is there a known ...
0
votes
1answer
25 views

Excel - How can I collapse data, eliminating blank rows?

I have a 3 column, 20 row table. (A1:C20) The 3 columns are each 1 digit of a 3 digit number. Some of the rows have 3 digits, some are blank. I need a way to return all the non-blank rows of 3 ...
0
votes
0answers
21 views

Keep header text in Excel, but change font

I've seen several examples for changing the header font in Excel; however none of them just change the font. They seem to always incorporate static text or a cell reference. How do I change just the ...
0
votes
0answers
22 views

excel - ask for input to be used as new cell values

I use excel 2007 and I want to create the following function: At first I need to add a vba function button that prompts the user to add four different values, e.g. a name, a number, a date and an ...
0
votes
2answers
29 views

How can I trigger an Excel macro by hovering a mouse over a cell?

I have not been able to figure out how to run an Excel macro by moving my mouse over one or more cells in my spreadsheet.
0
votes
1answer
22 views

How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2 And i have macro called "AAA" in instance 1 and "ASD" in instance 2 i want to call "ASD" in instance 2 ...
0
votes
3answers
79 views

Excel formula to compare single value in one cell with multiple values in other cell

I have a value in Column A, which I want to compare with multiple values in column B, and depending on that value, put the answer in column C. For example, using the table below, it searching in ...
0
votes
1answer
23 views

Excel macro to save workbook on another session of excel

Im trying to make a macro in one session of excel that saves a particular workbook in another session of excel. Lets say i have Workbook1 and Workbook2 and i have opened them in different excel ...
1
vote
1answer
23 views

VBA + Polymorphism: Override worksheet functions from 3rd party

my company makes extensive use of a data provider using a (closed source) VBA plugin. In principal, every query follows follows a certain structure: Fill one cell with a formula, where arguments to ...
0
votes
1answer
29 views

Excel VBA Insert Character Between Number and Letter

I would like some VBA code that would allow me to detect if a string contains any instances of a number followed by a letter and then insert a new character between them. For example: User enters the ...
3
votes
2answers
72 views

Creating folders and sub-folders with a VBA macro

I'm looking to use a spreadsheet I've created to generate folders and sub-folders based on what is in each column. The first column is the top level, the second column the next level down ...
1
vote
0answers
19 views

run-time error 1004 Application Defined or object-define error

I have this macro that I wrote: Dim lastColumn As Long lastColumns = wkbWorkbook2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'this is the highlighted part in debug SourceRange.Copy ...
0
votes
1answer
20 views

Get data from another Excel file

I have an Excel spreadsheet that contains a list of usernames Each user will have the following code. I just need to find a way to substitute First.Last with the names in the Excel spreadsheet. There ...
-1
votes
1answer
25 views

Excel: Averaging Sensor Data by Time Stamp

I have a device that collects temperature measurements from several sensors at discreet time intervals. This data is dumped into a .csv file with each row formatted as: [time] [sensor name] ...
0
votes
0answers
16 views

Opening Numerous Closed Workbooks into One Workbook with multiple tabs/worksheets for each closed worksheet

I have a folder with 20 worksheets each worksheet conatins a scorecards which is (protected/ no password) and not in your typical table format. I want to have a macro to open all 20 of these ...
0
votes
1answer
32 views

Insert new rows and autofill with formula

I am trying to insert new rows if a particular condition is met. I want to drag the formula from the last row to the inserted row, but I am getting an error doing so. Below is my code: For i = 1 ...
-2
votes
1answer
32 views

sum the values in a column and add the sum to the filename of a workbook

Hello I have been able to create new worksheets based on unique values in a column. In addition to this, i want to sum up the values in a column and include this sum in the filename of each ...
0
votes
1answer
24 views

Get result of formula as text

I have an Excel doc which populates a matrix using formula, for example; | A | B | C 1|=1+2 |=2+2 | 2| | |=4-1 would display as; | A | B | C 1|3 |4 | 2| ...
1
vote
1answer
28 views

Excel: create folder VBA script - get value from selected cell?

I am using a VBA code to create a new folder in a directory. What I want to do is get the new folder name from the selected cell. Any ideas how I can do this please? Here is the code I have so far. ...
0
votes
1answer
49 views

Merging multiple excel files in to one file

This is my macro for merging all the files in one directory to one excel sheet. I am unable to find why its not working as per expectation. I have thousand rows in each file. It copies 1000 rows from ...
0
votes
0answers
7 views

Linking a cell to a specific part of an ActiveX textbox

Is there a way in Excel to have a cell refer to a specific part of an ActiveX textbox? I have a large list of references in one ActiveX text box, and in another sheet I need to input various ...
1
vote
1answer
41 views

Working with cell addresses in excel with VBA

I have a Excel sheet in which are multiple forms. The forms look all the same and they have exact the same cells between them. They are ordered in 4 x 3: x x x x x x x x x x x x x x x x .... There ...
1
vote
1answer
29 views

Automatically “comment out” formula in Excel?

So I have this result set in MS SQL Management Studio. And I have an Excel sheet. I copy and paste data from MSSMS to Excel. As far as good. Now, some of the fields start with an equals sign. Excel ...
0
votes
2answers
43 views

How to repeat "copy range (A1:A5) to Range B with transform (column to row)?

I have a data in the Range A 1 a1 2 a2 3 a3 4 a4 5 a5 6 b1 7 b2 8 b3 9 b4 10 b5 and I copied A1 to A5 to Range B10, B1 to B5 to Range B11, C1 to C5 to Range B12 and so on with transform (from ...
-2
votes
0answers
18 views

Adding button to Excel VB

I need help with the Excel spreadsheet. When I click "Add Commodity" on the left hand-side I want it to show exactly those activities described on the sheet:
-1
votes
1answer
26 views

Execute an Excel 2010 Add-In

An excel add-in seems to be the easiest way to share a macro I created with my team. I saved the workbook as a .xlam file and installed the add-in so it shows up under the addins button with a ...
0
votes
1answer
64 views

move worksheet to another workbook, without the vba code but keeping the colour scheme

I current have some code that first copy a worksheet do some cleaning and then move it to another workbook. My problem is that when i copy or move a sheet it also copies the vba code that is attached ...
0
votes
0answers
65 views

Could not load an object as it is not available on this machine - Excel 2010

Got an issue that is driving me mad. Every time a user accesses this file, he always gets the error messages: "Could not load an object as it is not available on this machine" & "Compile error in ...
-1
votes
1answer
34 views

VBA AutoFilter gives runtime error 1004

Could anybody help me find what's wrong in the autofilter line below? It gives run time error '1004'. Sub filter() Dim rng_source As Range Set rng_source = ...
3
votes
3answers
53 views

Custom Sort using Excel without Custom List

I want to be able to sort excel rows where data looks like Column - 1 Other Columns 701-GBL-1843-MLMK blah 566-JJB-2785-MYJW 254-WYD-3220-NAND 884-GLE-2843-FRYA And I want ...
0
votes
2answers
24 views

Expand Excel ComboBox on click

How can I set up my combo boxes on the form i am building to open automatically when clicked on the field portion not just the arrow? I have been searching for a while and I can't seem to find any ...
-1
votes
1answer
176 views

How to write Excel macro to copy selected row of data between two sheets?

I'm not really experienced in the whole VBA area, i get how macros work but this is just out of my reach. Basically as i stated in the title i need to write a macro that will copy the selected row or ...
0
votes
1answer
36 views

Automating building a table from web sources in MS Excel 2013

I want to build a table indicating a number of things available in a given market. To do this I access the sites with relevant information and copy numbers to a table each day. I would love to ...
0
votes
1answer
22 views

Apply a formula to an entire column since the number of rows is changing from a source file?

I have a connection to a text file source so the excel worksheet updates automatically. Therefore the number of rows is always growing every time it updates. How can I apply a formula to an entire ...
0
votes
2answers
25 views

Error when value not present

I am using the code below several times over in one sub for different values not just "CPNEC". It works fine where there is a range with that value on the spreadsheet but falls over it the value does ...
-1
votes
2answers
82 views

how to create excel charts having strings in both x and y axis

I have a student data with Student Name and their grade (A/B/C/D/E.). Now I want to have a graph for this data. Kindly help me.
0
votes
2answers
40 views

How to shift unique values down a column to the same value in another column?

My friend has two columns where one has unique values and another column has those same values but also duplicated like shown below Column 1 Column 2 ABC123 ABC123 CDE456 ABC123 EFG789 ...
0
votes
0answers
25 views

Excel 2D-lookup on a PivotTable with changing coloumns and rows

I want to do a Vlookup on a 2D pivot table but neither the coloumns and rows of the pivot are fixed and are subject to change due to ever changing data source. How can I perform a accurate vlookup on ...
0
votes
0answers
25 views

VBA Compare columns on two diff worksheets, find in 2nd and group on 2nd worksheet

Excel 2010 Hi. I have a 6,000 line spreadsheet and need to group the lines, based on identified roll up points in another spreadsheet (150 roll up points). I want to be able to see the summary ...
1
vote
2answers
30 views

String Manupulation in VBA

I have single column that needs to be split to multiple, like Text-to-columns in excel. However there is a small challenge. Conventional delimiter will not work. Consider the string below Original: ...
0
votes
1answer
45 views

How to make a named cell read-only

I would like to make a cell "Cell Name" read-only. I found this code here but don't know how to use the String value instead of the range: Private Sub Worksheet_SelectionChange(ByVal Target As ...
0
votes
0answers
38 views

Runtime error 9:Subscript Out of Range near end of code at “Worksheets(”UserForm“).Select”

The following code is for a userform, the user having three options, one being less than 70,000 square feet, one being between 70,000 and 150,000 square feet and one greater than 150,000 square feet. ...
0
votes
2answers
53 views

Combine Multiple Values into Rows with Blanks

So I researched this for awhile, but I seem to be hitting a wall. I will admit- I successfully did this once, made a tutorial for my coworkers- then I nor anyone else was able to replicate the ...
2
votes
1answer
44 views

VBA selecting range in Excel

I can set the range for all of a column such as : ActiveSheet.Range("A:A") But I'd like to set something such as ActiveSheet.Range("A10:A") but there doesn't seem to be an easy way to do this ...
-1
votes
1answer
19 views

Deleting range of cells based on criterea

I have an Excel file with several macros, used for data processing. The masterfile reads one or more .csv files and copies all data it needs into a tab (lets call it sheet1) within the masterfile. ...
0
votes
1answer
26 views

Error outputting a string to cell

I am using a vba macro to automate part of an excel spreadsheet. The following line keeps giving me a runtime error 1004# application or object defined error Sheets("Material").Last.Offset(0, ...
0
votes
2answers
46 views

VBA Excel: How to assign .txt file content to a string type variable?

I made a little sub in excel that sends an email according to the parameters you enter: Sub Mail_LSP(mailsubject As String, consignee As String, coalcopy As String, mailbody As String) Dim mlook As ...
0
votes
1answer
25 views

Deleting rows that contain a keyword in the column

I have an excel file that has a id as one of the columns, each id has multiple entries and follow a set of survey questions. I need to delete all of the rows that have that keyword (which is in a ...
0
votes
2answers
70 views

Adding together values from multiple spreadsheets (VBA)

In my Excel workbook, I have three separate spreadsheets. The spreadsheets are identical in format and represent count values for different categories (passenger cars, trucks, etc.). I need to combine ...
0
votes
1answer
36 views

Excel: portable formula to reference data on previous (relative) worksheet

I need to create a fairly simple Excel spreadsheet (workbook). I need 12 sheets (tabs), one for each month. Each sheet references cells in the previous sheet. For example, the "May" sheet is ...