Putting Text In A Referenced Cell
Jul 10, 2008
In my excel sheet I have a list of where they go, which are basically excel cells.. i.e. A1 is the top left corner.
What I am trying to figure out how to do is, is there a way that I can get excel to see "A1" and then put it in A1 of another sheet on the bottom. Thus I get the same grid I have on the wall, making a map of my things.
Also, I could just cut and paste, but the problem is I'm working on organizing the stuff on the wall, and if I do it the way I want to, when I move things, they should automatically be moved on the chart.
So basically I need it to look at a cell for the reference, choose text from another cell (which will be concaternated(sp) text), and then place it in the referenced cell in the chart sheet.
View 13 Replies
ADVERTISEMENT
Dec 11, 2009
I want a dialog box to have a label box reference a cell within a work sheet. This referenced cell contains a formula linked to other cells so it will change value.
View 14 Replies
View Related
Dec 15, 2013
I am trying to put text form 3 cells into 1 string. I got the 1st 2 but the 3rd I only want to extra the first part of the cell up to the 1st comma. This is what i have so far:
[Code] ......
For example cell E81 would contain "abc, def, ghi" . I want to add to the string above only "abc" and not the entire cell content.
View 4 Replies
View Related
Jun 1, 2007
Putting Text From A Textbox To A Cell On A Sheet. how do you do this?
View 5 Replies
View Related
Feb 9, 2009
I want to display the contents of cell B5 in A7 by using cell C7 to show the location of the cell to be displayed. Cell C7 has a formula that shows the cell location of information (text) that needs to be displayed. How can I show in A7 the contents of cell reference shown in C7? In figure attached I show an example to better understand. Want in A7 to show the contents of B5 by reading what is in C7. So A7 cell should show word Road.
View 3 Replies
View Related
Feb 24, 2009
I want to be able to automatically put the calculation of one cell, into the text of another cell.
so....
Cell A3 = A2-A1
And in another cell say B3, i want to be able to write text that says "The value of cell A3 is 'A3' "
View 10 Replies
View Related
Jan 8, 2010
I'm trying to enter relatively simple drug calculation formulas in Excel where the result is appended with the proper units to administer. For example, if I'm calculating for units of regular insulin with a formula such as:
=0.75*f2
I'd like the cell to make the above calculation, and append it with "Units Reg Insulin" or something similar. Thus far, I've just been putting the units as text in adjacent cells but the result looks a bit messy.
Is this possible? I'm using Excel 2007 and the Help index does not seem to offer much guidance about this.
View 8 Replies
View Related
Feb 26, 2013
I'm making a vba macro that takes a workbook and splits and saves it as individual sheets. In this process I need to find all the referenced cells (ie =E5) and change them to their text or numeric value. A few things I've found on the form and tired with no success:
Selection is a column selected from the top to the last used cell (I know there is only 4 columns that have references)
VB:
Selection.Copy
Selection.PasteSpecial Paste = xlPasteValues
Also tried:
VB:
ActiveSheet.UsedRange = ActiveSheet.UsedRange.Value
I feel like one of these should be working. But even after the paste the values are still references.
Edit: An afterthought, if I were to select the whole sheet and do a copy/special paste would it replace all formula cells with their calculated value?
View 5 Replies
View Related
May 28, 2008
My macro contains a VLookup formula that is giving me the text of the formula instead of the results. A portion of the macro is, as follows:
Sheets("Survey Results").Select
Range("c1").Value = "Resolving Group"
Range("c2").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],'Survey Invitation'!C[-2]:C[-1],2,FALSE)"
Range("C2").Select
Selection.AutoFill Destination:=Range("C2:C900"), Type:=xlFillDefault
Range("C2:C900").Select
Range("C2").Select
The VLookup statement appears in place of the result when the macro is run. This is Excel 2007 and it runs to the end without error.
View 9 Replies
View Related
Oct 4, 2012
using this format *.#,##0_);*.(#,##0);*.0_);@*. I get this:
Bonds..................................
would like custom format to do this,
Bonds . . . . . . . .
note:@ sign activates text formatting, *=repeats .=character being repeated
I've tried putting space characters before and after the period - no luck
View 2 Replies
View Related
Feb 15, 2009
In cell A1 I have a number representing a column and in cell A2 I have a number representing a row. In A3 I wish to obtain the value from the cell referenced by these two numbers.
ie
A1 = 3
A2 = 4
A3 = value from cell C4 (column 3, row 4). How do I write a formula in A3 to look this value up?? I know about the range function in visual basic but I just want to be able to do this using a spreadsheet formula.
View 3 Replies
View Related
Oct 2, 2009
I'm trying to do a formula that references a cell and returns a different result dependant on the number in the cell being referenced.
For example I've said if A1 has a 3 in it then put the word TEST as the result, plus if it has a 4 put the word RESULT.
What I wrote as my formula is as follows-
=IF(A1=3,"TEST")+IF(A1=4,"RESULT")
It works fine when I only use one result but goes wrong when I add two. If I change the words I want to show to numbers it comes up fine but with words it just returns a Value error.
View 2 Replies
View Related
Dec 28, 2013
If C5 refers to the value in cell C100, C6 refers to the value in C110 ten rows below. C7 refers to C120, ten rows below that and so on. Is there a formula that you use within excel (not a macro) that allows me to copy the C7 formula to C8 so that C8 will reference C130?
I have tried using INDIRECT and OFFSET formulas but cannot do it without an absolute reference to a fixed cell, which defeats the purpose, since I can go into C8 and manually change it to =C130, C9 to =C140 etc.
Currently using Excel 2007 at work and Mac Pro at home. Thought about R1C1 reference, but don't even know how to change to that style on my Mac.
View 9 Replies
View Related
Oct 10, 2009
Is there a way to make a cell populate certain text based on conditions of other cells without putting the formula in the cell you want to populate. So that someone could type other text into the cell if the conditions were not met?
View 14 Replies
View Related
Oct 23, 2008
I tried to put the following formula into a cell using vba, but I received alot of errors. here is the formula I am trying to put into a certain cell and I will use a variable to replace the row number in the formula
=IF(AD323<>"Open","",IF(OR(AND($AI323=TODAY(),$AJ323<>"Done"),AND($AN323=TODAY(),$AO323<>"Done"),AND ($AS323=TODAY(),$AT323<>"Done")),"Yes",""))
View 5 Replies
View Related
Nov 17, 2008
How can I stop #DIV/0! in a cell which has a formula relating to a cell which will have a number inputted but at the moment is empty, without me putting a '0' in?
View 9 Replies
View Related
Mar 27, 2013
I have 15 files in a folder and need vba code which would open every file from the specified folder and add that file name in the row starting cell "D1" in the "Master File". Below is the code which opens the file from the folder, but need the updated code which will add the opened file name. Also can u pls update this code to not open the "Master file" which is in the same folder when it loops..
VB:
Sub Login_summary()
Dim MyPath As String, FilesInPath As String
Dim MyFiles() As String
Dim Fnum As Long
[Code] ....
View 5 Replies
View Related
Nov 11, 2009
I have the following two formulas in a spreadsheet, which sum and count, respectively loan information within a certain date range. Both of these are working correctly.
My problem is in substituting the dates with cell references for dates located in a worksheet with a table of dates. The dates from this table work with simpler formulas, but I cannot get them to work here, regardless of how many () "", etc that I try....
View 9 Replies
View Related
Jan 2, 2008
I have a basic blank file which takes production volumes of a product as an input and breaks the figure down to give individual component usage as an output. It then uses this figure to tell the user the best configuration to hold stock.
This file is 'save as' each month as the month, year and filename (ie: 11.2007MPS.xls, 01.2008MPS.xls) and then the monthly production figures are entered.
Within this file there are 'comparison' worksheets, cells on this page look into the previous months file and tell the user where changes have occurred; showing the physical changes that should be made. This lookup is referenced to a cell that gives the previous month ('MPS INPUT'$D$13), this is filled in by the user.
At current I am using the Vlookup(Indirect formula:
=(VLOOKUP(B4,INDIRECT("'I:SCIPMPS["&'MPS INPUT'!$D$13&"MPSCOPY.xls]Row 2'!$A$2:$N$100"),5,FALSE))
Yet, this requires all the previous months’ files to be open which isn't really feasible in the long run. Solving this issue using custom 'add-ins' (as i believe have) is not feasible either since the file will be used by many users who are not amazingly I.T literate.
View 6 Replies
View Related
Feb 25, 2014
I need to create a cell reference which will allow me to specify a cell in a table by value (using indirect) and pull the value from a cell immediately one row over for use in a formula. Say I have a table Containing column A and B; I want to reference the value of a cell in column A (e.g. "Large Widget") and receive (in the formula) the value in column B (e.g. "41 cm^2").
View 4 Replies
View Related
Jul 10, 2014
Warhammer Quick Reference Desktop.xlsx
Its on book 2.
I'm trying to reference the Cryptek total that I got in the previous area, and put that result into the grand total army point formula. When I reference the solution cell, or even copy and paste the very same equation into it, and then proceed to filter the referenced cells change...
The obvious solution that i thought would work is write =D45 next to Cryptek in the point value column, then if I filter it SHOULD maintain the information from D45 except it doesn't.
View 11 Replies
View Related
Jun 13, 2013
When I try to run the macro, an error comes up saying application-defined or object-defined error. The following code is the line in which I receive the error.
VB : tool.Worksheets("ALL").Cells(row1, "J").Formula = "='[TRB Database.xlsm]TRB Database'!$I$" & A
View 3 Replies
View Related
Sep 25, 2009
I have a row that is a percent of sales with this:
=(F4*0.2+G4*0.1)*I4
"I4 will either be 1.0 or 0.5"
Now I want to have it so if this equation equals less than 100 with I4 being 1.0 to equal 100 OR if I4 is .5 then it should be 50. I have looked all around and I am no excel wizard so this is troubling me significantly.
View 4 Replies
View Related
Oct 10, 2011
I have a sheet with 2 colomns: client number and document number, as follows:
Client number Document number
1234 100012
1234 100042
4321 102233
4321 249123
4321 533213
4567 134123
7890 123451
7890 125675
7890 357353
I need to have a unique client numnber on 1 row with all his documents in one cell, as follows:
client number: document number
1234 100012, 100042
4321 102233, 249123, 533213
4567 134123
7890 123451, 125675, 357353
View 5 Replies
View Related
Sep 19, 2008
This seems simple but I can't figure it out. I want to grab the name of a worksheet and place the name in cell A1.
View 9 Replies
View Related
Jun 23, 2006
It lists single clients on single lines, with various column fields that have autofilters (such as where th client came from, when they arrived, who is dealing with them, are they complete and so forth).
The final entry I need to include is a list of th policies (it is a financial business) they need us to consider, split into three columns of life policies, pensions and investments.
My problem is that I am unable to put more than one policy in each of those columns which can then be sorted through the filters.
How am I going to achieve this, yet still keep one client per line?
View 6 Replies
View Related
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
Jan 16, 2009
I have the following formula in a cell that gives me a sum of items matching certain criteria.
View 3 Replies
View Related
Apr 6, 2014
Referenced cells returning zeros: can these be made blank or string data?
But why I still get the value 0 instead of blank cell when I press ctrl+shift+enter?
My formula = IF(U15="Bank", PROPER(E15),"")
and E15 = VLOOKUP(B15,'Customer Data'!$D$6:$K$100,3,FALSE)
View 5 Replies
View Related
Mar 14, 2014
Trying to get a problem solved to have a % discount & 'flat' $ discount apply to cell(s) referenced. Product A, B & C are available in 3 different materials. Objective is to allow each material's Max Discount column to apply discount(s) referenced in cell J3 & K3, but only in the order of applying the percentage discount BEFORE the 'flat' $ discount.
Formula in cell C3 works IF the cell "Range to apply discount" I3 = "B3". Works just fine if I allow only one cell to be displayed in I3, but ideally, I'd want this to allow the said discount(s) in cell J3 & K3 to apply to any cells mentioned (for instance, for Product A Material 1, Product B Material 2).
I had tried a drop-down menu using Data Validation, which in my actual project allows me to select ONE cell at a time (out of my list of options), which is okay, but it would be extra useful to have a checkbox option to select which ones to apply the same discount to, instead of creating a massive embedded IF function to have each product in each material find whether it's cell is referenced in 20 different places (if I just copy the already functioning single cell reference tool).
The scale in which I'd like to use this in would be to apply specific discounts for one product, but a different discount for another product or material, and allow the input cell I3 to include a checkbox drop-down option (like the filter/sort), but not remove the data in the table (Range A2:G5 in this example), so I can hide any unnecessary columns and print, showing certain products & materials having a 10% discount, while others having a 20% discount, with an additional $5 off, etc.
[URL] ........
View 2 Replies
View Related
