2nd IF Does Not Work
Feb 1, 2009Following code has 2 IF statements , the code runs the way it is and the first IF works perfectly, but the second IF does not work.
View 3 Replies
ADVERTISEMENT
Work Out A Formula For My Spreadsheet Which I Use To Work Out Cutting Lists For Timber Frames
Jan 11, 2009i need to work out a formula for my spreadsheet which I use to work out cutting lists for timber frames. I need it to work out if the width of a job is for eg 2400mm i need to work out how many timber studs I need so the space between each stud is between 400mm and 500mm and this will need to work for a range of different sizes of frames. I have it written at the moment and it just devides the width by 400 and gives me a amount of studs but it would work much better if it could space them between 400 & 500.
View 4 Replies View RelatedWork Accurately With Times To Calculate The Work Progress Of The People In The Workshop
Mar 3, 2009In a project i am compiling i need to work accurately with times to calculate the work progress of the people in the workshop thus....here goes....
I have in work book #1 (7) sheets mon to fri + complete week + a sheet where all job numbers are collected.
From monday to friday the workmen log their times as a start time and a end time. This has to be then calculated to a total hours:mins spent per job, wich in turn then has to be calculated to a total hours:mins spent per day. And the on the complete week sheet recalculated as a total time worked per week.
How To Get A Macro To Work With Any Work Book Name
Aug 24, 2009i have a made a macro that copies info to a new sheet now that is working great but if i change the name of the work book it wont work any more so i need the macro to work with what ever name i give the workbook
the current name is
AVERAGE PRICE (update 2009) Mimmos Armico 170809.xls
i have attached the code in notepad ...
Make To Display (0), Instead Of (-0,02) When I Just Do Other Work Than Cad Work
Feb 13, 2010In column J, Cad Hrs. How to make to display (0), instead of (-0,02) when I just do other work than Cad Work? I need to separate type of work according to price hour, overtime, and so on.
View 2 Replies View RelatedCopying A Certain Range In A Work Sheet To Another Existing Work Sheet Using VBA
Dec 29, 2009I have a range of cells in a work sheet "sheet 1 " my objective is to filter this range according to certain criteria (i ve succeeded to do this ) yet what i want to do now is copy this data to another existing worksheet in a certain range .
note :the existing worksheet to which i 'll copy the filtered data has some cells out of the range that i dont want to over write ..
Simply :how to copy a selected range of cells in a work sheet to already existing work sheet in a specific range aswell .
Copy A Formula Across Several Work Sheet And Have The Formula Always Take Data From Previous Work Sheet
Jan 2, 2009I am want to copy a formula across several work sheet and have the formula always take data from previous work sheet.
2) I am working with this formula =C12+INDIRECT((MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)-1)&"!"&"C12")
and it comes from this thread http://www.excelforum.com/excel-gene...orksheets.html. I have included a worksheet attachment that has explanations
Look For / Add Up And Work Out Average Of Value
Dec 20, 2013screenshot.jpg
Ok, so from the attached picture (screenshot.jpg), you will see a data export of staff losses.
On the table to the right, i need cell G2 to take the ID from cell F2 and then search column A and add up every time there is negative number in column B.
So if staff ID has -15 , -15, -10 and -10 in the first table, their summary on the right table will show -50
(PS, i know it says AVERAGE LOSS) but i just need it to be the total. So basically, from the loss log on the left, it just counts the total losses occurred by each individual staff member on the summary table to the right.
Tab To Work Automatically
Nov 16, 2008Is there any way that Tab should automatically jump to next column, after the entry has been made.
I have only one number (one digit) per column. I wish that when I enter the digit the tab should go automatically to next column. And also if it is possible that tab may miss the blank column and go to the next where the entry is to be made.
MIN & MAX VBA Commands Not Seeming To Work
Dec 4, 2009I would like someone to explain the reason why when the program is run, the maximum value in column S successfully is selected by being colored in pink, but the minimum in column R between those pink max's (indicated by the entire row outlined in red) is not the minimum.
In other words, look at the numbers in column R. Only the 14.08 rows are supposed to be boxed in red. I can't understand why the 30.08 and the 46.08 are boxed in red??? And puzzling to me is why the 46.08 near the top are boxed, yet the 46.08 near the bottom are not boxed.
Set Up A 6 Day Work Week
Aug 10, 2006I normally use the WORKDAY function in order to create an involved scheduling
program. However, I have no idea how to create a formula that would count
Saturdays as a workday. I usually type in one date and then the dates kick
out to an end date several months later. How do I create a formula to
include Saturdays on a daily projection (e.g. A1=8/12/06, A2=8/14/06,
A3=8/15/06,etc...)?
IF Statement Does Not Work..?
Nov 5, 2008IF statement does not work?I have a chart on my sheet like so: (it gives me rates of pay)
View 3 Replies View RelatedDoes IF Work With Text
Jan 5, 2012i want to link one cell to another sheet if that cell is not blank. in other words if A2 says Decor, then I want to have the data on Sheet1 in A2 link to Sheet2 and say Decor. i thought i was clever and in the cell i wanted the link to go i wrote
=IF(Sheet1!A2>"",Sheet1!A2)
but it didn't work....
UDF Work In Only One Workbook?
Jul 23, 2013I have some user defined function in an .xlam file that works.
Right now since that .xlam file doesn't auto open. I have a button on specific workbooks that will open that xlam so all the udfs work.
Is there a way to embed the udfs into a specific workbook so that workbook is a standalone without the need for opening a separate xlam file?
Work With Data
Nov 15, 2006I get the following sent to me on a daily basis and I would like to format it so that I can utilize it.
I get this:
GROFKCTotalCalls:3
TotalOrders:0
808-5600Calls:3
UNI1Orders:0
GROHJBTotalCalls:436
TotalOrders:75
3-Nov644-6200Calls:225
UNI1Orders:42
3-Nov646-7979Calls:76
UNI2Orders:15
3-Nov700-2900Calls:89
UNI4Orders:12
What I need is this:
Phone Calls Orders
808-5600 3 0
644-6200 225 42
646-7979 76 15
700-2900 89 12
How would you work with the data I get to produce what I need??? I know a macro can format the data, but maybe there is something else I can utilize that I'm not aware of.
If Not IsDate Seems Not To Work
Apr 15, 2007I have the following:
Private Sub TextBox1_AfterUpdate()
'//Check for valid date
If Not IsDate(TextBox1) Then
Me.TextBox1 = ""
'Show SplashForm2 if not date
SplashForm2.Show
Me.TextBox1.SetFocus
End If
End Sub
I thought this was working but I put 22/07 in TextBox1 and stepping through it it goes from the "If Not statement" to the "End If"
Don't know why it is not recognizing that it is not a date. It is missing the back slash.
Short Cut Does Not Work
Jul 28, 2008I wrote a little macro and put in into presonal workbook. I cant seem to get the short cut to work. When I got into " Tools > Macro > Macros > Options" and put in a letter that I want to use for short cut it does not work.
I am trying to run this macro in another workbook.
How To Work Out Turnover
Nov 19, 2008i need to work out employee turnover in excel has anyone got any useful tips?
i have a spread sheet with start and end dates so i need to work out who was in the company etc
Macro Not Work On Another Tab
Feb 4, 2009To run a macro from the first tab of the workbook but have it do it work on another tab.
In the workbook in question I have a tab called "input" were certain information in updated and is linked or used in formulas on other tabs. Some of the tabs have macros that do various functions. I would like to set up one macro button on the "input" tab that would run the macros on the other tabs instead of having to run each one individually from its own tab.
Below is on of the macros that I would like to run from the "input" tab and have it update the "AP Accrual" tab
Sub CopyPriorMonthAccruals()
ActiveCell.FormulaR1C1 = "=EOMONTH(Input!R[5]C,-1)"
Columns("L:L").Select
Selection.Copy
Columns("Y:Y").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("B3").Select
ActiveCell.FormulaR1C1 = "=EOMONTH(Input!R[5]C,0)"................................
How Does This MACROS Work
Oct 23, 2009I recently took a macros my friend did and adjusted it so it would work for my problem.
It works fine but there is one thing i don't understand about it.
The initial problem was that i needed a macros that could copy a range and paste it 1 cell space to the left and then delete the last cell of that range, so it would look something like this:
FROM THIS:
HIJKLM2NIVEL
3
21
TO THIS:
HIJKLM2NIVEL3
21
so this is the macros i am using which works perfectly:
Range("H1").Select
Selection.End(xlDown).Select
Selection.Offset(0, 2).Select
RC = Cells(Columns.Count, ActiveCell.Row).End(xlUp).Column
Range(ActiveCell, Cells(RC, ActiveCell.Row + 11)).Select
Selection.Copy
ActiveCell.Offset(0, -1).Select
ActiveSheet.Paste
ActiveCell.Offset(0, 4).Select
Selection.ClearContents
What i don't understand is why i have to use the +11 in order for it to move 4 spaces to the right.
Add-In To Work For Different Files
Jun 2, 2006I have created an Add-In and hard-coded the file name assuming that it will be used with a specific file called, let's say, Data_Approval_Project.xls (where Project would change for a praticular Project name, e.g. Data_Approval_Alpha1.xls,
Data_Approval_Beta1.xls). Then I would just need to manually change the path and the file name in the Add-In for a specific user group.
Now I am presented with the case of a " Multiple Project - One User", where the same user will have to work on Alpha1 and Beta1 projects using the same Add-In (which actually accounted only for one of the projects). Is there any easy way to get this fixed?
I was thinking about adding an Input box, asking which project user wants to work on, then write the answer somewhere in the workbook, and find and open the file using something like the "Data_Approval_" & the reply of the input box string command.
Getting Offset To Work
Aug 17, 2006when i enter data it dows not enter into the required cells. I have attached a SS that shows the initial laout and the new one and on sheet 2 the initial code. I thought it mught be a offset issue and have tried various permitations but being a total novice in VBA probably was trying to do something totally alien. On advice from moderators have added a new attachment, but had to zip it due to size
View 3 Replies View RelatedSpreadsheet Uses At Work
Aug 4, 2007The spreadsheet has been around for a long time. Even in the electronic form, it has been around for over a quarter century. How has the electronic spreadsheet improved or changed your job?
I'm taking a course in computer applications and will be using any information I get in replies to this thread in my term paper.
Formula Does Not Work On Some Rows
Aug 11, 2014I have some problem with my excel formula here. It works in some rows but doesn't in others.
I have attached the excel file herewith : Book1.xlsx
IF Function Doesn't Work?
Apr 25, 2014i checked and checked and my IF function just gives me the wrong answer... attached is just a sample data..i have over 230 lines to check actually..
View 4 Replies View RelatedIF Formula Only Work If Particular Cell Is Less Than 50
Aug 7, 2014See the attached workbook.
Please edit the formula in column B so that it only gives a BINGO if the adjacent cell in column G is less than 51.
So cell M16 should not be a BINGO because cell G16 is not less than 51.
Attached Files : Book1.xlsx
Work Schedule Formula Using IF?
Jan 8, 2014Combing these two formulas. I have a work schedule spreadsheet. If the employee is Off I want the value to = 0 (zero hours). But if the cell has a start time I need it to calculate those hours. I know both of the formulas work individually. But I need them to work together.
Formula for when cell says OFF:
=IF(C11="Off",0)
And the second
Formula to calculate hours (based on start time/finish time is the same for all employees)
=($X$4-C11+($X$4<C11))*24
Get Some Dandy IF/Then Statements To Work?
Jan 12, 2014Trying to get some dandy IF/Then statements to work in my favor. I'm trying to get "x" in each row to equal the number in column B IF x is present in column C and represet the cells point in column D (again, only if X is present). Another wrench is that row 6 (offering) is 1 point per dollar they bring so instead of an "x" in column C for that one, I'd like to simply enter the number of points (or dollars) they gave. If 5 dollars, that would equal 5 points. Then, I'd like all the points for week 1/12 to be added up on Column D Row 10.
View 1 Replies View RelatedLine Grpah Not Work
Dec 29, 2006This simple line grpah will not work
for the values which needed to insert i dragged over these:
6
6
5
in that order under each other
the only prob is that the graph shows the first 2 fine but what ever value is in the bottom one it show that value as 0
Text Box Function Won't Work
Nov 21, 2008I can't get the text box function to work on this spreadsheet.
View 2 Replies View Related