Bring In The Values From The Table

May 4, 2004

I would like to download historical stock quotes from yahoo and then bring them into a worksheet. I have used the Webbrowser control to bring in the Yahoo page but I have no idea on the code to use to bring in the values from the table.

View 9 Replies


Align Matching Values In Columns A And B And Bring Corresponding Values With Column B

May 15, 2014

I would like to align the matching values in columns A and B but I want the values that correspond to b in c,d and e to go with the column b value.

C D and E don't necessarily have a value in there but if it does it needs to move with B

View 5 Replies View Related

Bring Values Beneath Each Other...

Sep 17, 2009

I have a sheet made of 3 columns, every column has several rows, I am trying to bring the values of the second column beneath the values of the first column and then the values of the third column beneath them all. Attached are 2 sheets showing the current and required scenarios

View 4 Replies View Related

Bring In Values From Another Worksheet Only If Certain Criteria Met?

Jul 25, 2013

I have two spreadsheets in the same workbook, on the first worksheet I would like to bring in certain values from the other worksheet if certain criteria is met.

On the first worksheet

Column A = G/L account Number
Column C = Is where I would like the amount brought in from the other worksheet
column D = The percent number I would like to bring in from the other worksheet

On the second worksheet

Column A = G/L account Number
Column C = Amount
Column D = Percentage

The criteria to use to determine if the number should be copied to the first sheet is as follows

Column C on the second worksheet if the value is greater them or equal to 1,000.00 (positive or negative) and Column D the percentage is greater or equal to 10% (the cells for this column are not formated has percentages)

For example"

GL account number 4000000-0 the value in column C is 1500.00 and column D is 15.19 then both numbers would be entered into the first worksheet in column c and d foor the row where the gl account number is 4000000-0

View 9 Replies View Related

Bring Referenced Cell Values To Top Of Worksheet

Apr 18, 2014

ATTACHMENT: Order Form.xlsx

I am creating an Order form for my job in Excel. On this form, it displays the Top 100 items for sale. All the basic functionality of the form is working fine, my real issue is with the order summary tab.

On this tab, I would like for any Items with a Quantity on the first Sheet to transfer to a summary on the Second sheet.

So far, I am able to get the data onto the second spreadsheet. My final question is, can make the items on the summary sheet go to the top available row? Basically if I have items in row 3, row 7 and row 9 - I would like for the items to automatically fill in rows 3,4,5 respectively. (on the second worksheet)

I have seen people make this happen (on this board even) but for some reason, when I try using those formulas I do not get the results I need. I have attached the file to this post.

On the Tab entitled "Adv Piano" this the product list. On that tab, customers can put a Quantity in column G for the items they want to order and that item's details, price, and quantity will automatically appear on the 2nd tab, "Order Details" in columns I - L in the corresponding row (this is already done)

I need the information in the columns I - L on the "Order Details" sheet to appear in columns C - G on the same sheet, in the same order but to fill in towards the top with the corresponding quantities, item details and price remaining in the same row.

Order Form.xlsx

View 10 Replies View Related

Lookup - Bring Up List Of Multiple Possible Values?

Mar 25, 2012

I have a worksheet where data has been entered from a userform. For each entry, there is a separate reference number in the form of contract number-schedule number-machine type-cage number (e.g. 123-123-ABC-1).

The machien type will not always be known so the user will need to do a search for the contract number-schedule number and then bring up all the possible reference numbers.

For example this could look like:

I would like this list of all possible values to pop up.

what look up function would work and how I can do this?

View 5 Replies View Related

Search Criteria Bring Values Back To A Results Column

Apr 25, 2008

i have the following macro which finds instances of a search criteria and brings them back to a results column. what i need is instead of having the word GD: appear before each result i need it once at the begining of the results

LastRow = Sheets("design owb").Cells(Rows.Count, 10).End(xlUp).Row
Application.ScreenUpdating = False
For i = 26 To LastRow
Target = Sheets("design owb").Cells(i, 10)
With Sheets("design")
For J = 2 To 54
For K = 4 To 11
If Target = .Cells(J, K) Then
Sheets("design owb").Cells(i, 11) = Sheets("design owb").Cells(i, 11) + "GD: " & .Cells(J, 15) + " | "
End If
Next K
Next J
End With
Next i
Application.ScreenUpdating = True

