I have some code that does the job, but takes over twenty minutes to run. The code works on 10,000 lines of data on an excel tab and cleans it up (deleting some columns and also all teh blank rows etc and then moving it to a new tab), I do have application.screenupdating set to false and I have...
I have my data laid out like this
A B C D......
Administrative 100 Group Meetings 200 ....
Bereavement 105 Group Meetings 5.....
Group Meetings 105 Administrative 200.....
I need to use sumproduct to add the values in col B,D,F,H & J like below.
Please...
I have several workbooks that are formatted the same, but have different data. I have a userform that shows up for two seconds when the workbooks are closed. I am now changing the workbooks using only code and want to save and close them, but that triggers the showing of the user form. Since I...
I often have to create ranks in Excel and it's time consuming when there are multiple rows of ranks based on Regional performance versus Divisional performance. I was wondering whether anyone has some code that they could share that would help in this process. I am thinking that if the code will...
I have a VBA routine that lets user select a column
Sub getcolumns()
Dim userRange As RANGE, output As String
'get a range from the user via an input box
On Error Resume Next
Set userRange = Application.InputBox( _
prompt:="Select cells on a single column for processing", _...
I have a macro that works well in merging data from similarly formatted files (each with different data) in a folder. It extracts data from a certain sheet from each file and then merges them into one excel worksheet. I need a change made to this macro and not sure how to do this.
Currently the...
I have a list with 10 values in a cell, let's say cell A2, and another list with 8 values in the next cell B2, is it possible to have a third list in the adjoining cell C2 that will only have a list if specific values from list a and list b are chosen and no list if those specific values are not...
I have cells in a column that has data validation and point to a list with two values "HERE" and "GONE". I want this list to only appear for the user if the criteria in two other cells equal certain values. I tried this =IF(AND(C2="IN",D2="OUT"),STATUS,"") in the
cell's data validation under the...
I have code that pulls all the attachments from a subfolder in my Outlook inbox and saves it to my hard drive, works great, but only seems to pull the oldest file in cases where there are duplicate file sent by the same person. Does anyone know using the following macro how to pull just the...
I have four option button on a form and when checked they have a value of "TRUE" and "FALSE" when they don't. I need the TRUE and FALSE value to convert to LOYAL and NOTLOYAL. The code I wrote is not working, any suggestions will be highly appreciated.
If OptPreLoyal.Value = True And...
I urgently need to create the following:
Excel workbook with two tabs, the 1st tab will only show a form for input with the following inputs:
1. Program Type (pick from list)
2. Product(pick from list)
3. Date
4. Estimated cost ($ format with 2 decimals)
5. Actual cost ($ format with 2 decimals)...
I urgently need to create the following:
Excel workbook with two tabs, the 1st tab will only show a form for input with the following inputs:
1. Program Type (pick from list)
2. Product(pick from list)
3. Date
4. Estimated cost ($ format with 2 decimals)
5. Actual cost ($ format with 2 decimals)...
I need to distribute 350 different files to 350 email addresses in my company, is there an excel macro that can handle this?
I can create an excel file that would have the email address of the person and the name of the file they would receive in two columns, can that be used to feed the macro...
I have a list box with five unique items, currently I have them in one list and there is another list box with about 20000 percentages that I am using.
What I need to do is for each of the five items on the 1st list, have the second list box dynamically list anywhere from 1 to 20000...
I need to lock certain cells but also have the ability to have the user hide or display the rows with the locked cells. Is that possible with VBA using a macro button?
Michael
I have a worksheet that has several drop down boxes, the user gets to choose a single value from each list and then a calculation is done in excel on a cell which displays the value of the combination of the users choices.
I need a method to move that value to a different cell in the same...
I have a query that I am going to give to an user who is not that technically inclined. He will be using Queryman. The query retrieves some values from Teradata, but the end report the user wants needs to have subtotals and grand total for the first field in the query, there are sixteen unique...
I have a excel worksheet that I receive frequently, it has the following columns of data
CLIENT_NAME $10,
SEGMENT $54,
ANALYSIS_YEAR $4,
STRUCTURE_CODE $8,
INCLUDE $7,
OPERATIONAL_ID $15,
ANALYST $25
The data is all characters noted by the "$" and the number following is the number of...
I have a data set which could have invalid characters
I need to take every obs which has a invalid character like &! etc and put the whole obs in data set and the rest in another.
Here is what I have so far
proc sql ;
create table structures2 as
select...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.