VBA Simple Right Function

Mar 31, 2008

Is there any reason why this wouldn't work in Excel 2007 despite working fine in 2003?

.Range("C2:C15132") = Right(.Range("C2:C15132"), 7)

Simple IF Function

Aug 18, 2008

If Channel A = Channel B, only fill "Primary Channel" (A or B)

If the Revenue A is bigger than Revenue B then take the Channel A as primary and secondary channel column as Channel B

if the Revenue B is bigger than Revenue A then take the Channel B as primary and Channel A as secondary

Sample File

[url]

Mar 27, 2009

I imagine this is a simple conditional SUMIF function. I'd like a cell to add values in e.g. column "d" when that row meets certain criterion in column "a".

In other words, I have a column that has times recorded in minutes, and another that says a person's name which correlates with the times. I'd like a cell on another sheet to give a total sum of minutes for each person.

Ideally, part of the function would translate the minute count into hours/minutes, but I think I can figure out how to do that by changing the format in the cell...

Create A Macro From This Simple Search Function

Aug 24, 2009

I am using excel 2007 for database of a large e-commerce site.
I am creating search-able attributes from keywords found in description, title and meta-data columns.

I am using the following function in "column X" to search 4 columns (see formula) for specific music styles.

Loop Vs. Simple Function, Huge Difference In Speed

Feb 21, 2010

I have a problem with one of my loops, it takes about 17 seconds to do the job of calculating a simple moving average for 200 periods on 20,000 rows. However, if I do the "FillDown" function for the same type of average, it takes 1 second.

Here is the code for the loop:

Simple Function For Calculating Number Of Months Between 2 Dates

Jun 22, 2012

Is there a simple function for calculating the number of months between 2 dates.

Eg 1/5/2012 - 8/9/2020

Simple Ledger

May 30, 2009

This is going to sound very simply to most here I'm sure. I have a need for a simple ledger, credit, debit, balance. I will only have maybe 12 accounts and want to keep track of hand written invoices and payments.

Here's what I would like: I return to my office, click on a tab for an account, enter the date and amount of an invoice in a debit column for that account. When payment is made, enter the amount received in the credit column. Having a running total in the balance column. A monthly statement option would be nice, but not necessary.

I have searched for templates of general ledgers and get results with budgets, projects . . . just too complex for my needs now.

Simple Loop To Get Value

Sep 27, 2008

I just like to do a simple loop but canīt seam to work it out.

I like to loop through column F and on the last cell or the first empty cell I like to get the sum.

how that works? I only find samples which donīt seam to help me much.

Also I would like to know a code to select all cells and rows and copy it into a different worksheet. Like cut and paste with vba.

Simple Nested IF Statement

Mar 7, 2014

I am trying to do a nested IF statement in which if Cell A has a number, display it. If Cell A = "", look in Cell B. If Cell B has a number, display it but if its "", then display Cell C.

I have the IF statement working for the first two pieces but don't know how to incorporate a third statement: =IF(A="",B,A)

This works - how do I get it to check Cell B and show Cell C if B is empty?

Simple Counting Cells

Mar 5, 2009

way to count cells in a spreadsheet (not values in the cells but just the cells themselves). So I have a whole bunch of cells, some are red, some are blue, some are green based on the info i have to keep track of.

so can i write some COUNTIF for red cells green cells, etc

Inputbox For Simple Verification

Jun 3, 2008

I have a VBA userform with various textbox fields like 'Name' and 'Address' and 'Amount'
I would like an input box to pop up that asks the user to 're-enter for verification'
So that they have to type the same thing twice, to protect against typos

How do I code it so the program compares the inputbox to the textbox and passes only if they are identical?

(or even, using two inputboxes instead if that would be easier)

Simple Insert Value Into Cell

Apr 6, 2009

What I would like to do is to insert the text "Agent" into the empty cell A# immediately above the block of names if "Agent" isn't already there. I'm having trouble with the syntax... The cell A# won't always be the same as the position of the block of names varies. In this case it's A9.

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:

Mar 26, 2009

Using Excel 2003. I have a very basic SUM formula I am using to show how many forms are still in-house. Pretty simple.

Column D is how many came in.
Column F is how many were completed.
Column E is what is left.

To get the daily count I take the previous day's Column E, add to today's Column D and subtract today's Column F.

=(E2+D3-F3)
Puts the results in E3.

This formula is copied on down the worksheet which results in:
=(E3+D4-F4), with the results in E4. And so on down Column E.

The problem is that if there is no data entered in Column D or F, the results from E are carried (copied?) as far down as the forumla. i.e., if today's column E results in 4, then that is displayed for as far down as I have copied the formula. What I'd like to do is set the formula so that if there is no data in columns E or F, then there is nothing displayed in Column E.

Simple Private Sub Not Working?

May 7, 2012

Here is my simple Private Sub that I can't get to work,

Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
For Each c In Target

[Code]....