View 9 Replies View Related

Reconstruct Data Table So That Column Headers Become Values In Table

Jul 15, 2014

I have a large table that I want to reconstruct. For simplicity sake, let's just says it's 3 rows (excluding headers) by 3 columns.

Item Description

Cheese Burgers

Hot Dogs


I want to reconstruct it so that the column headers become values in the table. The table headers are dates, in this case, if that gives clearer picture. So the new table would have 9 rows, (3 rows of data, excluding the header times four columns).

Item Description

Cheese Burgers

Hot Dogs

[Code] ....

The above example is sorted by date but I would be indifferent if it's sorted by the Item Description.

Is there an easy way to do this? Pivot possibly? Again, my data table is large: 36 rows x 181 columns. Using the copy/paste/transpose feature is pretty impractical.

View 3 Replies View Related

How To Sum Pivot Table Filtering Values In Other Table

May 12, 2014

how can i sum pivot table filtering some values in other table. if i change filter, sum is changed

View 1 Replies View Related

VLookup Table To Another Table That Has Multiple Values

Jun 24, 2014

Vlookup a table, to another table that has multiple values.



Look up table - need to return second coloum but not the first value, all the values?

View 2 Replies View Related

Finding Values In Table A And Transfering Them To Table B

Oct 25, 2013

I have this list of companies (about 50) in one work sheet. If a certain company has sales or costs it will appear under the company name, as either Products, Installation or Freight. It looks something like this:



What formula should I use the find the installation that belongs to that certain company? And not all companies has a line that say installation.

View 4 Replies View Related

Determining If Excel Values Equal Access Table Values

Jun 19, 2014

One aspect of my Excel-based project involves comparing the operator-entered part number (in Excel) to a predetermined list of part numbers in one column of an Access database table. Right now, my program is telling me that every part number entered in the spreadsheet (50+) does not match any part number in the database, which I've verified to be incorrect. I've checked that both the spreadsheet part number and the database part number are of the string datatype.

To the best of my knowledge, my looping logic seems valid and robust. To the best of my knowledge, there are no hidden characters in either the database cells or in the spreadsheet cells causing this apparent mismatch. I'm completely stumped at this point as to why my program doesn't detect any matches between the spreadsheet and the database table. Below is the Sub containing the code for checking that the part numbers match:

[Code] ....

This issue seems to be a hybrid issue between Excel and Access with (to me) more of the issue on the Access end.

View 11 Replies View Related

Macro To Bring Up A Pop Up Box

Mar 12, 2009

how I would go about writing a macro that would pop up if a value in a certain cell is greater than a set value. For example, if the cell b1 has a value of >50, I would want an alert box to pop up saying "Over Range". Ideally this should be automatic as soon as another value is entered into cell a1.

View 9 Replies View Related

How To Match And Bring Third Value With Index

Jan 23, 2012

I am trying to match and bring the third value with index formula in book 1

Book 1

View 8 Replies View Related

VLookup - Get Combobox And Bring Dates Up?

Jan 4, 2005

I have two tables which both have two columns. One column has dates in it e.g. 01/09/04 and the second column has a number in it. What i am wanting to do is create a combo box that, when i select the date from the list, it brings up the number (that is in the cell next to it) and puts this number into the cell next to the combo box.

I know how to get the combo box and add the dates to the list, but how to bring the dates up.

I have tried creating a combo box with the dates and then formatting it to create a cell link. This link then brings up the first number of the date in the cell i have chosen. I have then selected a blank cell and entered the formula :


However, when i have tried this, it hasn't worked.

View 2 Replies View Related

How To Bring Different Application To Front Once Launched With VBA

Apr 14, 2014

What I have is a sheet with Command Buttons on, and one of them when clicked launches another application which has a log in screen.

I can't for the life of me get it to bring that application log in window in front of the excel application when it runs.

I have tried various ways of sending Excel to the back once the button is clicked, but just can't get it to work.

Ideally, once clicked the new application log in window will come up in front of excel, and set focus on the Password box, is this impossible to do just from inside excel?

We are looking at

[Code] .......

View 4 Replies View Related

