-1
votes
2answers
38 views

Use Excel VBA If value in column a is not in column b then add value to column c

Dim i As Variant 'For i = 1 To 5 For Each i In rngWatch Dim c As Variant c = rngWatch.Cells(i, 1).Value If i <> rngReconcile.Cells(i, 1).Value Then MsgBox i ...
-1
votes
1answer
24 views

Remove duplicate PERSONAL spreadsheet

I have apparently two PERSONAL workbooks on my computer. I understand that I need one to store custom macros that aren't part of add-ins or attached to specific workbooks. I only need one, but due ...
-4
votes
0answers
22 views

Excel copy paste if macro vba [on hold]

In excel, can you help me build a macro/vba for this task: Copy-paste $M$1:$N$1 to Column M:N, if Cell in column C="price". Thank you all!
0
votes
0answers
34 views

Excel VBA Script How to Open a File and Insert character into Cell

I'm hoping this is an easy one. I am importing a directory of CSV files with long numbers (16 digits plus 4 leading zeroes). I need Excel to preserve the number data instead of applying scientific ...
-6
votes
0answers
28 views

what sort of graphs would you use for age exception on internal breaks? ideas required [closed]

what sort of graphs would you use for age exception on internal system breaks? ideas required
-3
votes
0answers
18 views

how do you convert excel tabs in pdf [closed]

Hi is there a code to convert tabs in excel to pdf, in putting audit information together
1
vote
0answers
29 views

Reset Numbered List with Text Style VBA macro MS Word

I'm trying to make a VBA macro to create a Word document from Excel... Currently I'm having issues with setting up the Lists properly. I want the list indexes linked to my 2 header types. Like so: ...
0
votes
0answers
17 views

Find and replace multiple values within selected cells using another workbook

I was wondering whether anyone could point out what's wrong with the VBA code below. It's based on the following: Find and replace multiple values within selected cells I want it to take the find ...
1
vote
2answers
72 views

Hiding all but the selected rows of data

I am unable to send any pictures, The data contains 98 column headings, with the first column being unique identifiers, and 1000 rows of items. I receive commentary on specific items throughout the ...
1
vote
1answer
36 views

Changing a String Value to Date format in VBA

I am working on a VBA scripting in Excel. The following is the code that i am working on. Option Explicit Sub MoveThingsAbout() Worksheets("Sheet3").Cells.Clear ...
-1
votes
0answers
23 views

vba method cells of object _global failed

I have this vba code. In the conditional statement, if the met condition is in env2, the code works fine. however if the condition met is in env1, the code fail with the error run-time error 1004. Why ...
-3
votes
0answers
55 views

I want to compare two different columns and get a value from another workbook using VLOOKUP

I want a value from the workbook(2) by comparing two different columns from workbook(1) using VLOOKUP. I want a VLOOKUP coding like, if WorkBook(1)columns A matches with workbook(2) columns A then it ...
-2
votes
1answer
48 views

Excel, using cell text references as input for formula

First of all thanks for your help. I have a problem regarding the use of text into formulas. I am working on a huge dataset of stocks of several years. The stock are not correctly grouped. I used an ...
0
votes
0answers
19 views

How can I check that a filter applied to a listobject column with vba is legal?

Filtering a listobject(excel table) with a value that doesn't exit results all rows instead of none can I get no rows? can I get list of optional legal parameters? example listobject with col A ...
0
votes
0answers
27 views

Area Under Curves in Excel

Are there add-ins for Excel that allow the user to get the percentage of values that lie less than or equal to some value x? Basically I'm looking for an add-in that takes the continuous valued chart ...
0
votes
0answers
28 views

Consolidating data from multiple sheets into a single sheet based on specific criteria

I have over 300 excel sheets all having stock data over a year. This data is date wise. However I want to group this data based on stock name, i.e., if I have stock A in all my sheets, then all data ...
0
votes
0answers
64 views

vba excel macro runtime error 1004

Dim lastC As Long lastC = wb2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'highlighted in debug SourceRange.Copy wb2.Worksheets(2).Cells(1, lastC + 1).PasteSpecial Paste:=xlPasteValues, ...
0
votes
1answer
62 views

modify Excel macro to reference list of text rather than hard code

I’m trying to get some help with the last step of an Excel Macro I’ve been working on. I’ve set up a Macro that will take data from sheets from two different workbooks, and paste them into a third ...
1
vote
2answers
30 views

Code iterating slowly

I have a simple macro that gets creates 16 different versions of a template, updating by getting values from another open workbook. It is taking over a minute to iterate only 16 times and was ...
0
votes
1answer
62 views

VBA: How to replace entire Excel cell value basing on its content?

I have an Excel Spreadsheet with some names in a cells. There can be as one name per cell as multiple names in one cell. For example: Cell A5 contains "Joe", cell BD54 contains "Joe;Harry;Molly", ...
0
votes
0answers
21 views

Excel VBA macro - i need to insert column and add a default value to all the cells in that column

I have created a macro but i could not insert columns in it and i could not add values to that coulmn. I want to insert a column and the default value to that entire column should be CH. column ...
0
votes
1answer
50 views

Make formula impossible to find / read

