# Make A Cell's Values Become A Formula

May 23, 2008
I have on my Sheet named "Data" in Cell K4

=CONCATENATE(L16,O25,L18,O25,K20,S25,N22)

The values of that cell become a formula.

I try to make a macro that pastes 'Data'!K4 into 'Data'!L3 and then have that formula functioning in cell 'Sheet1'!A31.

The problem is when I try to make a macro to do this it will always paste the values that were recorded during the macro rather than the unique formula that is created via cell 'Data'!K4 at the time.

Is there any way to have A31 actively using the values that are created with 'Data'!K4? at all times?

View 9 Replies
ADVERTISEMENT
Feb 26, 2013

How do I make a formula based on two incremental values

e.g I drag this down

=ROWS(A$1:$A1)*B$4

where B4 is say 0.2

I will get

0.2

0.4

0.6 etc

But what if I want to start from 5 so it will be like this

5.2

5.4

5.6 etc

View 2 Replies
View Related
May 29, 2009

I do data entry for a webstore and one cell is used to map out the exact product category/subcategory path. I currently have to copy the appropriate path from a long list on one page and then paste it into the cell. I have to do this a hundred times a day. It would be nice if each cell within that column can have these values stored in them so I can just click on the cell and open up a drag down box and select the needed value. Is this possible to do in Excel?

View 2 Replies
View Related
Oct 17, 2013

Is it possible to make tab names dependent on Cell Values?

I have 12 Tabs in Workbook 1

Tab 1 = "COVER PAGE"

I would like Tab 2 ='COVER PAGE'!A1

Tab 3 ='COVER PAGE'!B1

Tab 4 ='COVER PAGE'!C1

etc...

Is this possible so that I can add cells (between B1 and C1) at a later date and have all the tab names change depending on the values I put in the cells?

View 9 Replies
View Related
Sep 1, 2009

I have a large spreadsheet with many pieces of equipment in it. There are a few piece that I would like to highlight should thier computer license go out of date, or even better 30 days prior. I have a Feild with the Expire dates but it is at the end of the spreadsheet not in plain sight. Is there a way to make my Equipment description column highlight when the date in the other column reaches the current date (or 30 Days before). I have cut and pasted the part of the spreadsheet into a new file to make it easier to read and hid all the none important feilds.

View 5 Replies
View Related
Oct 29, 2009

I am looking for a formula that will work with my current formula, and check that cells a1 and b1 contains information. If they do contain info then the original formula should carry on as usual and leave the answer in cell c1. I also need it so when no information has been entered in cells A1 and B1, C1 will be blank instead of containing a zero.

This is the formula I have at the moment:

=IF(SUM(A1=0,B1>0),B1-A1,"No Charge?")

A B C

10.1810.82

View 14 Replies
View Related
Jan 15, 2010

Heres my current formula but its justreturning text i would like it to return the cells value

=IF((J2>K2);"value=J2";"(value=k2)")

View 2 Replies
View Related
Mar 20, 2009

I want my formula to output a blank cell if the answer is 0. Ex. [B1=IF(A1=0, ???, A1)]. I want B1 = A1 if A1 is not 0. I want B1 to output a blank cell if A1 = 0.

View 3 Replies
View Related
May 29, 2009

I have a formula that combines the the text of various cells.

Is there a way to automatically make part of the cell Bold - so in this case I want the Cell B13 to appear in bold.

See formula below:

View 3 Replies
View Related
Feb 9, 2010

I have a formula that looks like this : ='G:STOCKS[1001 Stock.xls]Matl%'!$I$32

There are hundreds of similar formulas, all referencing different cells in the same file. The “1001” bit refers to the date, and next month it will need to say “1002” to pick up the new month's file. I would like to hold the “1002” bit in a cell (say A1), so that at month end, I just change that one cell, and all the formulas will point to the new file, but I’m not sure how to work that into the formula.

View 2 Replies
View Related
Jul 15, 2009

I want to use a value in one cell as a row designation, and a value in another cell as a column designation. Ultimately, the values will be text which will refer to row and column headers. What formula would allow me to do this? example:

A1 contains B

B1 contains 2

B2 contains "tribbles"

An imaginary function might go like this........

View 3 Replies
View Related
Jul 28, 2014

