Basically I am trying to work out the impact of a limited time offer (say 6 months) which offers customers a discount on their phone bill for a period of time (say 12 months).
I'm getting stuck on the formula (if there is one!?) which takes into account the fact the build up and then roll off of customers - i.e. in month 14 the customers that signed up in the first 2 months will no longer benefit from the discount. I have attached a spreadsheet which hopefully illustrates this a bit better!
I'm not sure how this could be done though i'm pretty sure its going to require some VBA instead of conditional formatting. I would like cell B2 to have background colour red for 10 seconds after cell A1 is edited. So every time A1 is edited B2 will change colour for 10 seconds and then back to original formating.
I have one excel file which I plan to send to other person. But I need this file to be openable/valid by this person just 20 days after first opening of the file.
After 20 days this person will not be able to open the file any more.
If A2 and B2 on Sheet("Master") are not highlighted, copy and paste them into Cell A3 and B3 on Sheet("Job List - Numeric"). Do this up to Row 50 on Sheet("Job List - Numeric"). Once Row 50 is filled, jump to pasting to D3 and E3 on Sheet("Job List - Numeric") and continue up to Row 50 and so on....
I need to do this on one sheet in numerical order based upon Column A and another sheet in alphabetical order based upon Column B.
Here is what I have in code so far:
Sub Final() Application.ScreenUpdating = False Dim c As Integer Dim x As Integer For Row = 2 To 145 Range(ActiveCell, Cells(ActiveCell.Row, ActiveCell.Column + 1)).Select
I've got a kind of "menu" sheet that will pull up various reports from Excel spreadsheets. Rather than having the user work with the live data, the menu opens the file and saves it as a copy, closing the original. This is working fine.
The tweak I want to add is, since the user is looking at a copy rather than the live data, I don't want them to save when closing. Is it possible to programatically add a bit of code to the new copy to handle this?
Here's a sample of one of the menu button's code:
Code:
Private Sub CommandButton18_Click() Dim wb As Workbook Set wb = Workbooks.Open(Filename:="J:Z PII OvensRack Repair TrackingRack Repair List.xlsx") With wb.Worksheets("Sheet1") .Unprotect Password:="pass" ActiveWorkbook.Worksheets("Sheet1").Copy End With
I was reading in the sticky post about the new version of Excel that is due out this year. One of the improvements listed was the increase of usable memory by Excel from 1gig to the amount of Windows memory. In reading this, am I to understand that increasing a machine's physical memory above 1gig is useless for Excel in the current version? My specific issue is I have a very involved worksheet that takes about 2.5 minutes to calculate and this will increase as more data is added, it is heavy formula laden. I was going to increase memory from 2gig to 4gig to assist in reducing the calculation time.
I need to attach some of my docs (either excel sheet or word sheet) to my client via email. Supposedly the excel or word sheet is to be fillled by them (certain field) but at the same time i need to protect amendment on some fields. for Example.
user can fill wording within the underline colume but they cannot change my "Diagnosis" word to something else.
I've started looking at a piece of work for ordering and bringing back matching data...
I just know i'm going to run out of If's only too soon...
Ive seen basic index and match formula, and use them now and again, but... do you "stack" them in the same way ... and would they assist with the limiting If's ?
I fear i will have around 20 "SPSA" type references ... and will need to look at diff columns depending on which is relevant... be very grateful for your guidance on the best way to approach this.. as i always end up with a messy workaround.. Thanks Chuf
I am in need of a macro to merge approx 30 csv files, kept in same directory. Csv files are identical format, have one populated worksheet, 6 columns, no headers. However, number of rows will vary. I would like to merge them to a separate excel workbook, with data stacked to one master sheet. Is it also possible to only bring over rows that have than 0 in column E. I have the following macro to merge however, it merges .xls files and it brings over all rows.
Dim ToBook As String Dim ToSheet As Worksheet Dim NumColumns As Integer Dim ToRow As Long Dim FromBook As String Dim FromSheet As Worksheet Dim FromRow As Long Dim LastRow As Long........
Is there any way to make Hack#24 work with more than 5 lists? I followed the information in the book and was able to get 5 secondary cells to have a drop down list that was dependent on the primary cell selection (also from a drop down list). But when I tried to apply this to the next six primary and secondary cells it would not work.
i have an excel document with two tabs, one "data" one "offer" can select parts from a list in "data" (putting a quantity next to the part number) then hit a command button and have the part number, description, quantity and price added to the "offer" tab (i have a smaller version/sample doc if anyone wants to take a look )
I'm building a table (see attached) where I could have a value in cells D6 to P6 that ranges from 0 upwards. In the respective cell beneath each 'value' cell (D7 to P7) I need a formula that will return a figure of 10 if the value in the cell above is 0.4 or below reducing to 0 if the value in the cell above is 1.0 or above.
I am working on an excel master marksheet which will be distributed to many teachers to fill in their students marks. How can I enter an average function that can work out the mean for those different classes. For example I'd like the main average function to be like this =average(d5:d50) but if a teacher has thirty students in his list the mean will be only limited to the marks of those thirty students. Same thing I want for the mode function and the median function.
I have a spreadsheet wherein if I press ctrl-A (normally Select All) it is only selecting a limited range of cells ($B$12:$M$22). If I press ctrl-A again from there then it selects all.
I can see something like that being useful in some cases and annoying in others, but I have no idea what is causing it. Some of the cells in that range are locked and others are not. Some of the cells outside that range are also locked while others are not. In any case, the sheet is not protected.
I've been working on a ss that requires me to create a function to determine a value from a exponential curve where the area of the curve is variable . The terminal points, 0,0 and 100,100 remain constant and the curve is symmetrical at the 45degree angle. How can I derive a function knowing only these things.
Here is an image to crudely illustrate what i mean [url]
The area can be 10, 20, 35% it doesn't matter, I need a way to determine the function from just the area!
1. The example is cell B1 has a drop down list with the following options: MIN, MAX, AVERAGE, MEAN, SUM
The range F2:F20 hold the values upon which I want the formula to work
Cell B3 is to calculate the result of performing the the function defined in B1 over the data set in F2:F20
What formula do I need in B1. I have tried various of methods of forming the above into a text string and then preceding with INDIRECT but my problem seems to be with the range part.
2. Same as above but I want to the users to write as text (without equal sign) the formula they want to use
I have to extact a HUGE (100MEG) .TAB file into Excel 2003. Using the 'import text' fundction it only allows me to import the frst 66536 lines and tells me that I can import the rest by repeating the process, somehow excluding what I have already imported.
I understand the following code finds and selects the last empty cell in column A
Range("A65536").End(xlUp).Offset(1, 0).Select
I am looking for a way to find last empty cell withing a specifice range of cells in column A. Example, I want to loop through from A6 to A16, find the last empty cell and fill it up.
I am using this codes to extract csv in to my workbook, how to extract only the specific no. of rows from a csv instead of all the rows, I would like to extract only the last 5000 rows of data
Code: Option Explicit
Sub ConvertCSVs()
Dim wkbDest As Workbook Dim wksDest As Worksheet Dim strPath As String [Code] .........
As part of an audit program I have a questionnaire. One of the questions has 10 check boxes, one with a combo box and one with a text box. The user will check at least 2 or more answers, but not all 10. (2-4 average). I don’t want to link the answers to specific cells, because I don’t want the answers to display with blank rows between answer on the sheet. I want the answers to display in 2 columns evenly distributed.
I would prefer, to not have to run a macro, if possible, but the only way I could see to do this is a very long if statement base on every combination of answers. If the only way to do this is thru a macro, I would prefer to tie it to the printing of the sheet, or I could make it part of an error checking macro I plan to do. The actual question is in the attached file
I am trying to limit the user from selecting only what has been selected from the first selector. The selection are based on a drop down (data Validation list)
Excel 2007BCDEFGHIJ1LOOKUP Table2Should only allow from 3only what availble from First SelectorBus/Cntry Level 2Bus/Cntry Level 14ALLALL5First SelectorSecond SelectorAPACALL6TerritoryAPACAPACAPAC Regional Office7APACAsia Licensees8APACAustralia9APACChina10APACHong