I have developed a spreadsheet for performing various calculations which our employees will complete and then distribute to clients / competitors. To protect the "intellectual property" of the ...
0
votes
1answer
16 views

Formula to determine available options based on prerequisites

Example: A spreadsheet for a single studient has four columns: Course|Completed?|Prerequisites|Available The "Course" column lists the names of courses. The "Completed?" column indicates a "yes" if ...
0
votes
2answers
35 views

Specific Row Values in Excel

How can one ask Excel to record the value of all cells in a given column such that the row number is of the form row = 2^i for i in 1 to 100? Would this necessarily use VBA?
0
votes
3answers
75 views

EXCEL - How to have a formula output and user input on the same cell?

I would like help from someone as I believe this problem requires VB. I basically have a CELL(A4) where people will be entering values to find out the corresponding calculations displayed below. ...
-1
votes
0answers
8 views

Run-time error '13' : Type Mismatch [migrated]

While writing a Macro for Concrete Column, I have encountered a "Run-time error '13' : Type Mismatch" Error Here is the code. Option Explicit Sub Pu() Dim D, b, fck, fy, Es As Double Dim xi As ...
1
vote
1answer
174 views

Execute SQL Query with VBA and fill sheet with data

Very new to any form of code. Attempting to run a script in VBA that will pull data from an access database using SQL and put it into an excel spreadsheet. Code is similar to below. Runs clean but I ...
0
votes
1answer
9 views

Formula to incorporate Highlighted text & Loop function

I'm trying to analyze over a 1000 line items, with different information in all columns ,although certain columns might have duplicate information. I can do conditional formatting and highlight the ...
0
votes
1answer
47 views

Spreadsheet data checking columns

I am trying to separate datas from columns(A,B&C) based on datas from an index table at columns (E&F) I need to list only those data from columns A/B/C when column B data has no corresponding ...
-1
votes
1answer
50 views

Automation Error Catastrophic Failure

I am trying to use excel VBA to copy some charts to Powerpoint slides using the below codes, but it shows error "Automation Error Catastrophic Failure". I can not figure out what is the problem. I am ...
1
vote
1answer
36 views

Excel automaticly adding an extra row which already contain formulas for the inputed number of years

I am looking to build a model, I would like is have an input page where you input the range of years you would like to cover. Depending on the inputted number of years, I want a table (on a different ...
0
votes
1answer
53 views

How to automatically replace Excel formula with value when date/time condition is met

I need to record results of a constantly changing cell based on external criteria. Cell B3's value is changing, and I need to record the value of B3 at specific points in time. Cell D2 contains the ...
0
votes
1answer
24 views

Excel: Referencing a named range inside a formula

I have two tables, the first table has 6 column and each column has a defined range name as follows: Col 1: Broker_Name Col 2: Broker_Market Col 3: Client_ID Col 4: Client_Location Col 5: ...
0
votes
1answer
30 views

Excel - import data from cell automatically when a new tab is created

I am working on a spreadsheet summarizing data from standard templates inserted in a joint Excel file as separate tabs. Is it possible to automatically import data from a specified cell into a ...
2
votes
2answers
27 views

I would like to copy data from 1 row to another in Excel

I am trying to solve the following issue in excel: I am working in two sheets, Sheet 1 and Sheet 2. There is a column of data in sheet 1 (say from A5 to A20). I need every row from that column to be ...
1
vote
4answers
124 views

Excel VBA - adding an element to the end of an array

Simpel Question I like to add a value to the end of an array and increase it automatically? I was not able to find such a simple example Public Function toArray(range As range) Dim arr() As Variant ...
0
votes
1answer
30 views

Timestamp in Excel…not working?

I know this question has been asked numerous times, and I have truly searched and attempted to work it out with the given solutions to no avail. Maybe I'm doing something wrong, but I don't know much ...
0
votes
0answers
45 views

comparing two columns for matches then return values meeting certain conditions

I have the following: column D ( 300 values representing the average of three cells, A1:A300 & B1:B300 & C1:C300) column H ( 50 values ) column E & column F & Column G; they are to ...
0
votes
1answer
160 views

How to bypass the VBA project password from Excel

I need help with password retrieval or bypassing the password on a project that was done at work. The author has used MS Excel to do the project, and it's in the client's server. The server that we ...
-2
votes
1answer
33 views

VBA dates filter [closed]

easiest way to explain this is to use a example. I have two dates(f.e.) "2014-08-08T8:11:31" and "2014-08-11T13:53:29". I need to gave them proper form(date),exclude weekend(Saturday, Sunday ) and ...
0
votes
3answers
452 views

Run excel macros (vba) from vbscript file

I have a vbs file that pulls information from my database and exports the data to an Excel file (C:\file.csv). Once this is done, I run a series of macros (vba) to format this data. These macros are ...
0
votes
1answer
16 views

extracting labels of data in a pivot table

When I move the mouse pointer over data in a pivot table it displays what are the row and column labels (names of pivot items). How can I extract them so I can later use them in a code (when I want ...
1
vote
2answers
55 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
48 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
27 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
2answers
151 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
32 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
259 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
38 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
53 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 ...