Segregate Data Based On The The First String Of Each Security Description

Jun 12, 2009

a macro that will segreate data based on the the first string of each security description under the heading Security description and then sum the total on a separate row in the total column.

Starting row hearder in sheet "Raw_Data" start in row 6 and i would require the same in sheet "Result

Sheet "Raw_Data ...

View 9 Replies


ADVERTISEMENT

How To Segregate Amount Based On Validity

Apr 7, 2012

I have amount, Activation date & Validity in days. I want to segregate the amount on days wise.

E.g. acgtivation date is 1 mar, validity is 45 days and amount is 900 then it will show 2 in each day from 1st mar to 14 Apr and on 15 apr it will reflect 0.

View 1 Replies View Related

Macro To Segregate One Column List Into Three Columns Based On Condition

Nov 21, 2012

Lets say we have data in Column A, B, C and D and no row left blank. In the column A no cell left blank however in B, C, D any one cell only contain a value in that row. If B10 has any value in it then C10 and D10 are left blank (not empty). I want to segregate the data in Column A based on the value in B, C or D. So this one column data ( that is Column A) will split into three column. this segregated data to be put in E, F and G.

Wherever Column B has any value that's greater than zero content from the column A from the same row should copy to the E, Wherever Column C has any value that's greater than zero content from the column A from the same row should copy to the F, Wherever Column C has any value that's greater than zero content from the column A from the same row should copy to the G.

View 4 Replies View Related

Segregate Data From Particular Column Of Master File

Nov 28, 2013

I need to segregate a data from a master file with a particular column as a main.

for eg:- i have customer details with name in a column
address in b
mobile in c column,stat and other details in other column.

I want to segregate data according to state in different excel so how can i do the same.

View 3 Replies View Related

Insert Columns Based On Tab Description

Apr 14, 2009

I have a macro that inserts a blank column for every sheet in the workbook. The problem i have is that i only want a limited number of columns inserted. I only want a column to be inserted if the sheet tab has the name "detail" in it. I have tried for hours to get this to work, but i keep getting errors. Here is the code i am using.

View 4 Replies View Related

Extracting A Numeric A Specific Numeric String From A Description Cell

Oct 22, 2009

I am trying to do is extract the volume size of products in 'ml'
from 10k plus products from a description field cell.
this description field could also contain the weight of the product in grams
so I cannot just do a search for a numeric string ,
it has to be associated with the milli-litres statement .

is is possible to do a sort of ' *ml ' search and then select and copy to another cell ???

View 9 Replies View Related

Message To Appear Prior To Printing Based On The Description Choosen

Mar 22, 2008

I have a list of products that I want a message to appear prior to printing based on the description choosen.

Product descriptions are choosen in D25:D34 via a drop down.

My wild cards are SWING GATE and DOUBLE SWING GATE, I want to use wild cards because of the many different sizes of each gate.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If Range("B" & Target.Row) = "swing gate" Or Range("B" & Target.Row) = "double swing gate" Then_
MsgBox (Range("F5").Value) & ", Please include chain and locks with order", vbOKOnly, "Chain and Locks"
End If
End Sub

View 9 Replies View Related

Adding Column With Description Based On Preset Codes

Jul 13, 2006

First it should Insert a Column to the left of A. Then it should go to column B and search for the number 99 and delete all rows after it. In column C I want it to do the following formula =vlookup(b2,descriptions!$b$2:$c$250,2,false) and have it copied all the way down to the end of data.

Next I need labels added to the tops of the rows
Next I need the description columns in C to be copied to column I
Finally, beginning at J2, I would like the formula (e2 * g2)/100 entered to the end of data. Attached is sample data.

View 2 Replies View Related

Auto-Populate Items From Master Reference Chart Based On Job Description

Dec 3, 2012

I have attached the sheet :

Certain job descriptions require certain training. Drivers needs these two particular trainings and an office employee only needs that training...

I have a reference sheet with what trainings are required for what job. I then want the next chart with each employee name and subsequent job title to have the required trainings automatically checked. (I can take care of the conditional formatting after that).

Job Desc.xlsx

View 5 Replies View Related

Looking Up Data And Match The Description And Then Insert The Value

Jan 21, 2008

