I am trying to get excel to pull the value from a certain cell. The value is pulling correctly when I use whole numbers. But if I format that value as either a decimal or percentage it does not recognize it and only pulls over 0.
Here is the code.
[Code] ....
I have a Workbook (Test 1) with several columns A-S. I'd like to be able to continue to add data into Test 1, and have some of the data pulled into a new Workbook (Test 2). Basically pulling data from Test 1, cols. D, L, J, E, I, C, K, Q and S - into the new workbook Test 2.
Some of the columns in Test 1 have conditional formatting and data validations, but I need the data in these columns to be replicated into Test 2 - without having to copy/paste between the 2 workbooks.
I figured how to do this in Excel 2010, but my office is still using 2007 and I can't seem to get it to work....
Any way to pull in information from a particular website directly to excel? For example if I have the URL or the specific web page can I then locate specific pieces of information that are contained in specific areas of the webpage and pull it into excel?
View 5 Replies View RelatedUsing Excel 2010. I have 2 worksheets, saved in same folder (if that matters).
Worksheet 1=Master_List.xlsx
Column1
Column2
Column3
Column4
PartNumber
1002
Sony
Playstation
4D
W74859
Worksheet 2=Sample_List.xlsx
Doesn't Matter
Doesn't Matter
Doesn't Matter
Doesn't Matter
Doesn't Matter
Column1
Column2
Column3
PartNumber
Doesn't Matter
Doesn't Matter
Doesn't Matter
Doesn't Matter
Doesn't Matter
1002
Sony
Playstation
Basically, I'm looking to populate the blank cells in the PartNumber column (Sample_List) by looking at the data in Column1, Column2, Column3 then going to the Master_List, matching up Column1, Column2, Column3. The PartNumber value in the row with the matching values would then be copied to the Sample_List.
I have an excel macro that works of off data that we pull from an access database and the only part being done manually is editing the query and importing the data to excel
What I would like is something in excel VBA that pulls the data from access. my thought is in access i would have a basic query that has the fields we need and excel would have a form to filter those fields as needed.
One of the fields is Date and another Location where we filter date ranges and locations. we currently go in to the query and filter the date range by hand and the locations we want by hand.
I am not that great in access so have not created any macros to pull the data from excel before so don't know what I am doing.
Looking for formula to extract data from the raw data table list to a new table list when an option is selected from the dropdown list.
Sample data attached and desired outcome in green color.
Outcome
Product 3
ProductTargetOff TargetTarget Range
January364980
February135732
March162167
April
May
June
July
August
September
October
November
December
I have an excel sheet where column B has a list of product codes. I also have a folder with pictures of each product and file name of the pictures are the product code. I would like to place the picture of each product in column A beside their respective codes. If possible, I would also like to reformat the pictures so they fit in the cell. (3.00 x 3.85)
Need a Macro that can run this.
I have an excel sheet where column "B" has a list of style numbers . I also have a folder with pictures of each product and file name of the pictures are the product code. I would like to place the picture of each product in column "A" beside their respective codes. If possible, I would also like to reformat the pictures so they fit in the cell. Size= (3.00 x 3.85)
I want to be able to press for example :CTRL Q and all the the pictures will pull from the folder on my PC and populate in column A next to their respective style # in column B.
I have a column of numbers each have a 0. infront of them (example 0.2346
0.5698). I want to pull the number from the right until it hits the decimal sign. So for the two above the result would be 2346 and 5698
I threw together some sample data, just to test things out. It's very basic, one table of "Customers" and another table with the 50 US State's and their corresponding abbreviations. In the "Customers" table, there is a column of state abbreviations, and in the "States" table there is a column of state abbreviations as well. I have a relationship set up between these two in PowerPivot.
Each "Customer" in the "Customers" table has a unique "User ID". In some states, there are multiple "Customers" (User ID's).
When I try to pull a PowerPivot Table off of these tables, it's showing me all the states as being associated with every user ID. It looks correct if I just pull in the "States" column and the "User ID" column from the "Customers" table...
image1.jpg
But as soon as I drag in the "Full State Name" column from the "States" table, it screws up the PowerPivot Table and shows all the state names being related to the state abbreviations, and all the User ID's as being related to all the states. (This isn't the full image of the table, only part of it, since the full image would be too large).
image2.jpg
I'm used to doing everything with VLOOKUP's, and seldom used PivotTables at all in the past. But it was my understanding that these new PowerPivots would eliminate much of the need for VLOOKUP's.
I have Excel 2003
My spreadsheet has multiple lines of data for multiple items (have a specific item #) and I need to be able to enter an item # on a different sheet so that the requested information can be pulled from the data source. The items have information on multiple rows. I need to have all of the rows pulled into my output file when I specify the specific item. #.
I have attached a spreadsheet showing the type of data is contained and what my desired output would look like.
I want to pull 'values' from a website off into column's "A" "B" and "C."
What I am looking for is:
Column A: The current date!
Column B: The closing VIX value of the day!
Column C: The 10-day-moving average value of the VIX for that same day!
All values come from this website: [URL].......
(full link so it doesn't look sketchy; also a link to mainwebsite: [URL] ..... )
What would be the formula for this? Or how would one go about this? And preferably the time to pull these values would be at alterable, but ideal time is hard to choose right now... Need to think about it!!!
So I am trying to pull data from multiple sheets. I've gone through the thread, but haven't found an answer yet (or didn't work hard enough). On Sheet1, yellow highlighted column, I am trying to look up the I.D. Code for 36 month residuals. As you can see, I have to use multiple conditions on different worksheets.
I have to use most of Sheet1 columns to find the answer. I just can't figure the formula out.
I don't have Excel 2007, only 2003 I have.
I have an excel 2010 spreadsheet that lists all of our vendors and the amount we spent with them over the last year.
I want to know how many of them were local vendors.
I have a list of all the zip codes within a 100 mile radius (there are about 500 zip codes). I would like to write a macro or sort function that searches the entire vendor list and only reports back those vendors that are included in the zip codes I specify.
The columns are as follows:
A B C D E
Vendor City StateZip CodeTotal AP
Vendor 1TROY AL36082527.37
Vendor 2PHOENIXAZ85054100
Vendor 3TUCSONAZ8571416255
I want to keep the all the columns, I just want to eliminate all of the vendors that do not fall within the zip code criteria I set.
As part of report consolidation I need a Macro that can read through all the files in a particular location(Say a folder path) Pull the data for each unique products into separate sheet
In the example below : All the rows with "Chocolates to sheet 1" , Drink to Sheet 2 and so on Since the products in column 3 can vary the unique sheets need to be created at run time based on the source data
Workbook1
WEST
100
Chocolates
[Code]....
I have created a worksheet with Excel 2007, which includes a pull down list. Within this list are 2000 unique numbers in a separate worksheet this data is pulled from. Is there a way to dim or change the color of numbers previously used so that when the list is used again, it is easier to see where I left off?
View 1 Replies View RelatedI am using Excel 2010.
My objective is to pull specific values from an external file corresponding to the correct name and year of my choosing. The first way I thought would be best is to use an INDEX/MATCH function. The problem is the external files change names so I would need a method to easily change the source file name from one cell. I then stumbled across the INDIRECT function, but the INDIRECT function will only work when the source file is also opened. I then came across Harlan Grove's pull function which allows you to import data from closed excel files.
So, this is what my formula looks like: =INDEX(pull("'"&G12&"");MATCH(C15;pull("'"&G14&"");0);MATCH(D15;pull("'"&G16&"");0))
Cells G12,G14, and G16 contain the file paths for the ranges. C15 is name and D15 is year.
The problem I have though is that when I try to execute the function, Excel gets stuck. if the code cannot handle large amounts of data. I tested the code with a simple SUM function for a small range from an external file and it worked just fine.
This is the code I am using:
[Code] ...
Using excel 2010
In cell U24 I have this formula:
=SUMPRODUCT(($E$3:$E$2000=51014)*($F$3:$F$2000=101)*($K$3:$K$2000))
Currently, as you can see, this is summing up the criteria specified from row 3 to row 2000...(which i made the last row 2000 becuase I will never exceed row 2000 with info)
What I am trying to do is in cell T22 and U22 be able to plug in date ranges and make the above formula give me the sums of thos date ranges.
For example in T22 put in 8-1-11 and in U22 put in 10-1-11, and have the sum of that date range populate in cell U24.
Now ther kicker is this: some dates are repeated so I may have six rows of date 8-3-11....and they will have to be part of the sum total.....and ALSO the dates are not in chrological order....I may have six rows of 8-3-11.......then four rows of 8-10-11.....then maybe another three rows of 8-3-11, and so on and so on...this is for all dates. Sorting the dates in order is not an option.
I have been having issues with some excel fields not showing up in my pivot table pull downs.
For example I entered the date 6/8/97 into a field in my database and after I hit refresh on my pivot table that specific date doesn't show up in the Date field list pull down. It is like the pivot table doesn't even see that date and/or it is recognizing it as another date. I have this same issue w/ other field lists (eg. last names).
i found this code...
Code:
Sub Button1_Click()
Dim cnt As ADODB.Connection
Dim rst As ADODB.Recordset
Dim stSQL As String
Dim SNfound As String
'Your sqlserver 2008 connection string
Const stADO As String = "Provider=SQLOLEDB.1;" & _
"" & _
[code].....
but i dont see where to put in the Database object...
The Database it needs to connect to in SQl is called
The Server name is SQLSRV when you expand databases the database is called SWHSystem the Table is called dbo.Credential and from that i need to get SELECT All from the Name and CardNumber from dbo.Credential and put that in a New Sheet titled Personal
using Excel 2010 connecting to SQL 2008
I have a column with unique identifiers (numeric) that are included in another column. I need to find this number in the column and pull the data from that column into a new one. For example:
Unique Identifier: 28530
Is included in this string: 10.1.8........28530_201_10-....
I need the content from the string pulled into a new column. It seems there would be a LOOKUP that would work, but I'm not able to figure it out.
I am in need of a way to pull keywords listed in B2:B10 from text in A2:A10 and then those pulled keywords combined in cell C11.See attached document. So I have colors for keywords in column B and some random text in the column A including the keywords in parenthesis. Is there a way for a formula to find all keywords in A2:A10 and then list them in cell C11 with commas in between.So the result would be one cell C11 showing BLUE,GREEN,BLACK,ORANGE, etc.I have been trying to mess around with index and match and while I could get one to pull up I don't know how to combine it.
Keyword Range.xlsx
I have many workbooks which all have a summary sheet called summary, and which are all kept in the same folder (although this folder name/filepath may change from year to year).
I want to be able to set up the column headings and then copy the same set of summary information from each book so that it can then be used for analysis. The cells to be copies derive their value from formulae, it is the value that needs to be copied.
I attach a workbook with the format needed and the source cells. The source sheet will be password protected.
I know this is a question that has been raised before and I have searched the forum but not come across a question that is close enough to work from - my VB skills are appalling.
I have spread sheet with 2 tabs (MASTER LIST & CYCLE COUNTS), on each tab I have 2 columns(LOCATION1 & DATE1 and LOCATION2 & DATE2) I need to verify if I any cell from LOCATION1 is repetead on LOCATION2 and copy the informacion from DATE2 to DATE1. then if I update the CYCLE COUNTS sheet I want the MASTER LIST update by it self.
This is the formula that Im using but Im having problems with the range..... =if('Master list'!$A2$:$A$15000='Cycle counts'!$A2:$A$15000, 'Cycle counts'$B&2:&B&15000,0)
I want to be able to identify an Excel workbook in a cell, then have another cell pull the value from a specific cell in that workbook.
In the sample attached, I want the formula in cell C4 to pull the value in cell D35 from the workbook identified in cell C3. When I click within the brackets [C3] it asks me to choose a file name from my Explorer file list. "='[other_workbook.xlsx]Audit Information'!D35. I don't want to do that and want it to choose the file listed in cell C3.
I have a few cells which look like this: ...
View 6 Replies View RelatedI have this formula I use to pull the date and time that they place in 1 cell from a customer quote sheet. It was working well until we got to a double digit month.....
The thing is they are inconsistant in stating the dates. such as "09/03 10AM" or "9/3 10AM" or even sometimes "9/03 10AM".
Can this formula be altered to accept variables
=TEXT(LEFT(INFO!A35,4),"MM/DD/YY")
Is it possible to pull only certain information out of a cell?
I have in cell A1 (As of 6-30-12 and 5-31-12) i would like to put a formula in cell b1 to pull just (6-30-12 and 5-31-12) so that everything i change A1 B1 will also change.
I'm making pull down menus to auto fill in some options in my Cells... such as
"Open"
"Closed"
"Work in Progress"
what I would like is to have the menu also enter text formatting... so that I can have "Open" entered in RED and BOLD... and have "Closed" Entered in GREEN and Italics.
I am using an exported dbf from filemaker pro. This is an established dbf, with over 2,000 sku's in it. Here is what I want to do.
I am using Indata and InDesign to create a catalog. I need for excel to pull the first character from a cell and put it in another cell. i.e.
I have a dbf where I have author last name, and title of book. I need for excel to pull the first character of each of these fields and put them in their own cell/column. This will allow me to use these new columns to make the " headers" for my InData/InDesign doc.