Is it possible somehow to "download" specific values from web into specific cells?
I'm creating some currency converter and problem is that values are changeable every day multiple times, so I wana avoid that with entering specific value of specific currency from web into adequate cells.
This site is mine "database": link
I am building a spreadsheet for contractors to use to submit home rehab bids. I am using a Windows 8 and Excel 2013. How to assign a monetary value to a number/quantity.
For example, when the contractor indicates 2 toilets need to be replaced and 1 toilet needs to be repaired, I would like to assign the value of $300 to replace a toilet and $150 to repair. Ultimately, I would like the 2 and the 1 to be automatically totaled to read as $750 in the total line at the bottom of the table.
I'm brand new to this forum, so please forgive me in advance. I am hoping someone might be able to point me in the right direction. I got a request from my boss and it's something I've never done in Excel and far more advanced than anything I've tried to do.
In my spreadsheet, Columns B-BD are server names, and Rows 2-13 are program names. Inside the corresponding cells all have to display as percentages, and we are trying to display what percentage of each server is being used by each program. In Row 14, each column must total to be 100%. That part is easy, I already have that all setup.
However, the next step requires that each server is assigned a monetary value - one of two monetary values for Virtual or Physical server. Then, somehow I need Excel to calculate the monetary value for each percentage.
For example: if Column B is Virtual, and Row 14 totals up to equal 100%, it also equals $1,000. Say Cell B4 is equal to 50% and B5 is equal to 50%, each cell is also equal to $500. Easy enough in theory, but how should I execute this so that these cells stay in % format, but Column BE titled "Total Cost" displays the monetary value for each Program (row)?
I'm pretty sure there will be some kind of formula so I guess that's what I'm asking... how to calculate it?
I'll attach a screen shot to show you the gist of how it looks so far ...
I want to SUM monetary transactions based on two criteria.
1.) if the transaction occurred within a certain month (Jan)
2.) based on the transactions category ("Obligations")
I have two formulas which successfully validate the data individually but I need to combine them so that both criteria must be met before data is summed.
=SUMIF(REGISTER!E3:E1000,"Obligations",REGISTER!G3:G1000)
=SUM((IF(MONTH(REGISTER!$B$3:$B$1000)=1,REGISTER!$G$3:$G$1000,0)))
I have some data with recurring key values and differing values in the second column, I need to produce a unique list of key values with the second values concatenated together.(See below)
The data can be 10 rows to 5000 and I can have anything from 5 to 150 sheets (Separate data sets), a macro would go a long way to keeping me sane.
Sample data Required Output
A | B Z
1| 10 | a 10,a,b,c
2| 10 | b 11,a
3| 10 | c 12,a,b
4| 11 | a
5| 12 | a
6| 12 | b
My system is Windows 8 Excel 2010.
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.
Basically I have 1 value on 1 sheet and and multiple values on another sheet and I would like to know if it is possoible to mutliply these togther i.e
Sheet 1
100
Sheet 2
2,5,9,15,20....
I would like to calculate (100*2)+(100*5)+(100*9)+(100*15)+(100*20).....
I know if sheet 2 only had a few numbers like above which I have used as an example I could link the sheets; however in my data, sheet 2 is about 75 numbers that change.
Code:
Const Books1 = Array("5638", "5639", "10984")
Const Books2 = Array("3140", "7509", "3050", "7549", "7508", "7032", "6770", "6773", "4388", "6460")
I want to set an array as above for multiple use in my code (Used for auto-filtering various data with the same criteria).
The above is not allowed it seems, is there an alternative method so that if my Constant changes I only need to amend this once.
I am working with excel 2007 in windows 7. I am working with small animals that have been outfitted with a RFID (radio-frequency ID) tags with unique UID codes. In a sheet called Tag_info I have a list of the unique UID's of the tags that are in use along with a number of parameters (the colony in which the animal with this tag is situated, if it was treated with something, its age etc). I left out most of the parameters because they aren't relevant to my question, but it looks like this with each UID only once in the list:
A
B
C
1
UID
Colony
Treatment
[Code] ........
In a 2nd sheet, a ton of data is saved by the scanners that read the tags as the animals pass by scanners in a number of locations. The relevant data for my problem is basicly the timestamp (UTCTime_Rounded). Since animals pass by the same scanners multiple times, and scanners may read the same 'passing' as multiple signals the column with UID's here contains tons of duplicates (unlike in the Tag_info sheet where every UID is only displayed once). Once again, I left out the irrelevant data for simplification so that the data looks like this:
A
B
C
D
1
UID
Address
UTCTime_Rounded
Age at read
[Code] ........
So finally, what am I looking for? I want a formula to look up the UID's from the Tag_info sheet to find and return the first and the last timestamp (UTCTime_Rounded) for that UID in the RFID_Scan_values sheet.
So that formula basicly has to return the min and max values for UTCTime_Rounded, for each of the UID's in Tag_info. The output would look like this (I did it manually for this dummy dataset since I didn't get any formula to work yet):
A
B
C
D
1
UID
Colony
Treatment
First scanned
[Code] ........
Tag info And then a similar column for the Last scanned, max values.
I have made a spreadsheet where I want to input data and transport it to a rent card information.
I want to use vlookup to find the apartment number in a different spread sheet and fill in the information on a different spreadsheet (rent, fees, utilities).
I get how to use vlookup to get one value but I need 10 values to return.
Sheet1ABCDEF1THE SUM OF2GAME NUMBERSINDIVIDUAL 3GAME
NUMBER41101928=152112029=263122130=374132231=485142332=596152433=6107162534=7118172635=81291827369Excel 2007
Sheet1HIJKLMN12Last Nights Fantasy 5 Numbers3411/11/12051922293256sum of 7digits/#5142589pattern21110101112Full PkgAll Possible Patterns of 13CombinationsSum Of Digits1415129,0241111116193,536211101736,288221001816,12831100191,728320002028841000Excel 2007
Need a formula in Cols J7:N7 to return the sum of the values input in J4:N4 as a single digit. The table in the first image shows what the results should be.
I have the z-table imported into excel, How i can look-up values from the table to 2 d.p
For example, to lookup 0.49 would be the intersection of 0.40 down the rows and 0.09 across the columns, i.e a value of 0.6879
anoda example would be 1.26 which would be 1.20 down the rows intersecting with 0.06 across the columns and it gives a value of 0.8962
I have tried some index-match but hasnt worked out fine, i know excel's normsdist function can do this but i need to get it done this way
0
0.01
0.02
0.03
0.04
0.05
0.06
0.07
0.08
0.09
[code]....
Basically, I have a column that contains a list of names of files without the extension, ie "A2=File1" What I want, is for excel to open the file associated with the name in the column, "(A2).xml", and extract a value from that.xml file and insert it into B2.
I have searched and all of the examples I find aren't quite what I am looking for. I have an add-in that works exactly the way I want it, but does not extract certain values that I need it to. This is a commercial add-in so I don't have the source code for it or else this would be a snap.
I would like to export data coming from a range values which I set up. Just like the code below that will print out all the data using range values. I would like also to do the same in exporting the data in one pdf file with multiple pages based on each of the data of the range.
VB:
Sub Batch_Print()
Dim FileName As String
' On Error GoTo Print_all_Error
[Code].....
I have created an excel document with If formulas. If nothing gets entered in that particular row, the row simply says "None". Is there a way to get rid of any row that contains that value by any chance?
Something along the lines of if the row says "None" then that particular row gets automatically hidden? It would probably need to be in VBA?
Of the form "packing list" page of the changes made to the necessary places "commertial Invoice" section is being transferred. So far, no problem. If you are loading only the truck. However, a truck, trailer or container are loading more than one, "packing list" Vehicle / Container Nos. are different. If you are loading more than one truck or container, "packing list" Vehicle / Container Nos. are different. This is not a problem for the packing list. But the "commertial Invoice" on the invoice values that must be unique.
For example, from "the product 2" 50 pieces laoded to the truck and trailer have loaded a 25 pieces, in the "commertial Invoice", from "product 2" needs to write 75 pieces.
My question to you is this:
In the "Packing List" find duplicate products, to "commertial Invoice" Can we write to collect the amount of write one?
Second question:
In the form comboboxes' chage events are the same. Can we make change events one code?
I have successfully populated a website forms using Excel VBA. As a continuation of this task, i need to calculate the total of a column based on two other columns in the same worksheet.
Column A contains Date, column B contains 3 fixed alphabets (I, L and K) and column C contains time. I have attached a sample sheet here. sample.xls
How can i write a VBA code to find the sum of effort values of column C for each values in column B for a given date (value in column A).
Am using Excell for some times and understood the basic operations like VLOOKUP and other formulas, and it was really usefull. Now i have another requirement where i need to get all the values matching from another tab.
Below is the example: I will be entering all the values in Tab 2 manually. As well as i will be entering the Categories (Column A) in Tab1. I want the Values (Column B) in Tab1 to be populated.
TAB 1CATEGORY
VALUES
AA1
1
2
AA2
5
BB1
3
BB2
4
6
TAB 2
CATEGORY
VALUES
AA1
1
AA1
2
BB1
3
BB2
4
AA2
5
BB2
6
I have 2 problems in that
1) It is not dynamic, i have to change Tab 2 frequently.
2) values are listed below the categories
I am using Excel 2007
I have 50 000+ rows that covers fiscal years from 2006 to 2014 and I want to calculate how many unique clients are there per asset type per fiscal year. In addition, the results table needs to adjust to filters i would use on the raw data..
As:
2007
2008
2008
Commodity
45
FX
Other
other
Here is a sample file: SampleData.xls
I have a table that I would like to search to return all the values that meet 2 criteria entered by the user.
I have 3 columns - Role Name, Skill, and Skill Level - I'd like to be able to enter the skill and skill level and return all the roles that meet the two entered criteria.
At the moment I have an array, but it only returns the first value from the Role Name column that it finds.
=INDEX(A2:A100,MATCH(1,IF(C2:C100=G4,IF(E2:E100=H4,1))),0)
Where the A column is the role name, C is the Skill, and E is the Skill level. In cell G4 the user enters the skill to be search, and in H4 the level required for the skill (a scale of 1-4)
Is it possible for the formula to return all the values in column A that meet the criteria entered in G4 and H4?
I have an excel sheet with data results of samples analysis from ICP-MS the sheet includes the name of the sample and its results, I want to extract for each sample only the ( average value "x" , standard deviation "S" and " %RSD) and sort these values in columns , see the photo and the excel sheet attached ..
View 13 Replies View RelatedI am trying to implement a count on a table that splits up the number of customers associated with a list of managers. Sample data attached.
Count function.xlsx
So, I need some way to display a single instance of each manager name with a count of how many customers are associated with that manager. The number of managers and the number of customers associated with each manager does vary and are displayed in separate columns per the attached.
If I want to format a cell I go to that menu. Choose formatting number.
The default value will appear with 2 decimal digit.
I want to change it to 3. How can I do so?
Is it possible to change the DEFAULT values that Excel 2007 offers?
how to soft vaue of date in excel 2007. only arrange by date (not including month).
for examples:
it like that:
13/07/2012
15/01/2012
18/04/2012
I have "Worksheet1" with Columns A and B for IP Addresses, then Column C is for a device name.
I have "Worksheet2" with a range of IP Address from F5:I260
When I enter a new device and assign it the IP addresses on "Worksheet1", I would like the IP Address to highlight in "Worksheet2"
This way I can keep track of which IP address I have used. Excel 2010
First I have a excel with a selection of customers:
Column A = customer id
Column B = customer name
...
this excel contains about 500 premium customers
Secondly, on an external server I have a database with the details (adress, phonenumber, ...) of about 100.000 customers
Now I would like to display the details from the database into the existing excel. For that I was about to write a sql-query to copy the data I need to have into the excel (sheet2) to access it from sheet 1 with vlookup (based on the customer id).
But the large amount of data makes excel to work very slowly and it is impossible to keep on working like that. So now I was looking for a way to create a selective sql-statement.
Something like this:
select details from db
where customerid in (all the customer id's mentioned in sheet 1)
without writing all customer id's manually
I have set of data in excel which is basically a table of workload and I need to be able to select someones name from a dropdown list and all the other names are removed.
I've attached a screen shot of an example, I want to be able to select any name from a dropdown e.g. Select Trevor and then only cells which contain Trevor are shown (i.e. the other names disappear). BUT all the jobs 1-10 and Stage 1-3 have to stay even if Trevor doesn't work on them.
Screen Shot 2013-10-15 at 16.44.12.png
I want to copy a csv file into a excel, but not all values will be copy into the Excel. Watch out for my code:
Private Sub ImportiereCSVDatei()
Dim wbTarget As Workbook
Dim wbSource As Workbook
[Code]....
dh. Zeros and values after the Column "Stand_NACH" will not be represented in the excel but the header will allways displayed
I am looking for a VBA code which can be used to interpolate between values at a given interval and return these values to an excel sheet. I have a list with X and Y values and need to interpolate (linear) between two X points to return intermediate values for Y (interval between values is defined by the user in a userform). The code is to continue with interpolation between two consecutive X points until it has reached the end of the listing. In the example only several points are given, but the list can be longer or shorter than given in the example. The results need to be returned to a new sheet.
View 4 Replies View RelatedMonth Pay Tax Socia sec.tax
Jan 10000 2000 2999
Feb 15000 3499 3333
March 3455 222 333
I have an excel document with sheets representing employees and within the sheets it shows wages taxes nd social security tax for each month.
I want to create word documents for each month which inserts all the values for that particular month, aswell as the name of the employee into th word document. How to do this?