I have a table I down load from SAP with the following headers;
Route, Description, DChl, YF21 (SD),YF31 (SD),YF21 (MM),YF31 (MM),YF10 (MM),YF11 (MM),YF12 (MM).

All I need to do is look up and match the Description and then insert the value (they are percentages) found under the columes YF21 onwards.

I have tried VLOOKUP until I am blue in the face and cannot get it to work.

View 9 Replies View Related

How To Segregate VBA Code

Aug 1, 2014

I have a Userform project in Excel (naturally) and am nearly at completion. However my code runs to over 3000 lines. What is best practice in terms of how to structure it? At the moment it is all "behind" Userform1.

I'd like to partition my code into different modules according to type (i.e. Subs, Events, Formatting, etc). I tried this at the start when I was coding but I couldn't quite get it to work - I thought using the "Public" prefix would work? I then kind of just progressed anyway but now I am at the point where I need to structure it before going further.

View 5 Replies View Related

Select Based On Partial String Then Delete Based On Full String?

Jun 13, 2013

Working with a scheduling report and trying ultimately to get it down to a line item report with the associate information and their earliest start and latest end for the week. Already made a lot of fixes to the formatting involving junking empty cells and trash data, but running into a road block on some of the trash data.

Here is the format of the report at this point. Names have been changed to protect the innocent.

Agent: 2366 Bacon, Kevin

Date
Start
End

[Code].....

So what I need is something that will iterate through the report...such as an while and find the cells in column A that start with "Agent:" It needs to compare that cell to a stored value to see if this "Agent:" is a repeat. If it is then it needs to delete that row and the next one and shift up. If it is not then it overwrites this "Agent:" with the previous one in the stored value and continues the while.

I know what I want to do...but not shure on the code cause I am not great at VBA.

Oh...if it matters probably need to allow for about 10k line items to iterate through...right now report is at 6k...but allow room to grow.

View 6 Replies View Related

Search And Segregate Item Occurrences

Apr 3, 2012

I'm having trouble trying to setup a spreadsheet for work to do production scheduling. I have a temporary thing working so far but, but there is a minor hickup with certain products.