Sort : Bring All The Baskets Under Column

Feb 18, 2009

My rows and columns are as below

Basket 1 3 Basket 1 4 Basket 2 5
Basket 3 7 Basket 3 2 Basket 9 4
Basket 4 2 Basket 5 2 Basket 11 1

I want to bring all the baskets under column A in one row and Oranges in B, Apples in C and Lemons in D like this

Items Oranges Apples Lemons
Basket 1 3 4 0
Basket 2 0 0 5
Basket 3 7 2 0
Basket 4 2 0 0 and like wise.

What is the best way to do this.

View 5 Replies View Related

Double Click To Bring Up Form

Apr 6, 2009

I'm using a little sub routine to bring up a pop up calendar when i click in a cell, everythings lovely but it annoyingly comes up when i select a clolumn or row that also contains that cell. modification to require a double click to display the calendar?

View 2 Replies View Related

Bring Back Complete Printer Name

Nov 12, 2009

create an array of active printers. I edited the code to write the array to a range, then populate a data validation list with the printer names. All works great. The goal was to select a printer name from the list and run a macro to print some sheets. However, the function doesn't bring back enough of the name to do this. how to edit the function to bring back the whole name.

For example: after running the function the 1st printer returned ="\rizzoHQ-ENG-04"...when i record a macro to print to this printer it needs ""\rizzoHQ-ENG-04 on Ne05:". Here is the function unedited, I bolded the part i think is controlling the name:

View 5 Replies View Related

Bring Chart To The Front VBA Code?

Nov 20, 2012

I have chart object in the sheet. I wrote code that makes the cart big, but it is not on top of other things. I need to add a snippet of the code that would make it "bring to the front".

View 1 Replies View Related

How To Bring Images In Outlook Using Macro

Nov 26, 2012

I have designed a macro to convert the contents of an excel sheet to HTML format and bring it to outlook email. Everything is getting copied in the email except an image. How to bring that image in the same email draft?

View 1 Replies View Related

How To Bring Up Find (Ctrl-f) In A Macro

Dec 13, 2013

Been using this code...

Sub Macro2()
' Macro2 Macro
' Macro recorded 11/28/2012 by Doug Garn
Dim Rng As Range
Set Rng = Range(ActiveCell, ActiveCell.Offset(0, 3))


What it does, I hilite (put focus on 1 cell) a cell and it copies that cell and 3 more to the left, switches to 2nd xls file, pastes that, puts the cell focus on next line, then goes back to the first sheet and I just have it select a random cell(s) so it does a Ctrl-F properly.

Problem is the 3 ways I have above to bring up the find box aren't working for me. It won't find anything and I don't understand why. And I hope I explained this correctly.

View 2 Replies View Related

Using If And Formula To Bring Back Company Name

Jun 5, 2007

Name Qtr Year
Org 112007
Org 222006
Org 332006
Org 442006
Org 542007
Org 612006

I want the code to say, If Qtr = 1 And Year = 2007, then bring back Org Name, If Qtr = 2 And Year = 2006, then bring back Org Name and so forth.

The code should loop through a range of constant data (Region Name), until the Region Name is blank.

Dim OrgCell As Range
Dim OrgTargetCell As Range
Dim RegionCell As Range
Set OrgCell = Sheets("DATA Removed").Range("A2")
Set OrgTargetCell = Sheets("Overdue").Range("A3")
Set RegionCell = Sheets("DATA Removed").Range("C2")
i = 0

OrgCell.FormulaR1C1 = _
"=IF(AND('DATA Removed'!R[-1]C[11]=1,'DATA Removed'!R[-1]C[12]=2007),'DATA Removed'!R[-1]C,0)"
OrgTargetCell.Offset(i, 0).Value = OrgCell.Offset(i, 0).Value
i = i + 1
Loop Until RegionCell.Offset(i, 0).Value = ""
End Sub

View 9 Replies View Related

Bring All Rows Into My Template Spreadsheet

Jul 23, 2008

I've created the code below from scratch (ever so proud of myself even though it's basic lol)