How would you write a formula where the sum depends on what dates you enter in A1 and B1?

Date cells C1 to C365

A1 start date

B1 end date

Example:

A1 = 1/1/14

B1 = 1/31/14

So cells C1 to C31 will be added.

"=sum(c1:offset(c1,(b1-a1),0))

This formula works, except if you enter a different starting dates, it just counts from c1.

View 1 Replies
View Related
Jun 10, 2006

I'm creating a "universal-fluctuating" vendor inventory return worksheet for a auto parts store that consist of one criteria (cores, warranties, or N/R ) and will return one or two results of core cost and/or unit cost. This part of the task I have accomplished by using a drop down list for my criteria and my results will appear in two different columns using a Vlookup table. The problem is due to inventory fluctuating from cores and waranties on a month by month basis, vendor requiremnts differ for the number of units returned, and last make the boss happy on ink and papers supplies :D I was wondering if it is possible loop my code in a given column where it will move my code to the next row untill I reach a grand total?

View 8 Replies
View Related
May 11, 2014

I've got a table of different values in column A.

I'd like the cell D2 ("order") to show up at column B next to the closest value of 35.00 of column A.

Consequently, how to make "order" meet the closest several value of 35.00?

I've attached a xlxs file with more detailed description.

Ex_closest_11_05.xlsxâ€Ž

View 14 Replies
View Related
Mar 10, 2008

i have a formula that will return both negative and positive numbers. If it's negative it obviously shows a "-" sign. How do I force it to display a "+" if the result is positive?

View 9 Replies
View Related
Jan 31, 2013

I have the following line of code:

Code:

Range("D" & LastRow).Value = Area.Text + Level.Text

Area and Level are both comboboxes on a userform, I want them to both go to the same cell but with a space between them. Right now it looks like "AreaLevel" but I want it to look like "Area Level".

I assume that I can do this by making each value in the combobox have a space after it but I would like to know the proper way of doing it...

View 3 Replies
View Related
Oct 22, 2008

I've two collumns, after some index the values of cells are zero

how i can draw a chart without selecting those zero cells?

View 6 Replies
View Related
Nov 18, 2013

I've developed a spreadsheet that shows what errors people made in their spreadsheets. I compare cell A1 in spreadsheet 1 (original) against cell A1 in spreadsheet 2 (final), in spreadsheet 3. Spreadsheet 3 shows a "-" if the cell they wrote was OK, and shows the new, correct value if they made an error, as follows:

=IF('Final'!A5='Original'!A5, "-",'Final'!A5)

The problem is, this only works if I take the original spreadsheets, which contain formulae in each cell, and paste them into a new spreadsheet using paste values.

Is it possible for the IF function to search the formula in a cell, and not the value?

View 1 Replies
View Related
Jul 6, 2008

my destination cells will have formulas like:

='E:My WorkTestData[CCC.xlsx]Input'!$S$31

Everything works fine. But I don't want the destination cells to display the full formula, but the actual Value only

I thought of a way to build a script that first builds the formula to one cell then Copy Paste Special value of that Cell to my desired Cell.

But when the code runs The cursor moves back and forth all the time...

View 9 Replies
View Related
Feb 26, 2014

See attached file with a smaller sample of the 1667 row table of data I am working with. What I am looking to do is make a list on another sheet of each every line with a county and have the corresponding Township and range with it. So if I have a cell and I select Audubon county, I would like a list to populate that has the 12 lines of Audubon county in column A, and the Township in column B and the Range in column C.

Excel Rate Example.xlsx

View 5 Replies
View Related
Sep 26, 2013

I need to make an IF statement that when it's true it need to retrieve the values from a different column. With what function is it possible to just retrieves values?

I need to return the value from pivot table. Forgot to mention this.

View 4 Replies
View Related
Apr 23, 2009

I have a column of numerical values: fields a1 to a10. Then, I have four fields – c1 to c4 – in which I want sums of some chosen values from column a to be summed up. Eg., c1 is to be a2+a3+a9, c2 is to be a4, c3 is void, c4 is a1+a8. The other a fields are ignored, and no a field will be counted twice. Now, I want to put something –*a letter or a number or so –*into the fields b1 to b10, that makes the aforestanding value sum up to a certain field in column c. Like, I put a "1", or maybe an "a", into b2 and b3 and b9, and that makes a2, a3, and a9 sum up to c1. So I'd need something that says: if this cell is "1", add the value in the cell to your left to the sum that makes the value in c1. As you can tell by my writing, I'm no geek in these matters.

