Simple Macro For Dividing Cell Content By 100 Needed

Dec 14, 2006

I'm only starting to get into the Macro side of excel, and I've created a couple of macros to automatically format cell contents and the like.
However I'm having trouble trying to divide some cell contents by 100.

I have 2 files I'm working with, one contains information regarding cd's and percentages, however the percentages in this file cannot be formatted to percentages (so the powers that be say) for whatever reason.
I copy all this information into another file which does have the percentages formatted as percentages, the result is that the values get multiplied by 100.

So values that read:
100
50
50.25

for example, appear on the new sheet as:
10000%
50000%
5025%

Is it possible to write a macro that will divide these percentages by 100 so the read correctly as:
100%
50%
50.25%

the macro will have to work on selected ranges.

View 9 Replies


ADVERTISEMENT

Macro Needed To Fill Down Other Cell Base On Condition

Apr 8, 2009

I have accounts that I need to compare to see if they exist on my system the account that has a listed date, exist on my system then if I can fill the dates in the accounts the match then I will be able to delete the other accounts that donít have a date see attach file for more understanding.

View 2 Replies View Related

VBA Macro Needed For Auto Fill Using Another Cell Reference

Apr 28, 2009

Is there anyone who can suggest a solution to my problem below ?
Basically, what I need is a macro which would ideally work like this:

if D32 = 1, then the background colour of D4 should be red
if D32 = 2, then the background colour of D4 should be orange
if D32 = 3, then the background colour of D4 should be yellow
if D32 = 4, then the background colour of D4 should be green

And then I plan to use it for columns E, F, G

View 9 Replies View Related

Simple Cell Value +1 Macro

Jan 24, 2010

I'm trying to write a basic macro which will increase the value in a cell by 1 when I click on the button I've made. I've searched for hours on the Internet, including this site, and found several websites which give a formula needed but none of them work, I always get an "Object variable not set" error or something about sub-functions which I can't recreate so I can't give the full error message. Sorry.

Based on what I've seen on the Internet, I currently have:

View 14 Replies View Related

Using Content Of Cell Within A Macro

Feb 25, 2009

I am attempting to use a cell reference generated using the "address" function and text function (so the cell displays text only, not formula) as a means of defining the top left cell into which I want to paste a column of formulas. The reference cell is static, but the contents is dynamic.

View 3 Replies View Related

VBA Macro Code Needed To Run The Code Contained Within A Cell

Dec 17, 2008

I have a macro that, when run, needs to read the contents of cell B5, and run the code that it contains.

Cell B5, for example, would contain the text:
Range("B13").Formula = "SUM(D12:D14)"

I need a macro to "execute this code", as if it were in the macro itself.

I have assigned the above to a variable, but am not sure how to execute it.

EG.


Dim the_calc
the_calc = Range("B5").value

Now, how do I run the_calc ?

View 9 Replies View Related

Run Macro Everytime Cell Content Changes

Jan 15, 2008

I want a macro to run everytime the value in say cell D6 changes.

View 13 Replies View Related

Run Macro Based On Cell Content

Aug 7, 2006

I have a drop down list made from the Forms toolbar with a list of items: 1, 2, 3, 4, 5. I have set it with a linked cell, so when you choose, say 3, from the dropdown, 3 appears in B10.

I was hoping to add a 'Go' button, which would run another macro depending on what is in B10, i.e. so if 3 was chosen, then you press 'Go', Macro3 would be run.

So I have 5 macros called Macro1 - Macro5, and I need some code for the 'Go' button which will run the right macro depending on what number is in cell B10.

View 9 Replies View Related

Read Cell Content & ADD Content + Font Properties *SOLVE

Sep 12, 2007

I use this to read cell content, add some text/characters (ie. [ and ]) and change the properties of the complete cell

