Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Macro to combine (sum) like items

Looking to clean up product order list of items with a macro. Idea would be
that if the part number is the same sum all lines into one and then delete
each line other than the sum line.

There are presorted by the part number so the like values would be in
adjacent rows.

Thanks so much!

Scott

Here is an example of what I have:
Qty Part #
4 SG400R
1 TK4V1200R
1 TK4V1200R
6 TNG3
8 TNG3
6 TNG3
2 SKLB36BC1200
1 SKLB36BC1200
1 TCAL125
12 TCAL125

Here is what I'd like to end up with:
Qty Part #
4 SG400R
2 TK4V1200R
20 TNG3
3 SKLB36BC1200
13 TCAL125


Post your answer or comment

comments powered by Disqus
I asked about this on another forum but got zero help. Maybe someone here can help. I tried to write a macro but its just not doing what i need it to do.

I have a spreadsheet of scrap part data that i need to combine. The key identifiers are a "job" column and then a "defect" column. I would like the macro to combine the similar job numbers and defects, summing the qty of duplicate defects/job numbers

Not sure if this explanation is sufficient to get my point across so i included a worksheet with what the final combined data should look like

"RawData" is the data needed to be combined.
"Sheet1" is the results when i run the macro i tried to write.
"needed results" is the final results i need the macro to do(i did that sheet by hand)

I really appreciate any help givin!!!

Will

I have been trying to find a solution to my problem for a few months now and I have, thus far, been unsuccessful at finding a sufficient solution.

Just to give a bit of background info: I am a biologist working with formulas to distribute hunting pressure across the State of New Mexico. I have a worksheet for each Game Management Unit in the State and each Unit contains its own hunt objective. We have properties that fall in multiple units (all under a unique identifier), and these are causing the major problems.

I have about 40 worksheets that have the same header information in rows 1 through 7, but a varying number of rows below that information (from a few to 200). Row 8 is the first row with differing information on each worksheet.

I have been trying to come up with a way to combine all worksheets into 1 worksheet and have Excel combine all instances with a unique identifier into 1 summed row (i.e. if a property has 1,000 ac and 1 tag in Unit A, and 4,000 ac and 4 tags in Unit B, I want the final to have 5,000 ac and 5 tags). Not all properties have more than 1 entry, but some have 3.

Ultimately I would like to run a macro each time we need the single worksheet with all properties listed on it, but haven't been able to figure things out (I am not that good with macros).

I have gone through and done things manually and it takes about 5 hours and I make mistakes. I would like something quicker and more foolproof than I am.

Any help is greatly appreciated.

Ryan

Hi,
Sure this is simple for regular users (I'm just not).

I have two columns, first is road name and second is mileage. The roads are broken out from my GIS into segments. For instance Main St might have 6 segments because of crossroads.

I need to combine the like road names and sum the mileage so those six segments have one entry.

Please help.

I have tried a formula to combine/sum these items together and was able to do it; however, my file is way too big for a formula to make this happen without crashing (besides it would be much easier). I was hoping someone could make this happen in a macro (please see sample data attached)? I appreciate your time.

Book1.xlsx

Hi All,

I just joined Ozgrid and this is my first post.
I'm new in VBA programming and i would need your help.
Fyi, i am using Excel 2007.

This is my issue:
I have data in "Sheet1" containing info about Month, Region, etc...

Month Region Activity CT Carton 1 SA IR 11.0 10 2 SA MFE 37.0 3 2 GC IR 23.1 27 2 SA IR 23.1 28 1 GC IR 24.2 29 2 SA MFE 37.0 1 2 SA IR 24.2 23 1 SA IR 24.2 23

With a VBA program, excel copies the data in "Sheet2" and proceed to sort the data, then to insert an empty row to separate it per month, region, activity, as follow:

Month Region Activity CT Carton Jan GC IR 24.2 29 X Feb GC IR 23.1 27 X Jan SA IR 24.2 23 Jan SA IR 11.0 10 X Feb SA IR 23.1 28 Feb SA IR 24.2 23 X Feb SA MFE 47.0 1 Feb SA MFE 47.0 3 X

The above data are in the following column: Month = Column B, Region = Column C, Activity = Column D, CT = Column J, Carton = Column M.

As you can see the above data, after sorting, looks like blocks of data.

I need to be able to calculate for each block the sum of Carton and insert the result in the empty row and in the corresponding column (infact this part has just been resolved).

But, i need also to be able to calculate for each block the SumProduct of the CT versus the Carton: =SUMPRODUCT(CT*Carton)/TotCarton
And insert the result in the empty row in the corresponding column (X).

This knowing that the above data range is dynamic, so i cannot determine a fix range like ("C2:C7"), because the lengh of those ranges will change every month.

I have resolved the SUM issue with the following code, found browsing some forum and adapted to my case:


	VB:
	
For Each aArea In ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants).Areas 
    Rows(aArea.Row + aArea.Rows.Count).Font.ColorIndex = 5 
    Rows(aArea.Row + aArea.Rows.Count).Font.Bold = True 
     
    cells(aArea.Row + aArea.Rows.Count, 13).Formula = "=SUM(" & Range(cells(aArea.Row, 13), cells(aArea.Row +
aArea.Rows.Count - 1, 13)).Address & ")" 
    cells(aArea.Row + aArea.Rows.Count, 14).Formula = "=SUM(" & Range(cells(aArea.Row, 14), cells(aArea.Row +
aArea.Rows.Count - 1, 14)).Address & ")" 
    cells(aArea.Row + aArea.Rows.Count, 19).Formula = "=SUM(" & Range(cells(aArea.Row, 19), cells(aArea.Row +
aArea.Rows.Count - 1, 19)).Address & ")" 
    cells(aArea.Row + aArea.Rows.Count, 20).Formula = "=SUM(" & Range(cells(aArea.Row, 20), cells(aArea.Row +
aArea.Rows.Count - 1, 20)).Address & ")" 
     
