Extract And Use Information In A Comment Box

Jul 22, 2009

My user has data in a comment in a cell that provides additional information about the data in the cell. He does not want to have to retype that information into another spreadsheet but wants it to automatically populate.

For example:

Column Headings: A1 = Tardy; B1 = Absent; C1 = Detention

Data in the following cells: A2 = 2; B2 = 1; C2 = 3

Comments are: A2 = Smith - 10 min, Jones - 5 min; B2 = Adams - Sick; C2 = Brown - Talking, Green - Talking, Gray - Sleeping

He wants another workbook that has a column for each name in three separate tables, 1 each for Tardy, Absent, and Detention. He wants the Tardy table to show 10 min under Smith, 5 min under Jones, etc.

Is this at all possible? I will say that I tried to get him to change his spreadsheet so that he inputs the data into the three separate tables then summarizes it in the sheet he presently has but he cannot change the original sheet. It is a shared sheet by many of our office locations and changing it is not an option.

View 9 Replies


ADVERTISEMENT

Get The Information Of The File Comment.

Oct 16, 2007

I need a macro to get the info written in the Comment field (In the file properties field). Attached is a pic to explain a little better.

View 2 Replies View Related

Extract Contents Of Cell If Greater Than Zero To A Comment

Dec 30, 2009

I am trying to extract contents of cell to a comment.

Column K is Overtime Hours
Column L is Regular Hours

I have managed to create the following macro that will copy the contents of a cell in Column K and put it as a comment in Column L. But I am needing the macro only to create a comment if the value of the cell in Column K is greater than 0

View 2 Replies View Related

Extract Information From Table

Apr 1, 2009

I am not sure how would I go about finding the last data entry in a table and using formula to extract information. Attached excel 2007 file to better understand. Need formulas for cell B20 and E20. You can use column A as a reference if it is easier as this column is counting the number of entries and the next value will simply be a +1 to the last value entered in column A(or 75 in our case).

For Cell B20: Need to calculate the days difference between todays date (Cell A20) and the last entry date(in this case B5, this will change as new data will be entered). A subtraction of two dates would suffice - my problem is that I do not know how to find the last entry on the table and use it. You have to remember that table gets updated and new entry will be added so then cell B20 should give the difference between A20 and the last date entered.

View 2 Replies View Related

Extract Information From Template

Sep 17, 2009

i have 2 sheets, one is a database sort. and the other sheet is a template tat i had design. i have inserted a filter to the database sheet that i wan to extract info from my template (diff catergory). but shows nothing,

View 10 Replies View Related

Extract Outlook Information

Oct 18, 2009

Is there any way.. probably a macro which can extract the following information from a particular folder folder in outlook / PST into an excel sheet :

1. Sender
2. Recepient
3. Received date & time
4. Subject

View 9 Replies View Related

Extract Information From PDF And Convert To Excel

May 21, 2014

Is there any way to create a specific template that will extract information from PDF file and make it to an Excel File ? The Template would know each PDF and will know which information to extract to excel ?

View 1 Replies View Related

Vlookup Formula To Extract The Information

Jun 11, 2008

I am using the vlookup function accross two tabs. . . we'll call them TAB1 and TAB2. On TAB1 I have all my base information which I am referencing from, TAB2 is the sheet where i am using the vlookup formula to extract the information i need from TAB1.

Using cell B2 as an example from TAB2:
I used a vlookup formula in cell B2 and got the information from TAB1. The vlookup formula pulled, correctly, cell F17 from TAB1.

Instead of the formula reading "=vlookup(...)". I would like the cell to simply read =F17.

View 9 Replies View Related

Filter And Extract Or Search Cell Information

Feb 22, 2007

In column A I have various part numbers with alph-numeric characters. In column B I have a similar list. In column C I have the quantities for the part numbers in column B.

What I need is for say a macro or forumla to look at each part in column A and match it with the part in column B and in column D insert the appropriate quantity from column C.

I'm not sure if this falls under say a filter, extraction or search type of function.

View 14 Replies View Related

Lookup File: Extract Information From Sheet

Jan 21, 2009