Sub COMMENT()
Worksheets("DVD Lijssie").Activate
If ActiveCell.Value 0 Then ' Change all in to ... ... ...
ActiveCell.FormulaR1C1 = ActiveCell.Value & " " & "]" & " " & "["
With ActiveCell.Font
.Name = "Arial Narrow"
.Size = 8
.ColorIndex = 16
End With
End If
End Sub
HOW can I change this vba-code so it leave's the content of the cell like it is and add some content with the use of let's say TexBox1 and ONLY use different font properties for the newely added content?

View 9 Replies View Related

How To Create A Macro To Edit Cell Content

Nov 9, 2007

I'm trying to create a macro which will edit the content of a cell and update. I'm just using the "Record New Macro" option in tools.

It doesn't seem to perform the F2 edit function within the macro.

I'm sure this has been discussed previously, but I can't get the search function to work for me.

View 9 Replies View Related

Use Macro To Increase Cell Content 10 Points

Nov 17, 2007

I don't know if I am asking for something impossible,but is it possible to create a MACRO to automatically add or subtract 10 to whatever number is in the cell? for example:

A1= 20

I would like to have a macro that lets you either add 10 to it to become 30 or subtract 10 to it to become 10.

View 9 Replies View Related

Macro To Copy Content From Cells Into One Cell

Oct 20, 2008

I have a question.

What code do I need to make the data that is in more cells to be shown as data in one cell ?
ex. A5 D5 to be shown as D2(in a new workbook)
1 1 11

And that for every row?

View 9 Replies View Related

Macro To Delete Specific Cell Content

Apr 24, 2009

I am having some trouble writing a macro to delete cell content. I know which cells I want to clear, but I can't seem to get the macro to do it.

I also want to have something in the macro that inserts data into the lines that I am trying to clear. I want cell A67 to say "Payment" and cell A71 to say "Total."This is the code I am using:
Sub DeleteCell()
Dim i As Integer
For i = 67 To 71
If Range("A" & i).Value = "--" Then
Range("A" & i).Delete
Next i
End Sub

View 9 Replies View Related

AutoFilter Macro Using Cell Content As Criteria

Oct 5, 2006

I was wondering if I could pick up the Field number and the criteria from a cell in excel rather than changing the code in VBA.

Range("A1:K1"). AutoFilter Field:=Range("A1"), Criteria1:=Range("B1")

I was trying this code but I got an error message. Does anyone know if I can pick up these information directly from excel.

View 6 Replies View Related

Macro For Saving Filename Based On Cell Content

Feb 3, 2009

Is it possible to create a macro attached to a button that allows me to save the workbook based on content of 2 cells in the workbook?

I like to save the workbook based on content of cell A4 that contend a text string. After that saving another time with the contend of cell A4 plus cell A9 which contend the today() function. I am doing this because this workbook is constantly updated and a backup copy is done based on the date the file is save.

View 9 Replies View Related

Change Content Of One Cell Based On Content Of Another

Apr 18, 2014

Formula/macro/etc that would enable me to have content of a cell changed based on the content of another cell in the same row.

Example: cell in column D says "PSA" - so I would need the cell in column H for that same row to read "Radio"

I would need an entire sheet scanned to review for these occurrences and make the appropriate changes. I also would need the formula to be inclusive enough to scan for variations in column D cell content (PSA 1, PSA 2, etc).

View 4 Replies View Related

Delete Sheets Macro Needed!

Jan 31, 2009

I have a macro on: Sheet101 (DAY 1) that adds additional sheets.
Example: When I click active button it will add Sheet102 (DAY 2) & can add up to Sheet130 (DAY 30)

I want a macro that will delete any of the sheets added from Sheet130 (DAY 30) to Sheet102 (DAY 2) But WON'T Delete Sheet101 (DAY 1)

Example:
If I have added 3 sheets I want it to delete those 3 Sheets:

Sheet104 (DAY 4) <--DELETE
Sheet103 (DAY 3) <--DELETE
Sheet102 (DAY 2) <--DELETE
Sheet101 (DAY 1) <--DON'T DELETE

& give a vbOkCancel MessageBox saying: Do you want to Delete Added sheets?

Okay the code below works, but one thing!