Next aArea 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
But i still have difficulties to combine the SUMPRODUCT calculation following the same type of codification.

Knowing that to calculate my SUMPRODUCT I will need to use the TotCarton value of the previous SUM.

I hope the above explanation is good enough, otherwise please let me know.

Thanks in advance for your good help.
Lomic6

I need to create a macro which can combine data from defined criteria. Ultimately there will be a list of indentifiers to combine separarely.

example:

Identifier
1234 - data
4567 - data

combine (sum) data from 1234 and 4567 into a new row below.

6789 - data
0123 - data

combine (sum) data from 6789 and 0123 into a new row below.

Etc.

Firstly, I just wanted to give a big thanks to all who contribute to this forum!!! I've been lurking for some time, but today is my first time posting.

I've got a macro that combines multiple worksheets and workbooks. Just a minor problem, the very last row of each worksheet is being deleted, and I can't seem to pinpoint the cause of the problem. Does anybody know what is causing this error?

Thanks in advance.

Regards,
Denver


	VB:
	
 'To a sheet named 'Data' in the sheet in which the macro is run from
 
Dim pasterow As String 
 
mainsheetname = ActiveWorkbook.Name 
 
MsgBox ("Please select spreadsheets to combine") 
filestoopen = Application.GetOpenFilename(MultiSelect:=True) 
 
responseval = MsgBox("Do you want to leave the combined spreadsheets open?", vbYesNo) 
 
Worksheets("Data").Select 
Range("A1").Select 
 
 'open workbooks
For Each w In filestoopen 
     
    Workbooks.Open Filename:=w 
    copysheetname = ActiveWorkbook.Name 
     
     'copy and paste sheets
    For Each sh In Worksheets 
         
        sheetnumber = sh.Index 
         
        Worksheets(sheetnumber).UsedRange.Copy 
         
        Workbooks(mainsheetname).Activate 
        pasterow = Workbooks(mainsheetname).Worksheets("Data").UsedRange.Rows.Count + 1 
        Workbooks(mainsheetname).Worksheets(2).Range("A" & pasterow).Select 
        ActiveSheet.Paste 
         
        Workbooks(copysheetname).Activate 
         
    Next sh 
     
    If responseval = 7 Then 
        Application.DisplayAlerts = False 
        ActiveWorkbook.Close 
        Application.DisplayAlerts = True 
    End If 
     
Next w 
 
Workbooks(mainsheetname).Activate 
 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


Hi all,

I'm trying to assign a macro to the custom menu item buttons that i've created in a toolbar. I'm hoping to assign the macros via code when th eworkbook opens (Workbook_Open).

Just as FaceIDs do not show up as an option, I am able to assign FaceIDs via


	VB:
	
Application.CommandBars("Sorts").Controls(1).FaceID = 40 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
I'm pretty sure that macros can be assigned in a similar fashion. This is probably really simple but i'm not sure how.

Any ideas?

Btw, is it possible to name the buttons? Just as how you can name buttons created on userforms?

Hi everyone,

I download data in this format:

******** ******************** ************************************************************************>Microsoft Excel - for mrexcel macro to add total.xls___Running: 11.0 : OS = Windows XP File Edit View Insert Options Tools Data Window Help AboutB16=
ABCDEFGHIJKLMN1 JanFebMarAprMayJuneJulyAugSepOctNovDecYTD2Corp Acctg Salary        3,706.61        3,598.39        3,509.91        3,477.08        3,706.75        3,579.64        5,241.81 00000        26,820.20 3Corp Acctg Benefits           973.66        2,066.35           901.58           891.45           384.38           903.75           980.94 00000         7,102.12 4Corp Acctg T&E             31.54                  -                    -               13.99               5.87                  -                    -   00000              51.40 5Corp Acctg Postage               4.92                  -                    -                 8.78                  -                    -                 2.26 00000              15.96 6Corp Acctg Telephone             28.21             30.02             43.11             32.50             49.88             40.40             76.51 00000            300.63 7Corp Acctg Rent           411.00           397.20           397.20           439.03           418.11           418.11           418.11 00000         2,898.76 8Corp Acctg Other           204.30               4.06               5.64             88.07             12.75               4.06           213.56 00000            532.45 9Total Corp Acctg        5,360.24        6,096.02        4,857.45        4,950.90        4,577.74        4,945.98        6,933.19 00000        37,721.53 10              11Corp Admin Salary       15,779.23       14,389.89       14,469.79       15,158.85       15,455.70       14,598.71       15,976.61 00000      105,828.79 12Corp Admin Benefits        4,384.01       15,256.40       25,211.43        6,858.14        7,097.75        4,690.24        8,192.45 00000        71,690.41 13Corp Admin T&E           461.45        1,387.54        1,001.31        1,384.66        1,081.25        1,561.99        1,902.93 00000         8,781.13 14Corp Admin Printing                  -                    -         13,927.35                  -                    -                    -                    -   00000        13,927.35 15Corp Admin Qualification                  -             183.95        1,323.28           185.30           301.76           211.48                  -   00000         2,205.77 16Corp Admin Postage           162.15           132.08           341.33           198.72           188.63             19.32           190.91 00000         1,233.14 17Corp Admin Telephone           175.09           297.31           379.32           304.31           365.60           253.97           193.61 00000         1,969.22 18Corp Admin Rent        4,030.80        4,587.46        4,611.59        4,960.66        4,786.12        4,786.36        5,133.41 00000        32,896.40 19Corp Admin Professional        3,046.95        3,046.95        3,046.95        3,046.95        3,046.95        3,156.57        3,046.95 00000        21,438.27 20Corp Admin Insurance              21Corp Admin Other       16,090.92       15,128.41       20,267.01       15,029.85       19,888.04       29,692.56       16,139.53 00000      132,236.31 22Total Corp Admin       44,130.59       54,409.98       84,579.36       47,127.44       52,211.82       58,971.21       50,776.40 00000      392,206.79 23              24EM Salary       10,475.90        5,412.23        6,181.39        5,972.06        5,972.02        5,749.20        6,292.17 00000        46,054.96 25EM Benefits        1,434.64        6,120.10           681.14           682.50        1,761.00           681.16           681.85 00000        12,042.39 26EM T&E           455.29        1,333.41                  -                 2.50        1,132.63                  -          4,434.59 00000         7,358.41 27EM Telephone             91.86           126.17           137.78           115.08           274.56           318.90           640.10 00000         1,704.45 28EM Rent           444.04           429.14           429.14           474.32           451.73           451.73           451.73 00000         3,131.83 29EM Other             12.76               4.03             12.76             44.64           359.89               3.25           112.29 00000            549.62 30Total EM       12,914.49       13,425.08        7,442.21        7,291.10        9,951.82        7,204.24       12,612.73 00000        70,841.66 Sheet1 
[HtmlMaker light Ver1.11] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

I'd like a macro that inserts a row under each row whose cell in column A begins with the word "Total", then add sum formulas to columns B-N in that row to add up all the numbers immediately above the downloaded total row, but of course stopping at the blank row:

******** ******************** ************************************************************************>Microsoft Excel - for mrexcel macro to add total.xls___Running: 11.0 : OS = Windows XP File Edit View Insert Options Tools Data Window Help AboutB10C10D10E10F10G10H10I10J10K10L10M10N10B24C24D24E24F24G24H24I24J24K24L24M24N24B33C33D33E33F33G33H33I33J33K33L33M33N33=
ABCDEFGHIJKLMN1 JanFebMarAprMayJuneJulyAugSepOctNovDecYTD2Corp Acctg Salary        3,706.61        3,598.39        3,509.91 

