Extract Comments To Multiple Rows

Nov 2, 2009

I have been provided a spreadsheet which has a Quantity column "H". In this column is the quantity of the items and a note containing the serial numbers of the items. The note has no real format. Here are some examples:

Example 1: Serial numbers: 161702, 161722, 161740, 161741.
Example 2: Dec 2006: s/n 63194
Jan 2007: shipped 1 widget, 52480
Example 3: Sent in 2004: 717, 718
Apr 07: shipped 63522 and 63524.
Oct 30, 2007: K. Grande reported only two widgets onboard, 63522 and 63524. 717 and 718 are missing.
Nov 2007: 160302.
Dec 14, 2007: shipped 161093.

There are thousands of serial numbers on hundreds of rows like this. I am looking for code that would copy a new row to another sheet for each serial number in the comment with the serial number placed in column "J". I don't know if the extraneous text can be filtered out, but if I can at least get everything on a seperate row, I can sort/delete what I don't need a lot faster than doing this manually.

In have uploaded an example with before and after sheets. The After sheet is what I have done manually so does not match the examples I used on the Before sheet.

View 6 Replies


VB To Extract Comments And Value To New Sheet

Dec 6, 2009

I would like to use a macro to automatically extract the comments in Sheet 1 ( those comments are Customer Names and Their addresses ) to a new Sheet 2 which will print shipping labels.

I have manually created the first three labels on Sheet 2 to show what I want to accomplish. The tricky thing is, that some Customers receive 2 or more artworks...

View 11 Replies View Related

Extract Comments To Adjacent Column

Feb 21, 2008

I have a substantial schedule that has been completed by a 3rd party who has used the comment function for important data. Can anyone suggest how i can utilise a macro to extract all of the comments into the adjacent column?

The comments are currently against cells in column E and i'd like to extract them to blank cells in a newly inserted column F.

View 9 Replies View Related

Extract A Fill Pattern From A Cell Comments Field

Jun 21, 2008

I have a file where comments are used for some cells. The user does not insert any text into these comments fields, but uses the comments feature to display pictures.

A picture is used for the fill pattern of the cell (inserted through fill effects) and that picture is what is displayed when someone moves the mouse over the cell.

The "fill pattern picture" becomes part of the excel file and my question is how can I extract this picture and use it somewhere else.

View 9 Replies View Related

How To Hide Rows That Contain Comments

Aug 14, 2009

With the help of Venkat1926 I established a macro that successfully hides a number of rows that are unrquired (based on dates):

View 14 Replies View Related

Adding Comments To Many Rows In Vba

Feb 15, 2007

Is any way to add automatically comments in VBA

Some combination of "ctrl" with something else.

View 3 Replies View Related

Concatenate Comments For Rows Above Each Record ID

Sep 29, 2009

Unfortunately my strengths do not lie in VBA for Excel. But I have a problem which needs resolving using a macro because this spreadsheet scenario happens often.

I have three columns (Record ID, Comment, Results). The Results column is added to capture concatenation of the Comments column. Using VBA, I want to concatenate Comments for each Record ID in the Results column on the row for that Record Id where the rows above have no Record Id.

Each comment should stack in order with a carriage return between them. This should happen for each row where a Record ID exists and continue for the length of the spreadsheet until it finds the last row with a Record ID and should stop after concatenating its results.

View 8 Replies View Related

Seeing Cell Comments On Sheet With Hidden Rows

Jan 3, 2010

I have a spreadsheet where i have security set to prevent a user from selecting locked cells. However when a user selects a cell that is in a row at the bottom of the vissible area the comment text can not bee seen. What i need is to determine what the bottom vissible row is and use that to compare the row number of the current row and thus decide if i should scroll down to improve the visibility of the help text for the cell in question.

View 3 Replies View Related

Attach Multiple Comments To Dropdown Menu

Apr 2, 2013

Is it possible to attach multiple comments to the different choices in a drop down menu?

View 1 Replies View Related

How To Give Comments To Multiple Cells At A Time

Feb 4, 2012

columns consist of 1,2

I selected only 1 value of cells

I want to add comments to all the 1 value cells by selecting all 1 by shift + ctl +down

I can put same comments to all the cells?

If you want to have the same comment applied on many cells you could apply it to a single cell, then use the copy and paste special tool bar commands (under Edit) In Paste Special select "Comments" but value is going of that cell.

View 5 Replies View Related

Multiple Ccolums/rows To Get Data From Multiple Columns/rows (vlookup)

Jan 15, 2010

I have created a spreadsheet to show some reports and I wanted to serch for some datas which overloops themeselves. If you can have a look at a test file I attached you will see the full picture. I have 2 tables, where the 2nd one is on the right side of the 1st one. 1st table:..............

View 3 Replies View Related

