Multiply By Info In Different Columns - Selected By Input In Cell
Mar 19, 2014
I'm trying to make a sheet to calculate my taxes. I would like to keep tax rates from previous year(s), and have them applied based on which year I input in a cell..
Let say that in cell B1 I write year 2013
In cell G1 I have year 2013 and in cells G2:G7 I have tax rates from year 2013.
In cell H1 I have year 2014 and in cells H2:H7 tax rates from year 2014
In cell B17 to B20 I would like to make a formula that multiplies cell B11 or B12 with information found in either column G or H based on input in B1.
I have attached a spread sheet as example.
I know I can make a formula based on IF(B1=2013;G*;IF(B2=2014;H*;etc..
View 3 Replies
ADVERTISEMENT
Jul 24, 2014
I am trying to create a macro which gives me an input box. I need to enter 2 numbers into the input box. It would be as follows:
Input Box Msg 1 - "What is your labor cost?" (NUM1)
Input Box Msg 2 - "What is your productivity rate?" (NUM2)
Then I need the macro to take this info and enter it into a formula which changes according to the row which you are on. (I need the macro to work based on which ever cell I currently have selected). The formula would be this if I currently had a cell on row 10 selected:
=(NUM1*(NUM2*$H10))/$H10
So, if I currently had cell L10 selected, and I ran the macro and put 100 in for "NUM1" and 10 for "NUM2" and my sheet had 20 in cell H10, then the macro would enter the number 1,000 into cell L10. If I had L500 selected, then the macro would enter the final number into cell L500 based on what value H500 contained.
View 9 Replies
View Related
Jun 26, 2012
I am wanting to transfer data from one sheet to another depending on cell input
Example:
If I enter "2" in sheet1 cell B1, then I want a macro to take A1 to sheet2 but place it in A1 & A2.
Then say I enter "1" in sheet1 cell B2 goto sheet2 and put A2 into A3 and so on.
Depending on the number entered on sheet1 column B, the Macro duplicates the info from Column A in that row into column A on sheet2. ??
View 5 Replies
View Related
Apr 1, 2008
my spreadsheet to return the word unit if cell a18=1 or the word units if its over 1 but i also want the cell to remain empty if there is nothing input into cell a18 is this possible
View 14 Replies
View Related
Jun 27, 2014
I am looking for formula , single cell two numerical values , multiply in different columns
example :
Cell (A1) contain: =350,23+25,59 (two values in a single cell)
request:
in (B2) only first value so 350,23 multiply (x) by fixed number &in (C2) only second value so 25,59 multiply (x) by fixed number
View 2 Replies
View Related
Apr 15, 2009
In my macro, I'm trying to use an input box to determine the factor to multiply another cell by. I also want to only allow entry of 6.0 or less, and only allow, (but not require), a single decimal place. Here's what I've got so far, but it's not working:
View 2 Replies
View Related
Aug 22, 2014
I have attached a spreadsheet and I am trying to capture the info in lines 2,7,12,17 and return the info into column d,e,f,g
The info in these columns at present has been manually entered but I am sure it could be automated.
OOL Roster Final 18-31Aug14.xlsx
View 1 Replies
View Related
Jan 26, 2009
Is it possible to click on a cell and use the cell info as the input data for a search instead of typing data into a cell for a vlookup?
For example, I have a spreadsheet with numbers corresponding to stock codes. Would it be posible to just click on the stock number to return the information on the stock (levels, sizes etc...) instead of typing the stock code in for a vlookup calculation.
View 5 Replies
View Related
Feb 10, 2009
I am having difficulty with this formula. In the attached spreadsheet. I want to just input the item number in column A, manually. From there I want it to take the information from the hidden list and fill in the rest of the fields. Example. I input in A4-2664, I want it to search the list for 2664 and take the corrisponding information. It would take the information from M5, O5, and Q5 and place that in C4, E4, G4. I place spaces in the hidden list to make the format the same.
View 2 Replies
View Related
Mar 31, 2012
master spreadsheet resides in x directory, up to 100 individuals upload a file into that directory weekly. The uploaded files are from the exact same template, but file-names are slightly different
Is there a way to to extrapolate the data in specific cells from each sheet, to the master sheet. Ideally separated by date of submission (or a date supplied from within the uploaded sheet itself)
I'm guessing at using a variable like "*" in the file name
- but that would include the master file? causing duplicate data
- what about duplicate submission dates?
View 1 Replies
View Related
May 29, 2009
I have this code going for a sheet i've been working on, but thers only one thing I can't figure out how to do.
I want it to take the text that was entered in the "Grid Date" input box and stick it in the bottom 10 cells (plus one space). IE - if A14 is the last used cell, paste it into A16 through A26.
View 2 Replies
View Related
Mar 24, 2007
a user inputs the drawing number and revision in a box on the first sheet in the workbook. Once that is done, the user then selects the type of drawing from the drop-down menu, once "Submit" is clicked it takes that info and puts the information in the next available cell for the other worksheets (if that worksheet calls out for that certain part).
I've been having trouble trying to figure out how to be able to accomplish this task.
If you have any ideas, that'd be great.
I've attached a basic worksheet I drew up to give you a better idea of what I'm looking to do.
Forgot to mention that there are totals involved! The "destination" worksheets have set totals for each drawing type, so what also has to be taken into consideration is that the specific drawing needs to have the correct total beside it. I created a "Totals" worksheet to show what drawings are what totals for each cell. Realizing this may always change or be updated, I created a seperate worksheet to pull all the numbers off of. I thought this might be easier rather than going in and changing the coding each time.
View 9 Replies
View Related
Mar 9, 2014
I have an XY plot where the source X value data is a series of time values, each associated with a descriptive text cell. I would like to select a single point (obviously by mouse) and then execute a macro (right click preferred but a separate command button would be a suitable substitute for now) that will extract the X-value. I then plan to use that value to find within the source data the associated descriptive text cell and make a data label from that text. No clue where to start...the macro recorder is woefully deficient in this area.
View 2 Replies
View Related
Feb 23, 2010
I would like to multiply every number in one column with every number in another column with every number in a third column (columns A,B and C).
There are less than ten cells in each column.
View 9 Replies
View Related
Aug 22, 2014
So I have the first part of my equation and it works fine. The equation is in Column D.
=IF(ISERROR(FIND("Van",A7,1)),"",B7*C7+50)
What I want it to do is: Combine the above for Col D with: if the Unit Name Column (A) says anything EXCEPT Van, I want it to multiple Cost (Col B) by QTY (E) and put the total in Col D.
View 7 Replies
View Related
Jul 31, 2009
Hi, I have this good working formula: ...
View 6 Replies
View Related
Oct 30, 2013
Excel (2000), what formula would I use to accomplish the following?
If A1 equal or less than 1000 value, multiply by B1, otherwise multiply by C1.
View 9 Replies
View Related
Jun 24, 2014
Instructions are in the attached excel as well. Please see attached
If a person puts in a price in column A, that results in column B "Everyday Price Per Unit" being greater than column C "NDP", then highlight column A cell input red.
=Column B>Column C, then turn input cells in Column A Red.
First four highlighted are examples of thise formula scenario
** All based off an input into column
How to use conditional formatting to do so???
Excel Conditional Formatting 06.24.14.xlsx‎
View 5 Replies
View Related
Jul 17, 2013
I am trying to display number of lines which depends on value pass by user. Actually user is passing some value. on which some group of lines has to be display.
eg
for 1 value 9 lines
for 2 value first 9 lines + another 9 lines
for 3 value first 18lines + 9 lines
and so on till 52.(this 9 lines are set of some column and rows)
thus cant use macros..
View 1 Replies
View Related
Dec 4, 2009
I have a macro that adds a row with predefined formulas and formating. The macro is launched by clicking on a button. However, I would like to make it possible to add more than one row at a time. My plan to do this was to use the number of selected row as input to the current macro. If the user selects row 1,2,3 and 4 (or 15, 16, 17 and 18, and so on) four new rows should be added. I would just add;
View 3 Replies
View Related
Dec 29, 2013
Have a person Input an Assembly Number and,Have Excel return a list of Part Numbers, their Descriptions, and a Quantity for each Part Number that will need to be packaged with the Assembly Number that was Input.
The output needs to be in the form of a check sheet (I can play with the formatting if I can get the information out) for the one Assembly Number input.The output can either be in a separate spreadsheet or a User Form. The spreadsheet is easier for me to work with but the User Form looks cooler.
I can use a VBA Function to Input the Assembly Number but then I need some way of searching a small table (about 20x20 cells) to find the matching Assembly Number and then return the Part Numbers, etc. to a check sheet so the parts can be packaged. Each Assembly Number can have several Part Numbers associated with it. Either unique to that Assembly Number or common to other Assembly Numbers. The Quantities can also be unique or common. A couple of simple examples might be:
Assembly Number - ANA0134
P/N Description Qty.
ANA0118 Widget thing 2
ANB0554 Thing Widget 4
Assembly Number - ANA0431
P/N Description Qty.
ANA0118 Widget thing 3
ANB0554 Thing Widget 4
ANC0023 Plain Widget 1
View 4 Replies
View Related
Jul 25, 2012
I have two columns that represent constituents from a stock indices from two different years. I would like to find out what stocks appear in both years.
View 1 Replies
View Related
Dec 6, 2012
I have a drop down box on a worksheet and once I have selected the item I want from the list, I would like the price of that item to appear in the cell next to it..
View 2 Replies
View Related
Mar 24, 2014
I have a list of names in column B, I can easily put this into a list
I also have a different list of names in Column C
These two list are feeding from sharepoint and are updated regularly
What I want to do is create a drop down list that will list all the names in Column B and Column C, while keeping the initial lists in there separate columns
I have been trying to find a formula to lookup both columns and return all the names into another column (E) using the formula below
=IFERROR(INDEX($B$2:$C$600,MOD(ROWS(E$2:E2)-1,ROWS($B$2:$C$600))+1,INT((ROWS(E$2:E2)-1)/ROWS($B$2:$C$600))+1),"")
the plan been to just put column E into my drop down list, but this formula is returning alot of blanks between Column B + C in the list (there might be 100 names in column B and only 30 in column C)
To try remove the blanks I tried another formula pulling the info into Column F,
=IFERROR(INDEX($E$2:$E$5000,AGGREGATE(15,6,(ROW($E$2:$E$5000)-ROW($E$2)+1)/($E$2:$E$5000<>""),ROWS(F$2:F2))),"")
But while this did remove the blanks (about 500 blanks) it left me with about 70 "0" errors.
View 3 Replies
View Related
Nov 23, 2009
I wanted to replace Array(Array(1,1),Array… in TextToColumns.
http://www.ozgrid.com/forum/showthread.php?t=140770
http://www.excelforum.com/excel-prog...o-columns.html
View 9 Replies
View Related
Jul 10, 2006
I have a Master List with 3 colums The first column labeled location has a pull down menu with about 20 different options. The middle column labeled issues is just for text entry. The third column labeled contractor is another pull down menu with 18 options on it. I also have 18 other sheets within the workbook that correspond to the third column pulldown menu.
Heres what I need.
I would like to be able to enter info from columns one and two and be able to choose an option from column three and the info from columns one and two go to the corresponding sheet.
View 9 Replies
View Related
Jan 6, 2009
I have a list of data which is not in any particular order....
View 9 Replies
View Related
Oct 24, 2012
I'm trying to have a drop down list in a spreadsheet which combines the info from two columns.
For example:
A B
1 John 29
2 Sandy 40, etc
And the drop down list turns into
John 29
Sandy 40
Is this possible?
View 1 Replies
View Related
May 24, 2014
conditional formatting in Excel. I have two columns with pertinent information. I need to know the following and format accordingly:
1. Is the number in column A positive or negative?
2. Is the number in column B less than 0.05 or 0.10?
I would then like Column C to just be highlighted a certain color depending on the combination... there are 5 possible combinations and I would like the cells to be formatted so that:
1. Positive and less than 0.05 - Bright yellow
2. Positive and less than 0.10 - Pale yellow
3. Negative and less than 0.05 - Bright green
4. Negative and less than 0.10 - Pale green
5. This "combo" just means the criteria wasn't meant... which is possible b/c sometimes Column A may have text instead of a number of b/c the number in column B is not less than 0.10. If either of these is true, I want the cell to remain blank.
View 5 Replies
View Related
Oct 4, 2011
is there a way to combine the info from several columns into 1 list?
All of my columns have information in rows 1-20, but I want it all to automatically combine into a list in column B on a new sheet.
This is Excel 2007
View 9 Replies
View Related
