VBA How To Merge Two Macros

Aug 31, 2009

I have two macros and I would like to assign them both to one button. How to make a connection between these two codes in VBA?
the macro should first sort the columns: A and B and then compare them. Here are two codes that need to be connected:

Sub Sort()
Columns("A:A").Select
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Columns("B:B").Select
Selection.Sort Key1:=Range("B1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Range("C1").Select
End Sub.................................

When I paste the second code below the "Sort" code, the whole code doesn't work like it should.

ADVERTISEMENT

Merge VBA Macros For Progress Bar?

Nov 14, 2012

I have 2 macros ready and i need to merge it to one to make it run.

First macros will do the calculation and the other is adopted from a website as an sample to display % of process. Now the issue is i don't know how to merge it. Can any one help me to setup this file please. Copy of sample file is attached for your reference.

Calculation Macros:

VB:
Sub Premium()
Dim ws As Worksheet, ws1 As Worksheet, ws2 As Worksheet
Dim cel As Range, cel2 As Range, cel3 As Range, cel4 As Range, found As Range, rng As Range, age As Variant

[Code]....

View 2 Replies View Related

Merge Rows Using Macros?

May 21, 2014

In Sheet1 --> Emp id, Emp Name and Emp dob having some 'p' rows
In Sheet2 --> Emp id, Emp address, Emp Designation and Emp blood group of some 'q' rows

Now, i want in Sheet3 --> Combination of both Sheet1 and Sheet2 data. Note: Emp id in Sheet1 and Sheet2 are same which indicates an unique identifier. I attached a file for your reference..

View 14 Replies View Related

Macros: Merge Into One Template

May 4, 2009

The company I work for have several templates in the map xlstart.
They want that all the macros that are present in these templates can be merged into one template.
Is it possible to do that without using VBA?

Because they want a solution that everyone can use without knowing a thing about VBA.

View 9 Replies View Related

Merge / Run Multiple Macros / VBA Code

Jul 31, 2014

I have 3 different sets of macros and i want to Join them together so i only have to run 1 macro to do all 3. I am not sure how the best way is to do this.

Code 1:

Code:
Public Function UserName()
UserName = Environ$("UserName")
End Function
Private Sub RefreshTeamQueryOnWorksheet(worksheetName As String)

[code]....

View 2 Replies View Related

Merge Workbooks Into One Workbook Without Losing Macros And VBA Codes

Aug 3, 2012

I have 4 different workbooks that I want to merge into one workbook. I tried moving the sheets from these workbooks into one workbook but to my surprise all the vba / macros didn't transfer over to the other workbook.

I searched here but all I can find were people that wanted to make a summary workbook or merge workbooks into a worksheet which isn't what i want to do.

I just want to simply merge these workbooks into one workbook without losing all the marco and vba stuff that are in each workbook.

View 2 Replies View Related

Macros To Clean, Summarize, And Merge Reaction Time Data Files

Jan 6, 2009

I need to use to prepare for analysis a large set of individual participants' Excel data files collected using a psychological reaction-time experiment (a modified Stroop task). This experiment was created using a program called Superlab by Cedrus, so I posted an inquiry at the Superlab forum [url]. Their tech support suggested I might need to use macros in Excel but couldn't offer further assistance. I'll try to briefly describe (a) our Stroop task, (b) the operations I'm trying to carry out, and (c) the format of the individual Excel files,

Our Stroop task: The participant gets some instructions and practice trials, then a series of stimulus words are presented one word at a time in the center of a computer monitor in one of several colors. Word presentation order is randomized for each participant. The participant must press a key corresponding to the color of each word as quickly as possible. For each keypress (including the spacebar, pressed on instructions screens), the reaction time (in msec) is recorded in their Excel spreadsheet under the 'Reaction Time' variable. The 'Error Code' variable indicates whether the participant pressed the correct (C) or incorrect (E) color key in each trial. There are 8 types of words for a total of 48 trials. (Actually, 4 sets of emotion words and 4 sets of control-animal words, each set composed of 6 words each. The task basically measures how much peoplesí attention is captured by emotionally relevant cues in the environment.)

For each participant's data, I need an efficient way (macros?) to:
(1) clean it [i.e. discard or ignore the instruction & practice trials as well as trials where the participant was too impulsive (reaction time < 100 msec), too distracted (rt > 3000 msec), or gave the wrong color response (Error Code= E)]
(2) determine whether enough valid trials remain for further analysis (>39 trials), and if so:
(3) calculate a mean reaction time score for each of the 8 word types [where denominator for each word type is based on # remaining (non-discarded) trials for that word type]
(4) merge each participant's summarized data as single rows in a common spreadsheet (for importation and further analyses in SPSS), like this:
---------------------------
ID#...... MeanRTW1.......MeanRTW2...... (etc. for word types 3-8)
101.......1056................2013...............
102.......2148................2594...............
103...
---------------------------

Excel File Format: I've attached a sample file, and here's a simplified overview of a spreadsheet (irrelevant columns and some rows removed). First the ID number is recorded (e.g., 393E), then some unnecessary junk (exp name & date, intro, practice, instructions), then data for the 48 actual trials of interest:
-------------------------------------------
........A...............B..................C.................D............
1 393E
2 stroop.xpt
3 Wed Jan 1, 12:33:00 2008
4
5
6 Trial Name.....Trial No..... Error Code.....ReactionTime
7 introduction..... 1................C............561243
8 practice.......... 2................C............... 2062
9 red-worried........14.............C................1001 (*the first practice trial)
10 (9 more practice trial rows, deleted here)
19 instructions........3..............C................5000
20 red-chicken......19..............E............... 1205
21 blue-tense.......32...............C.................782
* (46 more actual trial rows, deleted here)
--------------------------------------------------

To clarify:
-The variable 'Trial Name' indicates nominally what stimulus was presented for each trial.
-The variable 'Trial No.', indicates the unique numerical marker for each stimulus word. (It probably should have been labeled 'Word Type'. It doesn't reflect the order of stimulus presentation. E.g., the word "tense" is always 'Trial No.' 32 for all participants, regardless of when it presents.)
-A subset of actual trial words (e.g., worried) were also used for the 10 practice trials. Thus, the 10 practice trials must first somehow be discarded or flagged to be ignored before calculating average reaction times for the remaining 48 actual trials.

View 14 Replies View Related

Encourage Enabling Of Macros: Disable Macros When Opening Then The Worksheet Menu Bar And Other Command Bars Are Still Available

Aug 26, 2009

I have an Excel 2003 program that contains macros. One of the macros hides certain command bars and disables the worksheet menu bar. On close the opposite is true. The problem is, if a user uses the disable macros when opening then the worksheet menu bar and other command bars are still available. I would like to hide all of the data sheets and display another sheet that would normally be hidden displaying a message that the macros have to be enabled for the program to work correctly if disable macros is chosen. When the enable macros are used I would like the Error page to be hidden.

View 6 Replies View Related

Enable/Disable Macros When No Macros Are Present

Jul 28, 2008

I have a user that keeps a maintenance log in an Excel worksheet and sends an updated copy once a week to a board member. Two weeks ago, the board member started complaining that he was prompted to enable/disable macros on opening and became worried when my user stated that no macros were used in the book. He is now concerned that we have sent him a virus.

I know the file is clean because I've scanned it, and when I look at the file in VB, there are no modules or classes present just the Sheets 1-3 and the ThisWorkbook file. None of these objects have any code in them. My user does have some macros in PERSONAL.XLS but they are not used in the workbook in question.

No one else gets the prompt for enabling/disabling macros. Even if I set my security to prompt for any macros, I get no message. I'm convinced that there must be some setting in his Excel that is causing this individual to get this message. Is there anything else other than a macro that would cause this?

View 9 Replies View Related

How To Delete Another WorkBook Macros Using Macros

Jul 23, 2005

What is the commands or script for deleting a macro automatically using
another workbook macro.

View 9 Replies View Related

Hiding Macros From The Run Macros List

Jul 14, 2008

Is there a way to hide a macro from the list where you choose which to run, but not in the VBA editor? The userbox I just created calls upon 2 different macros, and has a macro to bring up the userbox. I need a way to hide the macros in Module3 from selection, but keep the macros in Module4 available to choose to run.

View 9 Replies View Related

Macros Really Slow The Another Macros Is Run

Dec 14, 2009

I have two macros. Macros 1 opens another excel file, counts the number of rows it has, inserts that number of rows into the master file and then copies the data over. Key code as follows (x3 for 3 worksheets)...
For k = 1 To numrows
Selection.EntireRow.Insert
Next k

Macros 2 'cleans' the appended data by systematically going through each row, checking if certain cells have data, and if not deletes the rows. Key code as follows (x3 for 3 worksheets)...

For l = lastrow To 12 Step -1
If WorksheetFunction.CountA(Range("B" & l & ":C" & l)) = 0 Then
Rows(l & ":" & l).Select
Selection.Delete Shift:=xlUp
edelrows = edelrows + 1
End If
Next l

Here's the weirdness. macros 1 runs fairly quick the first time out (few seconds). Macros 2 takes about 2 minutes to run (which I'm fine with). However, when I run macros 1 AFTER running Macros 2, Macros 1 goes from taking a few seconds to a few minutes.

View 11 Replies View Related

Version 4 Macros And Vba Macros In Them

Apr 13, 2007

how to use excel 4 macros. I do not even know where to put them. I have inherited some spreadsheets that have both Xcel 4 Macros and vba macros in them. (Well, I get a warning that I cannot switch them off when I disable macros on opening a workbook). I cannot even find the offending version 4 macros so that I can re-code them in VBA.

View 2 Replies View Related

Merge The New And Old Columns?

Mar 31, 2014

I have two columns, which have different length and in which there can be three types of data:

The data also in the first and the second column, so it is an old data.Second is, that the data is in the first column, but not in the second, so it is old, but it was solved.The third type is, when the data is in the second column, but not iin the first, so it is new data.

My task is to regularly update the list (so I have to merge the new and old columns), to see in which conditions the data is, but not to delete any of them (only the recurring, so if it is old, then it must not be listed two times).

View 1 Replies View Related

Looking Up 2 Different Tables To Merge?

Feb 19, 2014

I am trying to merge two different databases in the next week. The problem I am running into is the name from 1 database isn't always the same on the other database.

I want to merge Database 1 with Database 2 and create a relationship with them both by using the database 2 internal #. As you can see in my table database 1 has similar names to database 2 but they are not exact. I want to match these names and have the formula on match tell me what the database 2 internal # is. I have also uploaded a sample excel doc with a note in B2.

database1
Herb Chambers Ford of Braintree
Herb Chambers Honda of Seekonk
Dimmitt St. Petersburg
Database 2 matched internal #
Database 2
Herb Chambers Ford of Braintree (Dave Dinger Ford)
Herb Chambers Honda Of Seekonk (7-FI)
Dew Cadillac (Dimmitt of St. Petersburg)
Database 2 internal #
15360
15301
25413

View 2 Replies View Related

How To Merge Cells In Same Row

May 30, 2014

How can I merge cells in the same row so when I sort a column (A>Z for example) the contents of the row near the selected one change position as well. I paste a picture for example.

View 9 Replies View Related

Merge & Wrap

Oct 4, 2007

I have a need to merge cells in a row and there to be more than one line of data in the merged cell. I also format it to wrap text. But I found that when doing this with merged cells it won't automatically resize the height of the row to accomodate the wraped text. It can be done manually, but this is a pain.

View 13 Replies View Related

Merge Columns A And B To C

Feb 7, 2009

I have a need to get the data from columns A and B and transfer to C but one line from A and second line from B and this successively until the end of A and B. They will have the same number of lines.

View 3 Replies View Related

Merge Two Worksheets ...

Feb 8, 2009

Is there any way that you can combine two worksheets or Excel files, for example:
WORKSHEET_1 has columns and values as:
firstname
lastname
city
state

WORKSHEET_2 has coulms with NO values as:
firstname
lastname
address
city
state phone

I want to take the info from WORKSHEET_1 and insert it into WORKSHEET_2 without specifying any columns since WORKSHEET_1 might sometimes have only 1 column and sometimes might have all 5 columns.

The purpose of this is to create a standardized Excel file that I need to import into a Database, however the users might have Excel files without all the columns required therefore I need to "standardize" the worksheet before being imported and have any black values import as NULL into the Database

View 14 Replies View Related

Merge Worksheets

May 9, 2009

I need to merge for worksheets (in the same workbook) into 1 large worksheet.

Is there a command that does this? Or do you guys have a custom macro that does this?

View 11 Replies View Related

Merge Two Formulas

Nov 12, 2009

I have these two formulas in my excel that are being used to "prepare the data from a web query. Basically what I want to do is strip a number such as x.xxxxx to only x.xx and change to dot to a comma so that the end result it will be x,xx.
So far i have two formulas: =MID(A1,10,4) and =SUBSTITUTE(A5,CHAR(46),CHAR(44)) and I want merge these (or find a better solution).

View 3 Replies View Related

Merge 2 Spreadsheets?

Nov 23, 2009

I want to do....is...a macro or something....to be like "Hey...were going to match up column information based on the first column, there exists both the same data in both sheets....as you can see in A3 and A2, now, I want to be able to add the information that is in book1, into the "DBL approved", so like...the 2nd row, I want columns B-G to be filled via book 2 because its saying,

"okay, A3 in DBL has the data 00-120-01, but there exists no data next columns over...but oh look, A2 in Book1 does, let's fill in that missing information!" so now it'll fill in the bullet points, brand, segment, etc."

View 4 Replies View Related

How To Merge Two Columns Together

Jan 26, 2013

How I can merge two columns together and keep the data in both columns?

I have an address issue when the data was converted to excel it put the numbers part of the address in column "C" and the street name in column "D".

View 2 Replies View Related

Mail Merge

Oct 30, 2007

I am a teacher and my department uses Excel for grades. We need to be able to print grade reports for students. We currently use a mail merge to do this, but some teachers are having a hard time with this process. They don't seem to understand using the two programs together.

View 14 Replies View Related

Merge 2 Columns

Sep 12, 2008

i am trying to create a macro that merges two columns in excel.

View 9 Replies View Related

Merge The Cells...?

Aug 6, 2009

I've got a workbook with a ton of worksheets in it. Every worksheet has 4 columns a, b, c & d that I want to merge so that column a will be the contents of the 4 cells above seperated by _ so it will become a_b_c_d. not sure if im explaining this right but i think you'll get what i mean. i need to do that for every worksheet in the workbook

View 5 Replies View Related

Merge Two Strings And Use Them As A Name?

Jan 31, 2010

For example: I want to sort through a a bunch of textboxes and refer them to certain cells. I know I can have a string "TextBox" and then the looping number "nbr" and merge them into for instance TextBox1. But I can't figure out how to use this as a command. Like

View 2 Replies View Related

How To Merge All Tabs Into One

Jan 23, 2013

I have a file with around 20 tabs. Can I merge all the tabs into just one tab?

View 1 Replies View Related

How To Merge Cells W/ VBA

Mar 20, 2007

I say reluctantly because it seemed easy enough that I should have been able to locate it in the help file of VBA. Which leads me to believe I do not know how to search effectively in VBA, yet/still.

how to merge cells w/ the use of VBA.

Below is my Post and Answer by EE ....

View 9 Replies View Related

How Can I Merge Two CSV Files

Jan 2, 2009

I have two CSV's which are updated on a regular basis.

CSV Master - contains about 23,000 rows at the moment and will continue to grow.

CSV Master - does have a header row

CSV Master has unique (8 digit) numerical ID's in column A so all unique ID's start at "A2"

CSV Master - contains 31 columns ("A through to and including AE") this is a fixed figure.

---- Then I have ---

CSV Extras - generally contains about 200 rows and its unlikely it will ever be more but is contents are different every time it is used.

CSV Extras - does have a header row

CSV Extras has unique (8 digit) numerical ID's in column "A" so all unique ID's start at "A2" and these ID's are a common denominator with both sheets.

CSV Extras - contains 44 columns (last column is AR) which is a fixed figure,

CSV Extras - columns "B up to and including AE" are all intentionally all blank fields.

--- Hope that explains where I am, this is what I need to do ----

I need to be able to look up the ID's (that are in column A in both CSV's) and create a single CSV. In my mind that is a Vlookup of some sort but I can't get it to work

I want to open CSV Master and then, If the ID exists in CSV Extras then fetch all the data in columns "AF to AR" and add it to the CSV Master.

View 9 Replies View Related

Merge In One Cell

Feb 20, 2009

Have a data like this

350 352 353 362 364 I want to merge it into one cell

View 9 Replies View Related

Merge Cells ..

Apr 23, 2009

I have a rather large amount of data that comes to me very frequently in a bit of a mess and I have a need to somehow do the following:

I need to look for a cell that has date text in the format of 3 characters for the month followed by a four digit year i.e.Apr 2009 or Sep 2009 along with one marked YTD.

The cell then needs to be merged with the 2 adjoining cells to the right.

This heading structure repeats itself frequently over about 700 hundred rows so it will need to repeat itself until all date looking cells and YTD's have been merged with the 2 adjoing cells.

View 9 Replies View Related

HOW To Merge 2 Cells

Jun 1, 2009

i have a file i need to merge 2 cells. the first cell has street number. second cell has street name. and i need a space between the number and the name

View 9 Replies View Related

Merge Cells ....

Jun 3, 2009

I have sheet and this kind of data in two colums:

A B
1 Text
2 continues in different
3 rows in B column.
1 I want to
2 merge this
3 text in single
4 row.
1 1 in A column
2 means a new row.
1 How can
2 I do it,
3 maybe with
4 macro?
1 Again new row.

There are over 30000 rows in my sheet. So there must be way to do it some other way than manually with copy-paste method.

View 9 Replies View Related

Merge All Workbooks In One

Aug 5, 2009

I have 5 worksheets, representing data from 5 days, M-F. On a weekly basis I open all 5 files and manually copy, and paste all into one large weekly file. Does not take very long so I am probably just being lazy but if I could find a simple solution to merge all 5 into one quickly it would be great.

The one solution I was planning on implementing was to cycle through all OPEN workbooks, copy the data into a new workbook, and close each workbook as the copy and paste is done. This will work but to me its 'dirty'. Each workbook only has one Worksheet.

View 9 Replies View Related

Merge Cells

May 16, 2006

I want the representant to fill the form we have with number 1 or 0. The only things, it's some time My cells are merge for visual aspect of the form. I made it work with a single cell but now I'm facing a wall for merge cells. This is the code for a single cell:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Range("I9")) Is Nothing Then
Cancel = True 'Prevent going into Edit Mode
If Target = vbNullString Then
Target = "1"
Else
Target = vbNullString
End If
End If
End Sub

View 3 Replies View Related

Merge Cells With Same Value

Sep 21, 2006

How we can automatically (with macro) merge & center cells with same value? For example if ranges A6, A7, A8 have the same value 09/20/06, find them & merge A6:A8 & get only one 09/20/06.

View 9 Replies View Related

Merge Many Files Into One

Dec 6, 2006

1. I have a master file (master.xls), currently empty

2. I have 80 excels files (all look a like but their worksheet name are different)

3. I would like all the data from these worksheet to be appended to master.xls with a click of button.

4. I tried using some codes from this forum but they did not work.

5. All the source file starts with ums bla bla.xls

View 9 Replies View Related

Merge Files ...

Jan 31, 2007

I have two files that need to be merged together (file1 & file2). These two files have three columns each. One column on both files is the same. This column is labled "phone number". One file has more lines the other has less.

I would like to make a macro that will check file1 against file2. If it finds a phone number the same it will cut the whole line and append staring in column 4 to same line in file1.

View 5 Replies View Related

Merge Cells In VBA

Feb 9, 2007

Is it possible to merge cells in VBA? I tried this:

Worksheets("Sheet1").Range(A1,B2).Merge = True

I also tried this:

Worksheets("Sheet1").Cells(A1,B2).Merge = True

This is in a blank spreadsheet.

View 2 Replies View Related

Merge 2 Macro's Together

Jul 21, 2007

I have two macro's that I need merged together. Specifically, the macro Find75 is run first which produces a new sheet, Peaks Found, and then normally I would run the kTest macro to give the Final Results sheet. Need to get this all into one macro? Thus one macro to run would produce the final results sheet, without producing the intermittent step of producing the Peaks Found sheet.

View 2 Replies View Related

ADVERTISEMENT