I am getting a major headache trying to think of a formula to make desired calculations and may come to the conclusion that one does not exist. Basically I want a formula that will calculate the split in investments required to provide an equal income for 2 people. The income will also be dependent on an income rate, which in turn is dependent on the age of each person. Not sure how else to explain it but I've attached a spreadsheet to help in this. Sheet 1 titled 'Income Rates' shows the income rate applicable to specific ages.

This is the code I am using - please help me to have it pop up only when the file is truly open and idle.

In This Workbook:

Private Sub Workbook_Open()
On Error Resume Next
Application.OnTime RunWhen, "SaveAndClose", , False
On Error GoTo 0
RunWhen = Now + TimeSerial(0, NUM_MINUTES, 0)
Application.OnTime RunWhen, "SaveAndClose", , True
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
On Error Resume Next
Application.OnTime RunWhen, "SaveAndClose", , False
On Error GoTo 0
End Sub

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

her is what i am trying to do ...
i want to be able to see total amounts for card payments and cash payments (coloum H and I.)
The totals need to be seperate and monthly ..
they will then be sent to a monthly totals sheet ..
i have added a screen shot of the 2 sheets

Looking for some assistance on a SUMIFS formula. I had copied and pasted from a previous working nearly identical formula.

The ranges are named exactly like the last formula I copied, yet the percentage at the bottom does not change like the last formula did.

What did I miss?

I currently have an If formula that reads like the image below.

I'm wondering if it's possible to say: that IF the Actual $, is doubled from the goal, then M14 would be doubled. I would rather use a formula for Actuals being doubled from the goal, in case the Goal #'s change in the future.

Currently, if the salesman does not meet their week 1 goal, it subtracts half of M14. Same with week #2. The entire section is worth 20% (as a pay deduction), but I would like to be able to say that it could go so far as a 20% extra credit if they double their weekly goals.

I need to show how many recorded registrations happened per hour over a two day period. For each registration a timestamp was recorded.

I have no idea where to start with this one?

hello all

in the attached file, i have created a userform and i am very new in coding, currently my userform enters data in the first empty row, but i want to create a texbox to put the number of the row in which the user wants to enter his data in, and the user press submit button the data will go to the relevent row based on the number he entered

Note: press on button 18 to start the userform

can some one explaine this please

Run Time Error 9
script out of range

Private Sub Workbook_Open()
Dim i, Lastrow
Lastrow = Sheets("Master").Range("A" & Rows.Count).End(xlUp).Row
Sheets("Card Takings").Range("A2:N10000").ClearContents
For i = 2 To Lastrow
If Sheets("Master").Cells(i, "D").Value = "Card Payment" Then
Sheets("Master").Cells(i, "D").EntireRow.Copy Destination:=Sheets("Card Takings").Range("A" & Rows.Count).End(xlUp).Offset(1)
End If
Next i

End Sub

can any one see whats wrong with this ... i copied and pasted from another that is woking fine and just changed the sheet names

HI

I now have several codes in several different code windows ...
each time i want to up date the file i have to select the code windows of all and run .... is there an eaiser way of doing this with out selecting each code window and running it

hi guys .. i am not trained on vba, however have been working away at it from utube and verious other sites on the internet .. i am building a spreadsheet for my accounts and have the bacis lay out and have allready done some of the vba coding for some of the sheets and they are working fine ... however i now need to do another one but its causing me a problem ...

basically i want to move infomation from one sheet to another according to the following

monthly amounts from a master sheet and then placed with totals in coloums like this ..

january febuary march

Hi

Excelexpert kindly created a workbook/sheet/program (using Excel 2003) for us to log, inventory and track movement of our archiving for our clients.
We have just upgraded our PCs to newer versions and they came with Office 2013 already installed.

Now our beloved archiving program throws up:

The following features cannot be saved in macro-free workbooks:
VB Project
To save a file with these features, click NO, and then choose a macro-enabled file type in the file type list.
To continue saving as a macro-free workbook, click yes.

I click NO and get an error which states:

SO, I would like to import file names into an existing spreadsheet. I use CMD to generate the list, open the .txt file & set the delimiter, but it always overwrites my existing spreadsheet. Is there a way to code so that you can import the text w/ out overwriting the spreadsheet I need the data in? Any help is appreciated, thanks in advance. . .

Excel 2007-Date & Time Issue
Dear
I am using Excel 2007 with Windows XP. I am facing a problem with the following:

Project Start Time 22-04-2015 12:30:00
Project End Time 24-04-2015 20:30:00

Shift Start Time 11:00:00
Shift End Time 21:30:00

The total time spent on the project is 29 hours but a simple subtraction is not working and is giving me 56 hours as its taking time beyond Shift End Time 21:30:00.

Any suggestions on how to get this regularized.

I have team that works on projects that run over days.

My issue is tracking their productivity as we do not have a tool for it.

We work on company reports or industry reports or newsletters and each takes anything between 8 to 40 hours with breaks in between.

I have access to the following data points:

Request Received Date and Time
Request Assigned Date and Time
Work Begun Date and Time
Work Ending Date and Time

The issue I face is that the work can be received today and assigned maybe tomorrow or day after. Work can begin on the assignment 2 days hence or 4 days hence.

Is it normal to experience freezing, rebooting, or lagging when creating a new Powerview Dashboard, or working with Powerpivot?

Hi

I am currently carrying out a large mandrolic activity in inputting data from one of our departments on a weekly basis, tabulating extensive data from dates provided in an Excel Project Plan for use in our weekly KPI tables.

The data is laid out as it is in sheet1, and I am trying to automate the plan to output to the table in sheet2.

I have tried a couple of Index array formualas to gather the necessary data, however, I cannot see anything to give me the output to then write in a macro by combining the Dates as slpit in x2 fields and outputing it by the plan phase.

Hi I am trying to create a report for an assignment.
Need to write macros for a couple of things. can someone please help me?

Please see attached workbook :
Data Tabs 1 - 12 represent months over a rolling 12 month period.
Essentially this is where raw data for each month will be placed. - I have put Dummy data in.

Requirement for Agency Report:
Refer to the Agency Report tab :

This report will showcase each agency with total number of brands and total number of POI’s.

Hello all,

my question will probably sound simple, as I have just started learning programming with VBA.

I am trying to use the content of multiple csv files and write it all in an excel spreasheet. All my csv files are the same, and I want to get the content (for example) of column 2,3,4 and 10 from line 27 to the end of file (which is on line 390) for each file. I want the content of each file written side by side in my excel sheet.

I need to calculate tolerance intervals in Excel. I would prefer the calculation for a regression, but will try figure out how to use a population tolerance interval with a regression if that is all that is available. I should be able to set the following for the calculation: Confidence Level (CL), % of population (%P) and whether it is an upper, lower or two-sided tolerance interval (Type). That is, I might want to do a calculation using an upper tolerance interval the shows with 95% confidence that 99% of the population will be within that bound.

i have a problem with writing the result of the macro (the array) to the cells of the sheet its done slow whitch cause to be miss value at the cell

the code :

Public n1 As Integer
Public changeflag as boolean
public st as string
dim arr(1 to 10) as integer
Private Sub Worksheet_Change(ByVal Target As Range)
If changeflag = true then exit sub
changeflag = true
If Cells(1, 1).Value <> st Then
st = Cells(1, 1).Value
n1 = n1 + 1
End If

arr(n1)=*number* ' the number updated by the formula i wrote..................... ' until this point all is ok

i have a workbook where the first three rows are 'frozen' on purpose. the rest of the workbook is data that is updated daily. i want to be able to print what i see on the screen, the 'frozen' rows as well as the data entered for the day ie. the frozen rows 1-3 and the daily data rows 200-230. with a simple macro if possible. several people use this and some find it very difficult having to try to going into the print options each day for a printout of the new list without getting the whole list. thanks

I'm trying to Count the number of times Column B contains X when Column A contains Y.

For example: Column A is a list of colors (Red, Blue, Green, etc) and Column B contains multiple names in each cell (Matt, Joe, Paul, etc).

I want to count how many times Column B contains "Matt" only when Column A meets criteria of "Red". If Column A3 contains Blue, I don't want to look in B3 for "Matt". What I'm looking for in the end is the total number of times that "Matt" is displayed in B:B whenever A:A=Red.

I have multiple files with different sheet names and varying # of rows.
I need a macro that sorts the data by the header "Contribution" smallest to largest.

I need a formula that finds the headers "Profit" & "Sales" in the 1st row and divides profit by sales (ie: =sum(Profit/Sales))

how to extract data from two coordonates made from numbers

please see attached file.

Dear all,

I am trying to create a formula that will find a set of numbers within a column, and then find the 'min' value of that specific set. For example, in the data attached/below, I want to find a min amplitude between each time interval written across the top. So an example of this would be the 'min' amplitude between time intervals 0 and 10 would be -33.26416, and the min amplitude between times 11 and 20 would be 0.610.

Hi Guys
First post here
Im looking to colour a cell red if an invoice is past its due date of 91 days.
I was try to create if today>CELL+91 then red cell
But I just cant remember how to do it
ANy help would be great

I need the code to use for a VBA textbox in excel.
1. I want to scan a UPC code into a textbox then write the data to cell "a5"
2. next enter a qty on hand into another text box and write this data to cell "b5"
3. next repeat step 1- except write the UPC to the next available cell in column "A"
4. next repeat step 2- except write the UPC to the next available cell in column "B"
then continue the loop