OK, I have some very large worksheets and a macro would save me days in this situation.

The raw data outputs a sheet with various columns, column A being the ID field. This is not a unique field and contains duplicates.

For each unique ID, i would like to combine all of the data that is unique to that ID per column.

For example, on the attached sheet the first ID is 1. Going across the columns, column B has 1 set of unique data for 1 ("A"), column C has 1 set ("B"), column D has 1 set ("C"), column E has 2 unique records ("D" for first 1, "E" for second 1), and column F has two unique records ("111" for first and "112" for second). I would like one row outputed on a differrent sheet:
(sep columns)
"1" "A" "B" "C" "D/E" "111/112"

Is this a feasible request or too difficult? I am currently doing this manually and is taking hours as the sheets are 30K rows each :/

Hello,

I am new to excel and I am trying to create macro for a spreadsheet where I can go through a list of 4000+ entries. What I have is column A is "Store Number" and column B is "Item Number", there will be repeat store numbes in column A. I need the macro to go through column A and search for all the same store numbers and copy the items numbers in column B and combine them together so there is only store number with a list of item numbers (this can be placed in Column D and E).

Can anyone help me with this? Thanks!

M

Hello, I'm very new to using macros and also very new to this forum! I wondered if anyone could help me with a VBA macro that I'm a bit stuck with. I work as a researcher and I'm collecting data from an eye tracker, this generates a few thousand lines of code per person as I get a row of data every 16ms. As a result, I'd like to summarise the data into something that's slightly more manageable!

I've been trying to adapt a macro written for a similar experiment but I'm pretty stuck as I can't see what's going wrong. The task involves people looking at images (six possibilities) and hearing a sentence. I have a workbook with a worksheet in that contains the words that are heard and the onset and offset times of each of the words. For each word that is heard in each sentence I want the macro to sum the amount of time spent looking at each area of interest (AOI) and print this with the following headings.

Phrase= sentence heard
Word_Playing= word playing from sentence
Time_in_AOI= time spent looking at target AOI.
AOI1_Pic= name of the picture at AOI1
AOI1_Time= time spent looking at AOI1
...
...
...
..
AOI6_Pic=name of the picture at AOI1
AOI6_Time=time spent looking at AOI1
Time_Not_Looking= time spent not looking

As the code stands it runs and generate a new worksheet and the headings but that's about all. I keep getting a runtime 91 error, debugging says that this:
is the problem. Being so new to macros I'm not sure what this is line is achieving. This error ties in with the macro failing
to find the AOI worksheet (a textbox appears stating this), I'm not sure why.

I've attached my workbook and also my code (I've tried to comment as much as I could work out) as I think this might be helpful, I couldn't embed my code as it made this post too long.

Does anyone have any idea how I might fix this as I'm a bit stuck and any help would be very gratefully received ? I'm keen to learn about macros but my Googling of the problems to date haven't been to helpful.

Thank you,
Kerry

I was going to export my data to FileMaker to try to do this with a series of IF statements and Concatenations, but for efficiency I'd really like to use a VBA macro.

Current data set, Sheet1:

A (title)/B (page start)/C (page end)/D (answer key)
cats/1/2/answers
dogs/3/3/
bears/4/6/answers
frogs/7/7/answers

I want to combine the contents of an entire row into one cell. Ideally, after running a macro, the above data would like this on Sheet2:

1 cats, pp. 1-2, answer key
2 cats, pp. 1-2
3 dogs, p. 3
4 bears, pp. 4-6, answer key
5 bears, pp. 4-6
6 frogs, p. 7, answer key
7 frogs, p. 7

Explanation:
If a title has an answer key (i.e., if column D is *not* blank), then it gets listed twice, the first listing should have the words "answer key", and the second listing should not (see rows 1 and 2 above).

If the page range is greater than one page (i.e., if 'page start' does *not* equal 'page end'), then format pages like this: "pp. 3-4";

but if the page range is only one page (i.e., 'page start' = 'page end'), then format pages this way: "p. 5".

Can anyone help me with a macro? Thank you!

Hello,

I was hoping someone could provide me with a Macro to solve the following problem:

I have a table which has employee names on the left handside. Next to them are contacts in a region.
Names     Region1 Region2 Region3 Region 4 

John
Mike          1            1        2          3
Doug         2                      1      
Doug         1
Sarah                      1        3
Sarah                      2                    2
What I need to do is to combine the data for the employees that have been duplicated and leave the non-duplicates as is. That means for example there should only be 1 row for Sarah and Doug with the values in the duplicate row added together.

So when the macro is run the table should look like this:
Names     Region1 Region2 Region3 Region 4 

John
Mike          1            1        2          3
Doug         3                      1      
Sarah                      3        3          2
I hope I have explained this clearly. All help is appreciated.

Thanks

There is an excel work book named ďBudgetĒ. The workbook has the following sheets Cost Centre sheet Sheets named after their respective codes ( 4545, 4654, 3232 etc)These codes (Sheet names) belong to different groups. The names of these groups and the codes ( Sheet names) that fall under those groups is mentioned in the sheet named ďCost CentreĒ. I want excel to do the following.
I want excel to add the values in the codes-sheets and create a new sheet to display the results of the addition. This new sheet will contain the sum of the code sheets. Which code sheets to add will be determined by the ďCost Centre sheetĒ. Codes that belong to a certain group will be added together in a new sheet. In this way all the groups that are mentioned in the cost-centre sheet will have a separate sheet which contains the sum of the code-sheets that falls under that group, as mentioned in the cost-centre sheet. Once that macro is created then i also want to know that can I edit this macro and caclcute variance as well accross these groupsExample. There are 8 work sheets with the names (Codes ) 23, 24 ,25, 26, 27, 28, 29, 30, Ö. The codes 23 24 25 belong to the Group named - Hyderabad, 26 27 28 belong to faisalabad, and 29 30 belong to lahore. This detail is mentioned in a sheet named Cost Centre. Below is how this will be mentioned

Hyderabad Faisalabad Lahore 23 26 29 24 27 30 25 28
So based on these details, I want excel to generate a new sheet that adds sheet named ď23 24 35Ē to a new sheet and name it ďHyderabad" and so on.
Explaining it again = In the beginning of my work book, there is a sheet named Cost-Centres. In the first row of my workbook is the name of the group, and below it are the sheet names that fall in that group. I want a macro that can sum the sheets that are mentioned in each column under the bold-heading. The first column is same in all the (code)sheets, so the macro should some all the data after the first row. basically sum from g7 to af405.
So each column in the cost centre sheet represents a diferent group, and that group will be added to another sheet, which will be named after the cell in the first row (e.g Hyd Zone etc.) These group names and the sheets that fall under them might change so a general macro, that treats the frst cell of the column as group name and add all the sheets mentioned below is needed. Please see if that is possible, once we can make a macro for summing these sheets, also can we further make a macro for calculating variance across these groups etc by modifying this macro.
Regards

I have 2 cells that dump data in a column format. I need to combine these two cells with a ' after the data in the column. This macro will loop down until both column J and K are empty,
I need a Macro that
1. Will combine both cells
2. Data will be value format not formula
3. Macro Will run as soon as workbook is opened

Ex.

F J K
1 Prop MD MD Objective
2 1' Test Data 1 Test Data
3 235' next data 235 next data

Hi,

Included in the newsample.xls file I have a table A1:W25 which is my starting point. I then run a macro called "Restructure" and it changes the data into a table that looks like X1:AS5

What I need is help modifiying the macro to include the values of the cells at the end of the assignment name. See a partially complete table in X7:AB8

Thanks in advance!

Hi,

I am wondering if there is any code to SELECT (DESELECT) A MENU ITEM using VBA?

I have an Excel Add-in program installed, which adds a Menu "Easycal" to my Excel menu bar.
Under "Easycal" (drop down list), I have the following items:

Refresh workbook
Refresh worksheet
Turnoff Easycal
Help

I am using "Easycal"'s functions in various cells of my sheet "Final". When I select "Refresh worksheet" from "Final", "Easycal" fetches (or calculates) me the data from the "Easycal" database.

I have a macro (on "Final") that pulls together data from other sheets of the same workbook.

I there anyway to include a code in my existing macro, so that when I run the macro, the following are completed in sequence:

1. Select "Turnoff Easycal" menu item
2. Run my existing macro (to pull the data from other sheets to "Final")
3. DeSelect "Turnoff Easycal" menu item
4. Select "Refresh worksheet" menu item

Thanks,
Austin

hello everybody

