Tagged Questions
0
votes
0answers
14 views
EXCEL : Index Match to Return Multiple Values
I've successfuly used INDEX and MATCH, but I have a problem.
For example, the data is
green apple | walmart | 5
green apple | walmart | 23
red apple | walmart | 5
orange | macy's | 4
I ...
0
votes
1answer
15 views
Macros for Excel
I am building a Macro to copy selected rows from a sheet to a selected sheet. For example I want to copy row 3,5,6,7 to Sheet 3. I have thought of using check boxes to select rows and radio buttons to ...
0
votes
0answers
30 views
Macro works first time, then fails on second run when converting formulas to values
I've been running into a pretty frustrating problem with this macro as of late. I'll run the macro, it'll work exactly as expected, but when I reset it (set up button deleting and clearing sheets) and ...
0
votes
1answer
19 views
Copying excel Data to new worksheet Error 1004
I am trying to copy certain information from cells into another spread sheet. I have a For loop which loops through the rows. The program bugs out when I try to copy the cells into the new spread ...
0
votes
1answer
17 views
after running macro return to same cell in all windows
I have an Excel file where I usually have multiple windows open. Typically in one window I have sheet1 active, in the second window I have sheet2 active etc. I have written a macro where in several ...
0
votes
1answer
23 views
What exactly is the function of Application.CutCopyMode property in Excel
Well first of all I found couple of answers while googling but most of the forums are blocked in my Office Network hence asking this question here! One more intention is to get an answer in plain ...
0
votes
1answer
22 views
Excel macro that prints individual array values to cells
I've searched for an answer to do this but haven't found a similar situation. I have a set of data that I want to put in array then have it print to another set of cells.
Ex. Company A, Dept A, ...
0
votes
1answer
18 views
Matching number of rows in one excel table with the number of rows in another
In Excel I am using some columns for calculations that will use information from some other columns who's information is copied from another file. This external data can have a varying number of rows, ...
1
vote
2answers
27 views
How to use text file to load file paths to excel macro
Ok, I have a macro in excel which is working perfectly.
Sub FindOpenFiles()
Dim FSO As Scripting.FileSystemObject, folder As Scripting.folder, file As Scripting.file, wb As Workbook, sh As Worksheet
...
0
votes
0answers
24 views
Import multiple text files simultaneously while adding date column in reference to file name
I have over 300 text files that I need to import into a single excel worksheet. The files are "|" delimited. The files are named in the "xxxx_07_11_2013" format. The text files itself has the date ...
1
vote
2answers
16 views
Removing Zeros in excel using macros
I got some code from another post that helped me format code that enables me to remove zeros in a given column, its content and comments. However the code is also deleting the first cell (which is not ...
0
votes
0answers
20 views
Two errors on an excel macro
i'm having troubles with this macro for excel. It collects info from a weekly report.
Rows count turns 2198 when it should be 2 (the first time i run it), and shows run time error when trying to ...
0
votes
3answers
16 views
Error 13 Mismatch - For Loop Cell Value
Sub Button53_Click()
Dim rowsvalue As Integer
Dim rowsnum As Integer
rowsvalue = Sheet1.Range("C38").Value
rowsnum = Math.Round(rowsvalue / 20, 1)
k = 0
For Counter = 16 To 46
...
0
votes
1answer
29 views
excel - Loop through worksheet
I have never used Marcos in Excel before only in Access. What I want to do is loop through the worksheet and where column X and Y are not null extract the information into a new worksheet. But row Y ...
0
votes
0answers
24 views
create a chart for variable data range using VBA
I'm curently working in a workbook where data from other sheets are copied onto, after having recieved all the data (wich are of variable legth) the macro adds a Time column, previously left blank, ...