I have a checkbox control that changes the value to "True" or "False" in column 4. Here lies the issue, if I use the check box control to change the value, the private sub does not work. If i type the value of "True" or "False" where the check box control stores its value, the private sub works. I would like to see if there is way to get the private sub to work by simply clicking on the check box control only.

Simple If Array Formula

Mar 10, 2013

Trying to work out array formula.

basically if B2 = list of figures in range(F1:f22) then "G14" otherwise "".

{=if(b2=(F1:F22),"G14","")}

doesn't work.

How To Do Simple Table Lookup

Jun 23, 2013

How to do simple table lookup. I have a table showing #of colors being used for screen printing down one side and qty of shirts ordered going across the top. I would like a formula that when I enter the # of colors and the quantity of shirts it will return the correct price.

12-35
36-71
72-143

1
1.50
1.25
.90

2
2.00
1.50
1.10

3
2.75
1.75
1.30

Sum Of Simple Validation Results

Mar 26, 2014

Cell A1:A10 has a simple validation dropdown list of "Yes", "No", and "NA". Cell B1 has "if" formula if Yes selected in A1 then "1" is the result in cell B1, if no selected then 0 in B1 if NA selected then NA in B1. What is the formula to sum B1:B10, calculating the 1's and ignoring the "NA's"? I tried subtotal, sumif, etc.

Aug 3, 2007

i need a way for a simple input box to come up and request a single generic password prior to runing a macro

Open In A Simple Window

Nov 8, 2007

Is there a way that I can make an excel sheet and save it in a way that when it's opened the person JUST sees the cells in a really simple window...

Not sure if I'm confusing people in how I explain this... but basically I don't want it to show the scroll bars, the A B C D etc and 1 2 3 4 etc, the tool bars... etc. JUST the specified cells in a sheet.

Send A Simple Email

Jan 6, 2008

i need to do is send an email via excel. In previous practice I have used the Activeworkbook.send method, but in this instance I dont want to send an attachment, all I need to do is send an email to someone, making use of the to: cc:subject and main body text fields.

Simple Code In 'Private Sub'

Jan 8, 2008

I usually create fairly simple macros using 'button' feature. However, now I'm using the 'CommandButton', as I had to make buttons highlighted once selected - So I have a choice of five options, whichever the user chooses that option background changes, the others stay grey...anyway, thats the fancy-editing done, but now when i enter a simple instruction - hide rows function - I get the error message "Select method of range class failed"

Here is the full code - like i say it works fine when its just the editing, but when i try to actually hide rows it doesn't work. - I will also add that the code is inside 'Microsoft Excel Objects' and further 'Sheet 1 (INDEX)' - not a module - I'm not sure if this is important.

Private Sub JackStart_click()

JackStart.BackColor = 32896
JackStart.ForeColor = 16777215
JackStart.Font.Bold = True
Majix.BackColor = 8421504
Majix.ForeColor = 0
Majix.Font.Bold = False

Sheets("Bank Reconciliation").Select
Rows("3:3").Select
Selection.EntireRow.Hidden = True

Sheets("INDEX").Select
Range("A1").Select

End Sub

Simple Daily Interest

Aug 31, 2008

does anyone know how to calculate the interest so it matches this? .......

Vba Coding For A Simple Clock

Sep 15, 2008

where can I get vba coding for a simple clock.

I would like the clock to be digital rather than analogue if possible

Removing #DIV/0! From An Simple Calculation

Oct 14, 2008

Im using xl2003.

I'm simply trying to divide column A by column B in column C. However in my field of data A and B are sometimes zero values that return a #DIV/0! answer in C.

Without introducing and more columns how can i eliminate this error value?

Simple Job Cost Sheet

Feb 20, 2009

The job cost controller is not exactly what I need, so I have been trying to create my own. So far my progress has got me to be able to separate each laborer for each job.

Here is my query: I have a drop down menu that lists ten different tasks(i.e. carpentry, painting, demo, etc.) and I want each of the ten tasks to separate themselves. Is this a vlookup function? How do I make excel listen?

Making A Simple Chart

Jun 1, 2009

Im trying to create a bar chart that contains required hours per week with a line of hours worked going across the bars, im struggling to make this work and have basically no experience of making any sort of charts or graphs.

I need to create this using vba but to begin with I cant even make the chart manually! Where its all going wrong is the column line for required hours is so thin it looks rubbish. Its a bar chart then I formatted the series of total hours to be a line chart.

How To Write Simple Array

Dec 25, 2009

i write array like this: Array(1,2,3,4,5,6,7 until 100) how to make it simple, not to write number until 100

Simple Scatter Chart

Jun 16, 2006

.ChartType = xlColumnClustered

plots a chart with stacked columns. So i was wondering what the chart type i should specify to get a simple scatter chart.

Simple Charting Of Talk Times

Nov 26, 2013

I need to create a simple Talk Time Chart displaying our call center's talk time in 30 min increments.

TimeATT
08:00:00:02:03
08:30:00:04:06
09:00:00:03:56
09:30:00:02:57
10:00:00:04:57
10:30:00:03:29
11:00:00:04:41

[Code] .....