It deletes DAY 30 to DAY 20, then it skips DAY 19 to DAY 10, then Deletes DAY 9 to DAY 1.
So it's not deleting DAY 10 to DAY 19...

Do I need to add a wildcard?

Here is the Code: .....

View 10 Replies View Related

Macro Needed To Open Folder

Oct 4, 2008

need a macro that will open the following folder

c: my documentskatyexcel

View 9 Replies View Related

Macro Needed For Email/submit Button

Jan 13, 2009

I've got this macro I pulled from some other site and it's not working quite like it should. In my eyes at least...

OK, first, a little back story...
At work we used to have a custom Outlook form that was used for submitting office supply order requests.
The form was stored on our public drive for all to access it when needed.
Well, the form broke somehow and no one knows how to fix it.
We need something to replace it.
Keep in mind that we have no access to the Internet, nor can we send/receive emails outside of the company.

So, I created a simple form in Excel with a drop-down list of all the items in the supply cage, a form field for the senders name, etc...

What the macro does is, it copies the active worksheet the form that just got filled out) to a new workbook (dropdown data is on other sheets in the original) and then opens Outlook (2003) to send it as an attachment.

The only catch is that when the email arrives the only thing filled out is the form fields, NOT the drop downs...

The ONLY way I can get the drop downs to send with data in them is to leave the original open.

Oh, and for some reason every time I sent this while testing, it would name the attachment Book1, Book 2, Book3, and so on. I can't have that...

Here's the code I'm currently using:

View 9 Replies View Related

Macro Needed For Worksheet Change Event

Jul 31, 2008

In Col D of my spreadsheet, I have a list of security codes, in this list there is a security code "all", i need a macro that will add 1 to the code, so it reads "all1", now i need the macro to run as soon as new data is pasted to sheet "Lending", the ranges in Col D do change on a daily basis therefore cell reference for security codes is not fixed.

Can this be achieved? ............

View 9 Replies View Related

Dividing Multiple Arguments In Same Cell

Jul 26, 2014

V = 100 x [E /(IY + YP)] x Sqr. [((R + G)/2 / (IY + YP + F)]
V = 100 x [6.10 /(5.60)] x Sqr. [((10.2+2)/2 / (5.60 + 2.1]
V = 108.93 x Sqr (.79)
V = $96.89 / share as of 7/18/2014

E = Earnings in $ / share 6.1 (b9)
IY = Interest rate in % 5.6 (b10)
R = Profitability Factor in % (internal growth rate)10.2 (b11)
G = Earnings Growth in % / yr. 2 (b12)
F = Inflation Rate in % / yr. 2.1 (b13)

Here's what I have, result should be $96.89, I need to tell excel to take square root of everything to the right not just (B11+ B12)

=100*(+B9/B10)*SQRT(B11+B12)/2/(B10+B13)

View 3 Replies View Related

Diagonally Dividing Individual Cell

Nov 5, 2008

how could divide one single cell in diagonal direction ?? without using line from drawing tool.

View 12 Replies View Related

Recursive Division Macro Mod Needed For Char Type

Nov 11, 2008

I need a slight mod to the below code which works perfectly otherwise. What it does is it divides whatever is in column K by 30 and puts in its relative cell in column M( There a bunch of mini tables below each other with blank rows in between).

The thing is sometimes there are characters in column K like "N/A" for instance and the macro crashes since its only designed to take into account numerical and blank cells in column K.

View 6 Replies View Related

Call One Macro From Multiple Buttons - With Specifics As Needed

May 10, 2009

I've searched through the forums for this information, and I have found a couple of similar issues that have been solved, but copy+pasting the code into my form has not had favorable results.

Basically, here is what I am after:

I have a sheet that already has 4 buttons active, with a handful of other subs that they are calling. I am wanting to be able to add new buttons and have them call a universal macro that will forward them to my existing subs. However, I'm wanting a variable to be set based on the Caption of the button that was clicked. For example:

View 14 Replies View Related

Dividing Range Of Cells With Given Cell Having Formula?

Sep 3, 2012

I am working an Excell sheet. It have many cells with formula like sum of a range of cells etc.

I wanted to divide a range of cells with the given cell (which is inturn having a formula for sum of a range of cells.) want i wanted is to divide a range of cell values with a given cell whose value (number) is obtained through a formula.

when i do

=100*(v65)/v20 for T65 cell and copy the formula for T66-T106 cell range

it is calculating for T66=100*(v66)/v21 and T67=100*(v67)/v22 ........T106=100*(v106)/v61

what I want is all the cells T66=100*(v66)/v20 ... T106=100*(v106)/v20.

View 1 Replies View Related

Vb Code Macro Needed To Transpose Data From Columns To Rows

Oct 14, 2008

i have the following spreadsheet with dummy data however, there is a before and after scenario i have posted is this possible with a macro ...

View 9 Replies View Related

Dividing Number Of Steps In One Cell Into Multiple Cells?

Aug 15, 2014

I have the onerous task of dividing up a series of steps in one cell into multiple cells. I tried the text to columns utility, but it only delimits once, not multiple times. Below is a data example:

"1) Load App
2) Login using Administrator Access details .
3) Click on icon 'Admin' on the right hand side of page.
4) click on subcategory 'Administration'"