View 4 Replies
View Related
Jul 17, 2013

I have a chart with percentages and most of them are >40% so I would like te values to start at 40 in the y axis but I would also want to have the 0% show (as it stands there is nothing there) It is a double y axis chart where the % is shown with just a dot and the other Y axis is the actual column. Im not sure if I'm making sense but I would just like to have the 1st value in the secondary y axis be 0 and the 2nd value be 40, and from that point forward scale in intervals of 5%.

So the values in the y axis are: 0%, 40%, 45%, 50%......

View 1 Replies
View Related
Nov 20, 2013

I have a file and i want to make an exact copy with only values and the layout.

I can do copy paste each sheet in the new file one by one. with first the values and then the layout.

But the file has lot of sheets so it would be great to find a faster way then do it one by one.

View 1 Replies
View Related
Apr 19, 2006

I have made spreadsheet that calculates my total cost of making ice cream mix based on ingredient costs of two variables (Van_Gal, and Choc_Gal), for example 550 gallons and 750 gallons respectively. The worksheet calculates the total cost of making the Vanilla Gallons and the Chocolate Gallons. I’m not a VBA or Macro wiz, and now I’d like to Make a macro that will allow me to make a “table” of calculated costs associated with different assumed Vani_Gal and Choc_Gal amounts and then print the values; and then go down a row and print the cost of another amount of Vani_Gal and Choc_Gals until some preset end has been reached. For example:

Van_Gal; Choc_Gal;TOTOutput;avg cost

550; 750; 1300; $4,000.00; $3.08

600; 700; 1300; $4,250.00; $3.27

Let’s say that I want to know what the tot cost and avg cost per gallon for various combinations of Vanilla and Chocolate Mix from 550 V and 750 Choc for various combos and have it increase in iterations of 10 Gallons (i.e. 560 Van and 740 Choc); Maybe I'd use a " loop" that repeats calculations and prints them for different combinations of Van/choc until 800 Gals Van and 500 gal Choc. Once I have a table of values, I could sort it and find an optimal production level (with the Minimum avg cost). how to make a macro that can crank out a table like this?

View 4 Replies
View Related
Aug 9, 2013

how can i extract all number values from a table column and list them on a separate worksheet? there are blanks in the table column, which have to be omitted.

View 14 Replies
View Related
Sep 23, 2008

Total newbie trying to use excel for work here. I have two problems that both need the use of "is NOT in another column". 1. I need to count the number of instances in a column that do NOT have the word "fly" in column G. The current formula is...

View 2 Replies
View Related
Feb 24, 2009

If i wanted to tack on something to the end of a formula so that it would make every 50 add 1 (example: 200 would convert to 204, because 200 divided by 50 is 4).

View 9 Replies
View Related
Jun 12, 2008

how to use a cell value in a formula with VBA.

For example, I have the following

FinalRow = Cells(65536, 1).End(xlUp).Row

CYGP = Cells(Final Row, 11).Column

Cells(FinalRow + 2, CYGP).Select

I now need to be able to use the value that's located in the selected cell elsewhere in the spreadsheet. I've tried the following:

ActiveCell.FormulaR1C1 = "=R[FinalRow]C[CYGP]

This was an attempt to put the value that's in Cells(FinalRow, CYGP) into my active cell, but it's not working...

View 9 Replies
View Related
Feb 17, 2014

I got a macro to copy and paste values onto another tab within my worksheet. I have a lot of data and currently takes about 30 seconds to calculate and paste. Not sure if its an issue with my macro or with my computer (Mac - Excel 2011).

Here is an example of my macro:

Sub SimulateWeek()

If Range("AdvanceWeek").Value = "Week 1" Then

Range("Week1B").Copy

Sheets("Schedule - Results").Range("C2").PasteSpecial Paste:=xlPasteValues

[Code]....

(this continues on until 'ElseIf Range("AdvanceWeek").Value = "Week 31"....etc). So you can see I have the same code repeated 31 times.

View 2 Replies
View Related