Prevent Copy / Paste Cells With Comments Or Allow Paste But Do Not Paste Comments

Feb 4, 2014

How would you prevent the copy/paste of cells that have comments?

Also, how would you allow cells with comments to be copied and pasted without pasting the comments?

I also have an aside question about the forum advanced search. When searching for multiple search words, how would you type the search to include all words, for example, "prevent" & "paste" & "comments".

View 7 Replies View Related

How To Extract Number Of Rows

Jul 18, 2012

I'm working on an inventory spreadsheet that includes a user form to gather the data, inputs that into a new row and then I can't get the formula that counts the total inventory to include the newly inserted information.


Private Sub AddToInvButton_Click()
Range("C9").Value = Me.BrandText.Text
Range("D9").Value = Me.StyleText.Text
Range("E9").Value = Me.VitolaText.Text
Range("G9").Value = Me.RemainingNum.Text


I know the last Range statement and MyCount are off, but that's my stab at it to try and show you what I want it to do. I want it to count the number of rows between G8 and the end and use that number to modify the cell that has the simple =sum(G8:G-whatever the last number is minus 1 - since the very last row is the one where the sum formula is)

View 7 Replies View Related

Extract Even/Odd Numbered Rows

May 15, 2008

What is the fastest way to extract data in all the even numbered rows? Attached is the sample, and shows what i would like to do.

View 4 Replies View Related

Extract All Rows With A Range Of Zip Codes

Aug 4, 2009

Is there a simple way to find all rows in a 25,000 row worksheet, that contain zip codes from another, smaller, worksheet.

View 9 Replies View Related

Extract Data From Rows Into Columns

Oct 15, 2009

I'm using Excel 2007 and I need to extract values from rows from a data dump into columns. Here is sample data (this is dummy data, but the format is the same): ...

View 13 Replies View Related

VBA Macro To Extract All Unique Rows

Oct 28, 2013

I have the following table A




[Code] .....

I would like to extract all the unique rows from the above table so the outcome will be



[Code] .....

However I can't think of a simple macro to do it.

View 2 Replies View Related

Extract Unique Rows Only Into Different Worksheet

Jul 3, 2008

This is just a screenshot of my huge data of over 60,000 rows. Owing to the restriction of HTML Maker, I am just showing in less than 30 rows in this screenshot.

I need to extract only the UNIQUE ROWS depending upon the column called "Unique Code" to another worksheet. A particular row or a record is repeated as many as 90 times in this database. I need to extract the whole row which is unique depending upon the column C which is "Unique Code".

I have tried the Advanced Filter option a couple of times but it does not seem to work. Also, the Auto Filter option is not versatile for such amount of data.

View 9 Replies View Related

Extract Matching Rows From 2 Files

Jun 2, 2007

I had a VBA excel question. I have 2 excel files. Each file has a column on product SKUs. What I need is a VBA function that compares the 2 key columns and extracts the matching SKU and saves them in a 3rd excel file. That is the 3 file should contain only the SKUs that are in both of the 2 files.

View 9 Replies View Related

Extract Rows From One Sheet Into Another Based On Certain Criteria?

Dec 21, 2013

How can I extract rows from one sheet into another, based on certain criteria?

View 1 Replies View Related

Extract Data In Rows And Transpose To Columns?

Feb 13, 2014

I am struggling with an Excel Database, to make it "cleaner". Here is my problem. My database looks something like that:

Column A Column B Column C ... Column H
ID Age Date of Birth ... Language
00001 14 01/01/2000 ... English
00001 14 01/01/2000 ... French
00002 14 01/01/2000 ... English
00003 14 01/01/2000 ... French
00003 14 01/01/2000 ... German
00001 14 01/01/2000 ... Spanish

Basically, Columns B & C will never change for the same ID, but columns G, H and others contain data that is different from one row to the other. What i wwould like to do is having unique values in Rows, with Languages displayed in Columns. The database would look like this:

Column A Column B Column C ... Column H Column I Column J
ID Age Date of Birth ... Language 1 Language 2 Language 3
00001 14 01/01/2000 ... English French Spanish
00002 14 01/01/2000 ... English
00003 14 01/01/2000 ... French German

The challenge is that I would need this to be done with formulas only, not using any kind of code. Deleting duplicates manually after "cleaning" the database should'nt be a problem. I tried a formula found on this forum, but i couldn't manage to make it work. The formula looked like this:


View 2 Replies View Related

Extract All Matching Rows With Active From A Database

Jul 17, 2009

Heres what I need:

On the 'values' worksheet (first one), a formula in cell M2 that will search the worksheet 'oc_users' (second one) for any row containing "Active" in column G, these rows will return the corresponding email address in column A of the same worksheet. Skipping "Inactive" rows.

End result: anyone with an active status in oc_users will have their email populated in the 'values' worksheet.

View 9 Replies View Related

Extract Unique Data From Rows To Columns

Apr 19, 2013

I have this data

1 355
1 243
1 567
2 456
2 443
3 889
3 890
3 123

and need to sort it in columns like this

1 355 243 567
2 456 443
3 889 890 123

View 2 Replies View Related

Extract Data In Each Column To Rows In New Worksheet?

Oct 10, 2013

I have a spreadsheet with company details in a worksheet. Each company details are in a new column. Like the following example:

company name
company name
company name


i basically need each of the bold heading in the first row of the new worksheet. Each company details will then need to be moved into a new row with the corresponding data under the correct heading column. Not all the companies have all the data for each heading it would be fine to have "none" value or blank in this case

View 2 Replies View Related

Macro To Extract/insert Data Then Delete Rows

Jul 25, 2008

I am working with a spreadsheet generated from software that keeps track of fuel usage for a large fleet of vehicles. The data comes out looking like the snapshot below.

******** ******************** ************************************************************************>Microsoft Excel - June Fuel Transaction Listing.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutA3=ABCDEFGH3  Transactions for  CUSTOMER ID: 0000CUST7   Sales        4        5        6Product summary for Vehicle ID   00001080       7        8Product Description  Transactions Quantity9        101 Unleaded  3 57.60  GL11        12Hose summary for Vehicle ID 00001080       13Site ID HoseGradeProductTransactions Quantity140001 2113 57.60  GLJune Fuel Transaction Listing [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

I am trying to get the data into a more convenient format for analysis. I need a macro that will:

1) Take the text "Product summary for vehicle ID 0000****", extract the last 4 digits of the text, and paste it where the 1 is under the Product heading (a10). Those digits are the actual fleet number, and I need to separate them out from the rest of the text. The digits will change for each vehicle, so the macro should just move down the spreadsheet doing the same thing for each instance (the setup you see is repeated for every vehicle).

2) Once the first goal is accomplished, I would like the macro to then go back through and delete every row except for the rows with the pertinent data in them. So this means I would only want one row per vehicle and all rows would line up directly below each other like demonstrated below.

******** ******************** ************************************************************************>Microsoft Excel - June Fuel Transaction Listing.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutA10=ABCDEFGH101080 Unleaded  3 57.60  GL111081 Unleaded  6 84.70  GL121122 Unleaded  5 47.00  GL131182 Unleaded  8 95.80  GLJune Fuel Transaction Listing [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

View 9 Replies View Related

Extract Multiple Records From A List

Feb 9, 2009

I'm trying to find a way to extract multiple records from a List. I'm looking, I guess, for the multiple-record extract version of dGet().

View 2 Replies View Related

How Do I Extract Data From Multiple Workbooks Using VBA

Oct 29, 2009

I am trying to create functions in VBA and I need to extract data from multiple workbooks. For example, is it possible to sum data(numbers) contained in multiple workbooks using VBA? If so, how do I create that function in VBA.

View 9 Replies View Related

Extract From Multiple Text Files

Aug 17, 2008

I have about 50 - 60 text files and I need to find certain values, namely Name, Account No, total amount under Portfolio Value in the text file and copy these values to a worksheet under column: Name, Account and Portfolio Value respectively. All new entries are paste one row below the existing data.

Some of the text files may not have any data in it or may not have the Portfolio Value as the monthly transactions may occupied 2 or 3 text files. Some text files may have 2 Name in it and there will be 2 Portfolio Values in it which I will need both to be copy to the worksheet.

I have attached both the Excel file and the dummy txt file.

View 3 Replies View Related

Extract Data By Multiple Criteria

Jun 20, 2007

I have an excel sheet which has 200 fields and 1000 rows, now I want to make summary of them, so I need some fields to be extracted from those 200 fields to another sheet on multiple criteria, Like Category, First Name, Last Name, District, Village, Date and etc.

View 9 Replies View Related

Extract Data From Multiple Sheets Into One

Aug 6, 2008

I am running into at the moment is that where the Select Case is checking if the sheet name starts with the initials and project number, it doesn't seem to recognise if it is correct (and therefore perform the actions). I have stepped through the code and when I use the immediate window to manually check:

? ws.Name Like "TA0632*"

I get True as an answer, but the code goes on to the next case as though it is false. Here is the code I have so far, which I'm sure can be trimmed down loads:

Option Explicit
Dim currCell As Range
Dim c As Long
Dim r As Long
Dim rng
Dim ws As Worksheet
Dim skp As String
Dim LastColumn As Integer

Sub Breakdown()
Dim t
t = Timer
For Each ws In ThisWorkbook.Sheets
Debug.Print "Current sheet is " & ws.Name

View 2 Replies View Related

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