"1) Load App
2) Login using Administrator Access details .
3) Click on icon 'Admin' on the right hand side of page.
4) Click on subcategory 'Administration' .
5) Click on any Organization name from 'Organization' section in the list.
Or click on 'Add Organization' icon in section 'Organization' .
6) Validate field 'Parent Organization' in 'New Organization' or 'Edit Organization' form"
"1) Load Documoto.
2) Login using Administrator Access details .
3) Click on icon 'Admin' on the right hand side of page.
4) Click on subcategory 'Administration' .
5) Click on any Organization name from 'Organization' section in the list.
Or click on 'Add Organization' icon in section 'Organization' .
6) Validate field 'Tenant ERP Accessible' in 'New Organization' or 'Edit Organization' form"

1) Load App
2) Login using Administrator Access details .
3) Click on icon 'Admin' on the right hand side of page.
4) Click on subcategory 'Administration' .
5) Click on any Organization name from 'Organization' section in the list.
Or click on 'Add Organization' icon in section 'Organization' .
6) Validate field 'DMZ license key expiration period ' by click on checkbox or by 'Uncheck' checkbox"

I need to put each step into it's own cell.

View 1 Replies View Related

Dividing Data In A Cell If Conditions Met In Another Cell

Jan 4, 2009

I'm a Graphic Designer and am just starting to learn how much fun Excel can be. I'm still learning things though and this is an easy one I think, but I can not figure it out.

All I want to do is the following...

If there is any data present at all in column B on a particular row, then I want the number on the same row in Column D to be divided by 2.

In the example below... TB_5129-001 is present in B8. So I would want $45.00 (D8) to be divided by two automatically. Also, if B8 were to be blank i would want D8 to be left alone.

View 7 Replies View Related

Excel 2010 :: Dividing Numbers By Number Of Cell They Are Found In?

Feb 13, 2012

I am using excel 2007 or 2010.

I need to divide the numbers on sheet 1 column D. This column contains numbers and blank cells so I need to divide by the actual number of cells that contain only numbers. I will be referencing the divided numbers on sheet 2 in a monthly summary format.

View 3 Replies View Related

Dividing Hard-coded Data By Named Fixed Cell?

Feb 6, 2014

I am trying to divide hard coded financial data by a named cell that will allow me to toggle viewing the financial data in dollars, thousands of dollars, and millions of dollars. I have named my toggle cell _000s and I have used Go To Special to highlight all of the hard coded data in my financial spreadsheet. Once I have done this I would like to Copy my _000s toggle and divide the hard coded values by this cell. I am using copy and then paste special divide by but I am having no luck with this tactic.

faster more efficient way to go about this rather than individually changing each hard coded item?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved