I have data in three columns
A B C
4.5 9.50 4.657
4.5 11.60 4.789
4.5 12.50 4.654
4.5 13.50 3.930
4.5 15.20 3.826
I need to be able to auto-populate the cell in column G based on values in columns A & B. If I type 4.5 in E2, and 13.50 in F2, G2 should auto-populate with the value from column C
E F G
4.5 13.50
the post 5 for the actual issue. This being my first post could not update it correctly. I have put my views int he 5th post which will be more clear.
View 9 Replies View RelatedI am trying to auto generate a calendar based on two drop down menus - Month and Year.
Once the month and year is selected I want to import all work orders onto the calendar based first on the "Labor Name" found in the list of work tab, then assign each work order for that labor name to the respective date on the calendar for the month.
August PM Schedule Demo.xlsx
I have a question on how I could populate data using a combo box selection in Excel 2010.
For example, I have a table with values in Sheet 1, & below that table there is a combo box whereby another table of values can be populated based on the selection of the combo box.
Maybe to make it clearer...
Table 1
Name | Address | Phone number
Andy | Avenue 2 | 999
John | Road 5 | 998
Combo box (selection of names): John
Data derived from combo box - Table 2
Name | Address | Phone number
John | Road 5 | 998
how I could solve this Also, do let me know if this can be done without the use of VBA.
I am trying to create an easy fill spreadsheet for a game. I am looking to have data values auto fill based off of the entry of 2 prior drop down menus.
I would like to have values for "Move", "Str", "Spd", "Skill", "Armor", and "Value" auto populate after the "Race" and "Role" has been selected. Data for these auto fills I have put on Sheet2 while the main file itself is on Sheet1.
If possible I would like to have Value increase by 5 for every level in "Rank" on the sheet.
I'm creating a configuration tool for instrumentation that has several options. Many of these options are dependent on one another. To summarize, I need to:
*Conditionally lock cells (and populate with "N/A") OR allow selection from drop down list - the list exists, it's the locking and auto-population I'm struggling with
Example: If A1 = No, then B1 = "N/A" and is locked, else allow selection from drop down list in B1
I need to populate two combo boxes from excel sheet, the data will be like below:
Column A Column B
A 1
A 2
A 3
A 4
A 5
B 100
B 101
B 102
So from the above data, one combo box should hold unique values A & B.
On selecting a value from the 1st combo box A or B, respective values should be populated in 2nd combo box.
So the data should be like below:
If A is selected in the 1st combo box, then 2nd combo box should only show the values 1,2,3,4 & 5.
If B is selected in the 1st combo box, then 2nd combo box should only show the values 100,101 & 102.
Friends I need it in a macro and one important point is, this is dynamic and it is not static and the data can be more.
I got an excel, with a "validation list" in a certain cell.
Users can select value1, value2 or value3. based on this value, some columns will have to unhide (standard= hidden)
(only for value2 this is the case).
I used the worksheet_change event to determin the value, but so far I'm only getting it to hide...
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If C24 = "value2" Then
Columns("H:O").Hidden = False
Else
Columns("H:O").Hidden = True
End If
End Sub
The file is attached here. I would like to be able to autopopulate cells based on a dropdown. The first tab has the final report and the other 2 tabs are the raw files.
KMPH_Inventory.xlsx‎
I have a single registration sheet that lists names, contact information, and the class someone is in on a single sheet.
(Name, Number, Email, Class 1, Class 2)
I am hoping to automatically populate other sheets in my work book based on classes... essentially making automatically populated rosters. For example, everyone who has Math listed in either Class 1 or Class 2 would have their entire row (with contact information, etc) copied to the "Math" sheet.
I have a dropdown list selection on the form for types of machines. The list of machines, their sizes and related noise level are in a chart on worksheet 2 and I'd like to automate the form so that when the machine is selected, the related noise level auto populates.
The dropdown box has been put in the form using the data validation function.
I am after a VBA code that I can use to populate a fax template based on criteria's
Basically I have records which are being logged throughout the day via a User form and sometimes there may/maynot be a charge. the user decides at the time. The column is named "to be charged" and is filled with either Yes/ No.
I need to be able to select the date to print or Just the same day date and print all faxes' that have "Yes" for charge This way all the information for each fax is populated and the user can just print.
and if possible mark a Colum non the master sheet as printed with a X or something
I have the catalog #s of some products in column A, and I have the brand in column B, Product name in Column C, and the model # in Column D. I want to create a formula that if I select the catalog # it should autopopulate the brand in column B, product name in column C and the model # in column D!!
And I have the brand/product & model # in a different sheet!!
I am trying to have the calendar in the second tab of the attached excel file to auto populate based on info in the first tab.
In the first tab, there is the start and end dates of certain projects. The calendar will need to only show the project name of every project being worked on that specific day.
Some days will have more than one project being worked on, the Calendar will just need to list them all under that day. The Start and End dates count as days the project being worked on as well. We will also need the calendar to auto update whenever we modify the dates in the first tab or add/remove projects (rows).
I need to modify the code below:
PHP
Sub Macro1()
Macro1 Macro
Dim strbody As String
For Each cell In Range("B2:B640")
Sheets("MASTER").Select
Cells.Select
Selection.Copy
Sheets("Final Merged").Select
Sheets.Add
ActiveSheet.Paste
Next
End Sub
The code above is creating a new sheet for each different value in column B. I would also like to take that value and place on the newly created sheet in cell A17.
Also, how would I get the sheet to be ranamed to match the value in cell A17 of the newly created sheet?
I have attached the sheet :
Certain job descriptions require certain training. Drivers needs these two particular trainings and an office employee only needs that training...
I have a reference sheet with what trainings are required for what job. I then want the next chart with each employee name and subsequent job title to have the required trainings automatically checked. (I can take care of the conditional formatting after that).
Job Desc.xlsx
I have 5 columns: A, B, C, D & E of which I have drop downs for: Yes, No, Maybe, Not Sure for A, B, C, & D. I need column E to offer a hyperlinked mailto:ask@bob.com when A, B, C have Yes, Maybe or Not Sure selected. If Yes, Maybe or Not Sure is selected for D, I need to have a hyperlink mailto:ask2@bob2.com. When no is selected for any of them, I need to have it say None.
View 9 Replies View RelatedI am currently trying to create a spreadsheet whereby if I enter certain text in a cell in Column A on worksheet 1 that correlates with text in a cell in Column A on Worksheet 2, then the description in Column B in Worksheet 2 is entered into Column B on worksheet 1.
For example, if worksheet 2 has the following:
Column A Column B
XXXX PRODUCT 1
YYYY PRODUCT 2
and I enter XXXX in column A on worksheet 1, I want Column B on worksheet 1 to automatically enter PRODUCT 1.
I'm trying to figure out a way to populate multiple cells automatically with certain information after entering info into a single cell on a separate worksheet in a separate workbook.
Our "master" sheet has 22 total columns (A-V), and our weekly "status" sheet only has 7 total columns (A, E, P, L, M, N, R).
Column A on both sheets is labeled "Sample Number". On the "status" sheet I want to be able to type, for instance, "2012-228" into A2 and have the corresponding values from Columns E, P, L, M, N, R on the "master" sheet automatically populate into B2-G2 on the status sheet if this is at all possible.
I am trying to build a Calendar that pulls all of it's entries from data submitted via user form. To be more clear, I built a basic user form in VBA where I can submit this data: name, brief description, Time/duration, and date. Instead of the data I enter into the form populating in specific cells in my Excel workbook, I would like for the information to be populated into a calendar based on the date.
View 1 Replies View RelatedI am building a budget spreadsheet and would like the date to automatically populate in column H when data is entered into rows J through AN, or alternately update column H when a sum total is populated in column I
I need to repeat this for rows 4 through 63
I was trying to use the following code, but cannot get it tweaked right.
[Code] .....
I have inherited a number of databases in work (running Office 2003). It has quickly become apparant that a vast amount of work is duplicated and so i am trying to cut down the data input and therefore the possible errors.......
I have narrowed most of the work down and now have a major worksheet (is that what you call a complete Excel file) named "master database" and several over minor files....
Currently what i am trying to do is to get the minor files (68 seperate files) to auto populate an area of the master database. I will try to explain it below...
1. Minor database has 2 columns with data i require to auto populate the master database. (1 column (B) is called 'off', the 2nd column (C) is called 'on').
2. A number will be inputed manually into either 'B' only or 'B and C' columns, depending on the criteria of the job..
3. The criteria of the job is dictated by column (Z) where the text 'A' or 'ATL' is inputed
4. The master database i would like to add up the numbers inputed as a total from columns 'off' and 'on' and place them into seperate columns 'E' and 'G' of the master database.
5. IF column (Z) shows 'A' then only column (B) 'off' is to be calculated and put into the master database at column (E)
6. IF column (Z) shows 'ATL' then BOTH columns (B and C) 'on' AND 'off' are to be added together and column (G) populated on the master database.....
To make matters more complex. An expiry date is shown on the master database at columns (D) and (F).
IF column (E) does not exceed 12 by the expiry date, i would like the cell (D) to turn red
IF column (G) does not exceed 10 by the expiry date, I would like the cell (F) to turn red
I would like to enter a name in E11, and then have G11 populate the name of the company that person belongs to, from a different sheet.
If the person is new, the company name entered into G11 should create a new column on the Companies sheet.
I've attached a dummy sheet which should make it more clear.
DummyCompanyPopulate.xlsx
here is a formula i would like in cell D20 (might not be a formula out there,maybe more code)
if cell C20= "S" then text in Cell D20= "SHOP" (then will be able to type after "SHOP")
if cell C20="F" then text in Cell D20="Field" (then will be able to type after "Field")
I have many facters (15 to be exact) that I would like to do this in the range of D20:D38
creating an Excel invoice that would auto-populate from another Excel worksheet or file with data. The information that I would want to include are:
Company name
Name (person)
Email address
Start date
End date
Promotion description
Number sold
Price per item
Total charged
How to populate MTD data linked to the other spreadsheet file (monthly data) to the table on the left, depending on the month selected month from the dropdown list.
Attached files for reference :
Dropdown Month.xlsx‎
MONTHLY DATA.xlsx
Need formula for populate a cell with a date. I have a workbook with 5 sheets (mon, tues, wed, thur, fri) and I'd like to type a date on mondays sheet so all the other sheets follow on the date ie:
Noverber 1st 2008 is typed into sheet 1: A1, sheet 2 automatically displays November 2nd 2008, sheet 3 displays November 3rd, etc..
I know it's basic progression, but I'm not sure how to do it with date/text...
I am trying to auto populate into a column that starts in cell E5 and references cell C5 (along with a dataset in N and O). In cell E6, I copied and pasted this formula and changed all of the C5 values to C6. When trying to use the auto populate cross hair tool, excel changes all N and O cells, from O165 to O166, O167 when they should have remained O165 and N165 for every cell.
=IF(OR(C5<MIN(N9:N165),C5>MAX(N9:N165)),"",IF(C5=MAX(N9:N165),INDEX(O9:O165,
MATCH(C5,N9:N165,1),1),(((INDEX(O9:O165,MATCH(C5,N9:N165,1)+1,1)-INDEX(O9:O165,
MATCH(C5,N9:N165,1),1))/(INDEX(N9:N165,MATCH(C5,N9:N165,1)+1,1)
[Code].....
Every time a name is selected in column C12:C15, I need that respective row to populate with $10 in column J. When column C12:C15 is blank, I need that respective row to read $0 in cloumn J. It's either one (10) or the other (0).
There are rows above and below it as well that have nothing to do with this, so the formula/function would be specific to just this subset of rows (rows 12-15).
I get close, but can't seem to nail this simple formula/function down. I am unable to download any sheets due to my work's firewall.
I am trying to automate a process where a series of numbers would get populated according the range values. Also I am trying to get the automation to pick up the next range when finished with first one and continue with the task.
Here's what I have as start info and where I want to get to.
Sheet1
A
B
1
Ranges
[Code] ......
Excel 2003