Products A, B & C can be processed normally on their own and each occurrence is identified with its unique serial number and can be traced through the schedule. The problem is that there has to be 3 occurrences of Products E & F before they can be processed in a single batch (They're smaller and its more efficient to process them together).

I'm struggling in that I can't process 1/3 of product E (Serial no. xyz123).

I would need to be able to identify 3 of these products, batch them together and follow them through the schedule.

Plus, if there was 8 of product E to be made, I can only process the first 6 which leaves the last 2 out.

View 1 Replies View Related

Auto Populate Invoice (including Description) From Data Sheet

Dec 5, 2012

creating an Excel invoice that would auto-populate from another Excel worksheet or file with data. The information that I would want to include are:

Company name
Name (person)
Email address

Start date
End date
Promotion description
Number sold
Price per item
Total charged

View 1 Replies View Related

Macro Security (saying That The Macro Security Level Is Too High)

Nov 18, 2008

I have a sheet that will not let me use macros. I can record them, but when I go to use them it says that the Macro security level is too high. I change it to Medium or Low but it doesn't make a difference.

The same spreadsheet works with Macros on another computer, but not my main one.

View 5 Replies View Related

Summarize Data Based On Partial String Matches

Jun 30, 2006

I have two questions:

a. Check the code below:

Dim news1 As String, news2 As String

news1 = "new"
news2 = "polygon"
Dim countie As Integer
For buddie = 2 To b1.UsedRange.Rows.Count
'If b1. Cells(buddie, 1).Value Like "new*polygon" Then
If b1.Cells(buddie, 1).Value Like news1*news2 Then
countie = countie + 1
n1.Cells(buddie, 10).Value = "test"
End If
Next buddie

I have 2 strings, news1 and news2, i need to use the like function to check the occurance of these two strings in all the cells, and just for testing purpose, im printing 'test' it out in another excel sheet.

How do i make that work? the commented line shows what exactly i want, only that i dont want to hard code the string values.

b. If i have a value in the cell:
/new/blahblah/anycra/polygon
how do i split it so as to assign two variables to have 'new' and 'polygon'.

View 9 Replies View Related

Excel 2007 :: Security Alert - Data Connection Message Every Time?

Dec 20, 2012

I open a spreadsheet or workbook that has links to other workbooks I am notified by the message bar that content has been blocked. I click Options > Enable this content > OK. Even if I don't make any changes I'm prompted to save changes when I close the file. If I hit Yes or if I hit No, I will still be prompted to enable content in the message bar the next time I open the same file.

I have changed the External Content settings in the Trust Center to "Enable all data connections (not recommended)" and "Enable automatic update for all workbook links (not recommended)" but I still get the messages.

My Message Bar is set to "Show the message bar in all applications when content is blocked" because I read on Microsoft KB that the other option of "never show information about blocked content" will still block the content, just not tell you about it, which doesn't fix my issue.

The files I'm opening and the files linked to and from them are all on the same shared drive on a file server in the office. Is there a way to tell Office '07 that our file drive is a trusted source by default?

View 2 Replies View Related

Vba Code To Extract And Clean Data Based On A Set String Ending

Dec 5, 2013

I would like to extract competition naps from the competition entries and then remove the string ending "nap" from the data so it can be pasted to another sheet in it's 'clean' format.

on the example sheet column B will always be the first column and the range will extend to either G,H or I (always the max range as there are always 6 to 8 races)

i would like the code to search through these columns of data and find the cell ending in 'nap' then to return this in column i, once done remove 'nap' ending from both the source cell and column i.

once done to then go through all the rows and do similar

the end result would be all naps returned into cell j and all the 'nap' endings through the data range B to I (max) to be removed to leave the horses name only.

in book 3 the first row nap was sommersturm so i have shown the outcome i would like with the nap ending in I1 removed and the horse name returned in J1 again minus 'nap' ending.

the data will always be clean with no leading/trailing/excessive spaces and always be lower case too. sometimes a space is not in between horse name and nap but it's always last 3 characters i want removed still.

View 4 Replies View Related

Generating Random Number String Based On Alphanumeric String?

Aug 14, 2014

Wondering if it is possible to generate a random 4 digit number based off an alphanumeric string?

Example;

Cell A1 has 123XVF1234
Cell A2 has 321AFW4321

In B1 I would like to have a 4-6 digit number that is generated based on the alphanumeric data in Cell A1 (and so on down the list). If that is possible, I would also need to be able to convert back the 4-6 digit number back to its original alphanumeric value

Example;

If B1 returns 643562 it would need to be able to be converted back to 123XVF1234

View 7 Replies View Related

How To Extract Qty Min/Max From Description

Jan 31, 2009

Example: Table ...

View 9 Replies View Related

How To Combine The Description In One Line

Jun 17, 2014

Attached is a file containing stock codes and description. The stock code is repeated but i would like to have one line description per stock code.

View 4 Replies View Related

Lookup In A Description (color)

Mar 13, 2009

I have a column with a description that includes color in the description, I want to sort by color with breaking up the description, is there a formula that will look at the description such as "Am Cannoe black tecan" and in the cel next to it come back with "black". Then I would be able to sort by color column, otherwise I would have to text to column and break up the description, etc,,, ect....

So column a1 has the description, I want a formula that will put in column b1 "black" I have 3 colors, so I can do one at a time or add to same formula.....

View 6 Replies View Related

Sum Turnover Where Name Is PART Of The Description

May 14, 2009

I am looking for a way to use the sum.if formula, combined with the find.spec (I am not sure if this is the correct formule, at the moment I only have the Dutch Excel version, it is meant to find a word as part of a cell)

The part I am struggling with is how to find the correct cells to "sum" when the criterium is part of the cell contents. e.g. Paul is the description in am looking for in "Paul is riding his bike" If so, then add the turnover to Paul. I have made a demo to clarify what I mean.

View 4 Replies View Related

Split Description Into 3 Columns

Dec 9, 2009

I need help to split text (shown below) into 3 columns, now all text is in one cell.

e.g.,

HIPP 1 PLUS PROBIOTIK 600 G MILCHNAHRUNG PULVER 1607000286

I have over 30,000 rows of data which contains different number of spaces within a cell. Please see attached file.

View 14 Replies View Related

Pull Down Option Description

Jul 29, 2009

I have created a pull down menu but cannot figure out how to add descriptions with them. The items in the pull down menu are codes instaed of making people look up their definition in a printed out table,I am hoping to figure out how to make it so that as people scroll through the pull down menu a corresponding definition for the "code" listed appears.

View 9 Replies View Related

Find First/Last Value In Row & Return Corresponding Description Above/Below

Apr 8, 2008

I'm trying to find

1) the last and