Dim N As Long
Dim LR As Long
N = Range("A2").Value
LR = Application.WorksheetFunction.CountIf(Worksheets("Overview").Range("AJ:AJ"), N)
For N = 1 To LR
Here, 'N' is a project number. This code succesfuly counts the number of sub-tasks linked that that project in my data sheet. Now I want to bring all those rows into my template spreadsheet, but dont know how to start

View 9 Replies View Related

If Any Cell Is (red) Has A Color Index Of 3, Bring The Whole Row To The Top

Jul 9, 2009

I have a worksheet with several columns and 1,000's of rows. I have code that makes all "good cells" grey (color index 15) and all "bad cells" red (color index 3).

I would like to do 2 things...

1. If ANY cell is RED, cut the WHOLE ROW and "insert cut cells" below the header row (even if ALL other cells are grey), then repeat the process up the whole worksheet until ANY row with a red cell is at the top.

2. Create a new worksheet named "Trouble Cells", copy the header row along with any rows with red cells.

I would like to keep the formatting the same (for example, the title row is always yellow and is "28" high and all other rows are a height of "12").

I would also like to keep the column width of each column in the new worksheet as well.

Excel 2002

View 9 Replies View Related

Macro To Bring Up Save As Dialog Box

Feb 20, 2007

I am modifying a corporate macro that is used in to create a standard technical letter. This standard file has 6 macros, that once used to create the letter, are never used again. I know, the first thing that jumps out is to create an add-in. I'd prefer not to got hat route at the moment for various reasons.

What I'm looking to do is after the letter is created, and the print macro is called and prints the letter, all macros are removed (already found help for this on this site), then check to see if the file has been saved, or still has the template name, and then either save or bring up the save as dialog box for the user to save the file with the appropriate name and folder.

View 9 Replies View Related

Bring Top 10 Unique Name Based On Multiple Criteria?

Apr 23, 2013

In the below data set i have the data ranked by branch and center by value. I am trying to create a summary page that looks at the data set by branch center and rank and brings back the debtor code. The letters above headers represent the columns.

a b c d e f g


View 1 Replies View Related

Dropdown List And Bring In Additional Data

Feb 18, 2014

I want to use excel to create quotations for customers. (currently doing it in word)

Tab 1 is the quote, has 4 columns, part number, description, cost, yearly maintenance
Tab 2 has all the things we sell, part number, description, cost, yearly maintenance. 150 lines.

So, Tab 1, description column is a drop down box from Tab 2. Working fine.

Question. When an item is selected from the drop down, how do I get it to then bring from tab 2 the part number, cost and yearly maintenance.

View 8 Replies View Related

If And Vlookup Formula (bring Up The Corresponding Product Description )

Jun 15, 2009

I'm trying to get a cell {in the attached spreadsheet 'Order Form' Sheet- Cell 'B13'}, to bring up the corresponding product description {'Products' Sheet- Column C}. For the cell that is to bring up the product description {'Order Form' Sheet- Cell 'C13'}, the following is the formula I'm trying to use, but is coming up "#N/A":
=IF(C13>1000,VLOOKUP(A13,Products!$A$2:$D$12,3),IF(C13>287,VLOOKUP(A13,Products!$A$14:$D$25,3),IF(C1 3>0,VLOOKUP(A13,Products!$A$28:$D$38,3)," "))).

I haven't attempted the "Cost/Bottle" formula yet {'Order Form' Sheet- Cell 'D13'}, but it needs to correspond the product number {'Order Form' Sheet- Cell 'A13'} and the quantity ordered {'Order Form' Sheet- Cell 'C13'}, with the cost/bottle on the that quantity found on 'Products' Sheet, Column D.

View 5 Replies View Related

Bring Second Worksheets Data In Userform ListBox2?

Mar 8, 2014

I have a userform which catch data from worksheet and show it in userform listboxes.

I have two worksheets named " EmployeeRecord" and "SalesRecord"

I have two ListBoxes in userform.

In the userform I have a search text box which is used to search employee and show employee list in ListBox1. This is working perfectly.

The problem is with Listbox2 which I want it to search data from worksheet " SalesRecord" for selected employee in ListBox1 and show data in ListBox2.

how I can bring data in listbox2, when employee is selected in listbox1.

I have attached worksheet and userform.

View 1 Replies View Related

Copyrights 2005-15, All rights reserved