My company use a program called Bartender which is a barcode printing program. Bartender has the ability to extract information from an Excel sheet which is really useful and prevents repetetive keying in of information. We have found that if you simply print the Excel sheet when Bartender next uses the file it says it is corrupt and simply copying the data into a new spreadsheet and resaving it as the same name does not resolve this issue.

View 3 Replies View Related

Extract Date Information, Disregard Year

Apr 9, 2009

I need to do an if then statement that takes the date (which is in the form of "3/31/2009" and only use the "3/31" info. Only its slightly more complicated than that, its a formula that links to another program. Basically, the current quarter end date is "curdate()" so if i want a cell to show that, i enter "=curdate()" and i would like to build an if then statement using that date but only using the month/date combo (only possibly dates are 3/31, 6/30, 9/30, 12/31) so I guess I could even use just the month, the problem would be to extract that information in a formula and build the if then statement around it.

So:
if its 3/31, show 1
if its 6/30, show 2
if its 9/30, show 3
if its 12/31, show 4

View 2 Replies View Related

Extracting Data: Extract Information From A Given Set Of Cells

Dec 4, 2009

I am trying to write a formula which will extract information from a given set of cells. The information format is

XXXX-YYYYY-ZZZZ

What I need to do is pull out the information which precedes the second. so in the above the answer would be XXXX-YYYY. I was thinking of using a mid or left, right formula till I discovered that the # of characters for X, Y and Z can be any length ie they could be

X-YYYY-ZZZZ
XXXX-Y-
XX-YYYY-ZZZZZ

So the formula needs to find the second dash (-) and extract information prior to it.

View 2 Replies View Related

Extract Information Before A Sign In Separate Cell?

Oct 24, 2013

How do I Extract information before a sign "/" in a separate cell ?

View 2 Replies View Related

Extract Information From A Cell And Reverse The Contents

Oct 20, 2008

All of the information is provided in one cell, which I can not change. If possible I would like to pull the names from the middle only (example: cell d11 only give me Adam Diaz and so on). Once I have pulled out the name, I would to reverse the name (example: Diaz Adam).

d11=ADIAZ01 Adam Diaz (adam.diaz)
d12=AELIZO02 Alejos Elizondo (alejos.elizondo)
d13=BDELUN00 Bobby Deluna (bobby.deluna)
d14=BFOREM00 Bud Foreman (bud.foreman)
d15=BGREGG00 Billy Gregg (billy.gregg1)
d16=CGREEN06 Christopher Greenwood (christopher.greenwood)
d17=CGREEN08 Cheryl Green (cheryl.l.green)
d18=DDOWNS01 Dickie Downs (dickie.r.downs)
d19=DFLORE03 Daniel Flores (daniel.flores3)
d20=DMENDE01 Donald Mendez (donald.mendez)
d21=DMORAL01 David Morales (david.morales4)
d22=DRODRI07 Domingo Rodriguez (domingo.rodriguez)
d23=DWASHA00 Daniel Washa (daniel.washa)
d24=EBROOK02 Earl Brooks (earl.brooks1)
d25=ECARRE00 Edelmira Carreon (edelmira.carreon)

View 9 Replies View Related

Extract Data Depending On Cell Information

Sep 11, 2006

i have 20 different materials which have codes assigned to them

wh = white
ivory = ivory
db = duck egg blue

etc etc

when i create an order some of the codes will be called up
i want to be able to put them codes plus the description into the worksheet Ideally into the header. if not call a1

View 9 Replies View Related

Extract Information From A Large Dynamic Excel Sheet?

Jul 29, 2013

i usually work with 3d and i export all my working in excel to summarise in a table.Now i came across an issue whereby i have a whole exported list for the whole project and i want to extract some of the info to make a new table.My master list is a dynamic one it keeps on updating from the project.

I have attached the sheet, there is one master sheet and 2 other sheets, PID10 & PID2...those sheets are break down table form the master sheet.

View 12 Replies View Related

Automatically Extract Information From Email Attachment To Master Sheet?

Jul 4, 2014

If a certain email comes into a mailbox with certain parameters eg subject and from criteria is met. Then extract the data from the email attachment (daily order) and add it to a master sheet containing all orders.

View 1 Replies View Related

User Defined Function To Extract Information From Closed File

Feb 7, 2014

Herewith I attached a sample excel file.

Structure file which i attached herewith include all the cost center details. normally it is a big file contain more than 1000 cost center details. Structure File.xlsx If i want a cost center name for some cost center code, i have to open this file and find a specific name.

What i plan is develop a macro function called "CC".

If I type =CC("D232") I need to print cost center name for D232.

But the problem is i don't want to open the structure file, without open that file, when i type this function i need a result.

View 1 Replies View Related

Extract Information From Closed Workbook Representing Data From A Country

May 22, 2013

I'm having a problem with getting a result from another workbook. The purpose is to extract information from a closed workbook representing data from a country (ie US.xlsm, UK.xlsm) into the open one (summary). I want to count the number of results in a column which are above a certain amount (in this case 100).

So this is my coding for getting this result

=SUMPRODUCT(--(('C:address[US.xlsm]Worksheet name'!$E$2:$E$30000)>100))

Which works no problem for getting the number of results in the E column above 100. my issue is that I want to be able to change the name of the country in a cell, and then get the results automatically from the relevant workbook. I've been using CONCATENATE for these purposes and EVAL (from MOREFUNC)... and I get #REF!

So if I split up the above coding into two cells "=" and "SUMPRODUCT(--(('C:address[US.xlsm]Worksheet name'!$E$2:$E$30000)>100))" (just to keep it simple) and then use CONCATENATE to combine them in a cell. Using EVAL on that cell gives me #REF!

I've tested SUMPRODUCT with EVAL and CONCATENATE on formulae like the one above which do not link to other workbooks, and they seem fine. and SUMPRODUCT and linking to a workbook also works fine in the first example.

So the problem is somehow coming from the combination of SUMPRODUCT, EVAL and accessing an external sheet.

View 4 Replies View Related

Excel 2003 :: Extract Information From Spreadsheet Database Into Another Sheet With One Trigger?

Nov 27, 2012

I used to use Excel many many years ago for all my basic business databases and pivot table reports (so was at a basic competency level) and want to use it again but it has been quite a while and I can't remember how to do the following.....

I want to build a database of sales and purchase info in say 'sheet 1' - let's say 30 different headed columns and then many lines of different information under each column.

In 'sheet 2' I want to create an invoice template of my own design (I can do easily) for printing.

This template will need to extract say 10 bits of information from a particular row and then put them in a certain place on this sheet.

How can I type in one piece of information in a cell on sheet 2 (say the invoice or line number of the database) and that will then trigger all the other needed information from that particular line in sheet one onto this template?

I know it can be done but for life of me can not remember the formulas to use for these other cells in sheet 2 based on the info put in that one 'trigger' cell

View 4 Replies View Related

Copy Contents Of Multiple Comment Boxes And Paste In Single Comment Box

Mar 13, 2014

how to copy the contents of multiple comment boxes and paste in a single comment box.

The big picture is that I have a number of cells with numerical values in and text in comment boxes. I want to be able to click a button to copy the contents of the comment boxes and paste them, along with the numerical value from the cell, into a single comment box, ordered by highest to lowest value within the comment box, then delete the original cells and comments.

I am quite new to VBA but have been coping quite well so far with information of the web and analysing recorded macros.

View 6 Replies View Related

Extract Unique Data From Information In Output Data?

Jul 2, 2014

I am trying to extract unique Data from the information in the output data in the file attached after i have extracted data based on criteria from the database sheet. i have noticed that because i extract data from the database sheet and from there i perform the extraction of the of the unique data , it is not able to extract unique isser name form the output sheet.

View 1 Replies View Related

Userform Data (allows Input Of Information And Then Deposits The Information On A Specific Sheet)

Feb 11, 2010

I have created a userform that allows input of information and then deposits the information on a specific sheet. I am looking for a way to have that information not only deposited on the specific sheet it is already set to but also to another sheet based on a selection made from a combo box.

here is my current

View 5 Replies View Related

Write Information Into New Row In Different Sheet But Keeps Overwriting Old Information

Apr 6, 2013

Basically I am trying to create a worksheet in which everytime I input information into Sheet 1, it is copied into Sheet 2. I want to have each entry in succession on Sheet 2 such that my first entry would be on Row 2, second on Row 3, third on Row 4, etc. However, everytime I put something new in Sheet 1, it just overrides the information in Sheet 2.

Basically I type in ticket sales in sheet 1, it calculates the prices and keeps a transaction log in sheet 2. But everytime I do a new ticket sale, it just overwrites the previous transaction witht he new transaction information. I've pasted my VBA below:

Sheet 1 VBA:

Code:
Option Explicit

'Form level variables - used in more than one event
Dim intAdult As Integer
Dim intStudentSenior As Integer
Dim intBalcony As Integer
Dim intChild As Integer
Dim sngAmountDue As Single

[Code] .......

Sheet 2 code:

Private Sub cmdSummary_Click()

'Declare Variables
Dim intCount As Integer
Dim i As Integer
Dim intAdult As Integer
Dim intStudentSenior As Integer

[Code] ......

View 3 Replies View Related

Pulling Information From A Column Based On Information In A Second Column?

Jan 27, 2014

Imagine I have 2 columns of information that look like this:

Column A
Column B

AS
Dog

AS
Cat

AS
Hamster

FT
Fish

These are my key columns. The letters are initials of people and the animals are the pets they're responsible for.

Now, I have 3 more columns that look like this:

Column D
Column E
Column F

These columns can go on for hundreds of rows.

What I want to do is pull out the information from columns D, E and F where the initials and pet match those in the key list, then paste that elsewhere (say to columns J, K and L).

So, for instance, the first entry would be copied across because, according to the key list, AS is responsible for a Dog, but the bottom entry for AS wouldn't because he was looking after a fish, and that pet isn't listed as one of his animals in the key list (Fish is listed alongside FT). Likewise, the entry for AH wouldn't come across because AH doesn't appear on the key list at all.

View 1 Replies View Related

If Comment Then End

Apr 25, 2006

I am trying to to get it to work so that if there is a comment already in the cell then it would skip to the next macro. Here is what I am trying:

'Mgr Voids
If Range("F9").Comment.Text = True Then End
ElseIf Range("F9").Value > 50 Then
MyInput = Application.InputBox("You Must Give A Reason For The Amount Of Mgr Voids For " & Range("F6"))
ElseIf MyInput = "" Then End
ElseIf MyInput = False Then End
ActiveSheet. Unprotect ("13792468")
ActiveSheet.Range("F9").AddComment
Range("F9").Comment.Visible = False
Range("F9").Comment.Text Text:="" & Chr(10) & (MyInput) & Chr(10) & ""
ActiveSheet.Protect ("13792468")
End If




The first part (If Range("F9").Comment.Text = True Then End) obviously doesn't work because I have no clue how it supposed to be... I was just hoping to get lucky. Any help would be appreciated.

Thanks,

Shawn

View 8 Replies View Related

Passing Old Value's To Comment

Apr 27, 2007

I am building a tool that uses Pivot Tables (so I can't use track changes) and I have found cool code that will insert timestamp and username in the comment when a change occurs. But I need to modify the code to also take the old value and put it into the comment as well. Here is the code to register the change into the comment:

View 11 Replies View Related

Force Comment

Jun 21, 2007

Is it possible to trigger a forced comment if a particular value is entered in a cell?

For instance, if the letter "F" is entered into a cell, I want the comment box is pop up, is this possible?

And lastly... is it possible to automatically group comments? for instance if a row has 6 comments, I'd like to combine all of them into a comment box on the same row.

View 14 Replies View Related

Comment VBA Code.

Apr 21, 2009

comment VBA code.. I use this VBA code for my comments:

View 2 Replies View Related

Autosize A Comment

Jun 3, 2009

my macro processes a lot of data and puts a comment in certain cells (several thousand of them). I would like to autosize the comments so that the text can all be read by default.

I found the following on the web:

View 2 Replies View Related







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