i am using this macro
Sub Combine()
Dim J As Integer
On Error Resume Next
Sheets(1).Select
Worksheets.Add ' add a sheet in first place
Sheets(1).Name = "Combined"
For J = 2 To Sheets.Count ' from sheet 2 to last sheet
With Sheets(J).UsedRange
'Copy heading(1st row) only from Sheets(2)
' otherwise, copy from 2nd row
.Resize(.Rows.Count - IIf(J = 2, 1, 0)).Offset(IIf(J = 2, 1, 0)).Copy _
Sheets(1).Range("A65536").End(xlUp)(3)
End With
Next
End Sub

to move all worsheet into one . it is working 99% good the only thing thats not being transfered to "COMBINE" is the first line of sheet one only!!! . but everything else on that sheet 1 and the other sheet gets transfered.
can anyone assist me with this problem, or has a better macro to accomplish this task.

Hey all,

I receive payment files in excel. I have a 3 column, a Item ID, Quantity, and Price. I need to do 2 things with it.

1. I need to combine all rows that have the same Item ID and the same price. (with the quantity columns being added together)

2. I need to be able to do the opposite. Meaning, for each row, look at the quantity, create an exact copy of that row that many times (changing the quantity to 1)

It would be best if this can be coded so i can select the range and have this preformed on my selection only. Also, a input box would be required to enter the 3 columns (Item ID, Quantity, and Price) as they vary from workbook to workbook.

Thanks in advance. (love this board)

Simple question(I think) - from a newbie

Ok, I have looked through here and I know cleaning up names is difficult. The thing is I have all the formulas I need to do it, and for my data it works every time. I was just wondering if there was a way to put them into a macro so that I don't have to use so many columns and cut and paste. Here is how everything is layed out.

Column "A" - Names
Column "B" - =TRIM(A2)
Column "C" - =IF(ISERROR(FIND(" ",A2,1)),A2,LEFT(A2,FIND(" ",A2,1)-1))
Column "D" - =IF(ISERROR(FIND(" ",A2,FIND(" ",A2)+1)),RIGHT(A2,LEN(A2)-FIND(" ",A2)),RIGHT(A2,LEN(A2)-FIND_
(" ",A2,FIND(" ",A2)+1)-0))
Column "E" - =CONCATENATE(D2," ",C2)
Then I copy and paste the values from "E" back into "A"

So I take raw names that have extra spaces and middle initials - I seperate ou tand get first and last names and then concatnate them together. What I am wondering is if I can use a macro that can do all of this in place so that I don't have to use so many columns and copy and paste these formulas. Since I don't know how many names are in each file I need it to do it all the way down column "A" untill the cell is blank.

I am sure this is simple, but my knowledge of macros doesn't go much past recording them.

If anybody can show me how to do something like this it would be greatly appreciated, as it would save me alot of time since I have to repeat this process on many workbooks.

Thanks for your time,

Emily Suskovich

I've never been here before, I assume I pay via paypal?? Sorry...please enlighten me if I am wrong!!

I have two files to combine (repeatedly).

One is already in excel and contains headers in row 1. All that interests me in this file is column A and column P (both numbers only).
The second file is a comma separated text file with no headers. From this file I care about columns B and C (containing numbers, 6 decimals), and column E (number).

The first file is usually 5000-10000 rows in length while the second is around 200 rows long.

I need to create a new csv file containing:

B,C,A

for only the rows in file number two (in other words, I am extracting values from the big file to match with my little file).

column P and E are identical and used to match up the entries.
**keep in mind all 6 decimals in B and C need to be retained**

I don't care how the new csv is created, a little stand alone program or a macro, whatever. As long as it is automated. I want to pick my two files and kick out a new one with the extracted values.

I'll pay an extra $10 if you can give me a decent help file to explain to me how you did it so I can maybe learn something along the way.

I have a report that keeps track of:
Product #, Customer #, Qty Sold for every invoice on a specific date

I want to add/SUM all the (Qty Sold) for all Like (Product #'s) regardless
who they were purchased by. To give me my total units sold.

And also be able to SUM the (Qty Sold) for each specific Customer. To give
me that Customers Total Useage.

Hi, I'm using Excel 2000. Trying to combine contents of one column with another (one is alpha, the other numeric - this is for Product Codes for an Inventory list). The macros I have tried just keep reverting to the first position and hold the first selected data. I have punched the Relatice Cell Reference button on the Stop menu but makes little difference. I thought I had tackled this before but maybe I need a later version of Excel?? Any ideas out there would be appreciated, Paddy


No luck finding an answer? You could always try Google.