2) first values in a time series of data in which the the data points are scattered all over the place

AND I'd also like to

3) get the corresponding year ( Heading name) for both the

3.1) last and the

3.2) first data point

I've found solutions for all but 3.2. Thus the question remains:

How could I lookup the heading description for the first value on a row?

example:

row #; lookup; year1; year2; year3; year4;
1; year3; ; ; 23; ;
2; year2; ; 21; ; 53;
3; year1; 12; ; 45; 2;

In case it helps anyone looking for same information or providing help to solve my problem 3.2 the other solutions I've found are:

1) lookup last value in row

i) Find Last Number In Row & Return Heading
=LOOKUP(9.99999999999999E+307,R5:AI5)
... also an additional VB solution

ii) Find Last Number In Row & Return Heading
=INDEX(M12:M500;MATCH(9.99999999999999E+307;M12:M500))
... page also includes solution for 2), below

iii) Find Last Number In Row & Return Heading
... 2 VB solutions

2) Lookup first value in row
Find Last Number In Row & Return Heading

=INDEX(M12:500,MATCH(TRUE,INDEX(M12:M500<>0,0,0),0))
... page also includes solution for 1), above

and

3) Lookup heading of last populated cell in row
Find Last Number In Row & Return Heading

=LOOKUP(2,1/(I9:CN9<>""),I$5:CN$5)

4) Could I e.g. modify the above to lookup the year of first value?

View 4 Replies View Related

How To Display Description Of Options (list)

Feb 24, 2014

Any way to display the description of options (list) which in this case is a numbering code (like ECG201) in a data validation cell.

The length of the cell is not long enough for the users to know the appropriate description of the selected lists. I am now thinking there should be a way to display the description of each item so that users will know that ECG201 means "International College of Excellence", for example, instead of having to go from one worksheet (area) to another to know what an option means.

View 1 Replies View Related

Description Column In Pivot Table

Aug 10, 2009

I often use pivot tables to summarize accounting data. I wish to summarize the data by account number, but also wish to display the account description next to each account number. Both the account number and account description are separate columns in my original table of data.

I've always managed to do this by the use of lookup formulas after the formation of the pivot table in a column outside the pivot table, but it would be preferable to have those descriptions as part of the table.

If I designate both the account number and account description as row labels, they land on two different lines.

View 7 Replies View Related

Excel - Formula Map With The Description Of Another Sheet

Jul 3, 2014

I'm trying to map the cases present in the sheet 1 to Sheet 2. Here the sheet2 I have highlighted the rows yellow color that needs to be updated by using excel formulas.Here the sheet should be updated with the description below mentioned along with the formulas..Highlighted cells in the sheet2 is B,C,I,J,T,U. I have designed the below condition in the same order

B cells should be updated with the reference of Sheet1 with the below condition:

Identify the "(B Value)"Claim with below condition (D Value)

C cells should be updated with the reference of Sheet1 with the below condition:

Verify whether (I Value) Mapped to the below Coverage in CAS (K value)

C cells should be updated with the reference of Sheet1 with the below condition:

Verify whether the Incident (Q value)is below for the Coverage (K Value)

J cells should be updated with the reference of Sheet1 with the below condition:

Verify the the Exposure type(P) is below for the Coverage (K)

T cells should be updated with the reference of Sheet1 with the below condition:

Verify the cost created the reserve coverage (K value) is below (N value)

U cells should be updated with the reference of Sheet1 with the below condition:

verify the line category of the payment done on the coverage

(X value of all the conditions for Sheet1 value)

View 1 Replies View Related

User Defined Function Description

Nov 25, 2008

I have created a custom add-in with custom functions and am trying to make it user friendly for other users. By running the following macro I can add functions to different categories, but I was wondering if there was a way to do this automatically so that anyone that adds this add-in will have the functions show up in the proper category without having to manually run this macro.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved