Make Cell Result Copy Itself Into Subsequent Cells X Number Of Times?
May 9, 2013
Say I have (cell A1) 10 salespeople and they each sell a (A2) $100/month membership, so I have (A3) $1,000 monthly revenue.
(A4) is an assumption about how many months the average person will stay a member.
So if A4 = 6, (6 month membership assumption) how would I get Excel to output $1,000 (the result from A3) into cells B3 through B8
but then for instance if A4 = 3 (3 month membership assumption) it would only output the the $1,000 result from A3 into cells B3 through B5
So like A1 through A4 of...
10
$100
$1,000
6
would output $1,000 into B3 through B8
but
10
$100
$1,000
3
would output $1,000 only to B3 to B5
View 1 Replies
ADVERTISEMENT
Dec 14, 2013
I am trying to make a column show the result of a formula as positive number only. Right now the column subtracts two other cells and displays the result. I am trying to make it show all the results, positive or negative as positive.
View 3 Replies
View Related
Oct 4, 2011
I'm trying to modify this line:
Range("A2").AutoFill Destination:=Range("A2:A10"), Type:=xlFillSeries
I trying to copy down a formula a set number of times based on a cell value or a declared value.
View 5 Replies
View Related
Dec 18, 2013
I have created a userform with 4 textboxes and "ok" button. whenever I press OK I want it to copy TB1(text),TB2(number) and TB3(number) in the first empty row a number of times based on what is in TB4(number). however, each time it has to add 1 to TB2 and whenever (TB2+1) exceeds 5 then 1 is added to TB3 and TB2 start over from 1 again.
View 3 Replies
View Related
May 7, 2008
I have a task which I am sure can be done quite simply. I have a list of names in column A and a number in column B. I want a Macro to copy the name in column c, d, e etc for the number in column b.
View 9 Replies
View Related
Mar 2, 2007
I am not good at writing codes and so would really appreciate if someone could help me.
I have a range suppose A1:D50 which i want to copy it certain no.of times, say around 50 times below the original range or in another sheet.
Can a code be created where I have a useform , where I will be entering the number for eg.50, which will copy the range 50 times below the original range or in new sheet.
View 9 Replies
View Related
Dec 5, 2007
I want to copy a range of cells and paste them in two different locations and have the new cells relate in data using a command button. This button would be clicked an infinite amount of times to provide the amount of copies desired and to be pasted underneath the previous copy. Example:.............
View 3 Replies
View Related
Feb 15, 2008
I have a requirement to create a master spreadsheet using a macro to copy set cells from several other spreadsheets and paste them into the master one in a list for accounting purposes.
So far the macro reads in the spreadsheet filename(s) and copy/pastes the cells to the master one - I need to be able to paste the values onto subsequent rows for each input sheet which is where my problems lies. Currently the row just pasted in is overwritten over by the following one, I need to go to the next row down but am stuck on how to do it.
Sub EmployeeExp()
'
' EmployeeExp Macro
' Macro recorded 12/02/2008 by eugene.cross
'
Dim i As Integer
Dim f As String
I've attached an example master output sheet to show what I want to produce, albeit this has only one row!
View 7 Replies
View Related
Dec 4, 2009
Just curios if this is the most efficient way to copy a workbook x number of times.
I tried copying 77 workbooks and not sure exactly how long it took, but about 2 mintues. The original workbook is 300 KB.
View 7 Replies
View Related
Jul 22, 2007
I enter a part number in "D1". The number of components required for that part number is returned in "G1" based on a VLookup. I would like a macro that will copy and paste the part number I enter in "D1" in the first empty cell in column "D" and will paste it once for each component (G1) required. For example, if the number of components required is 4, and the first empty cell in column "D" is "D10", I would like to paste the part number in cells "D10", "D11", "D12", and "D13".
View 2 Replies
View Related
Apr 22, 2007
I have a list of values of sheet titled "exclusives" column B Row 2 to Row 250.
Hence, if any of these values are found in sheets "1", "2", "3" and "4" in column C (of each sheet) replace the existing value with "Brand".
In addition after this bit I then need it to look up every new "Brand" and for the eight columns preceding (after) the new value I need to be cleared (any entries in those columns in that specific row of the "Brand" value deleted).
View 9 Replies
View Related
Jan 19, 2009
I have a spreadsheet that has "Branch" Information starting below the heading in Cell C6.
I want to associate the information in the subsequent cells to a corresponding Sector that will be populated in column B6 onwards.
Example:
If the cell Cx has IMTB in it, then cell Bx will be Ops.
There are 6 Main Sectors - (CS, CSM, DM, CBSA, OPS, SPP) that need to be populated into Column B based upon one of the multiple possible Branches that are in Column C. the branch will fall under any ONE of the Sectors.
Essentially, I need to run a loop through, while statement, or something that will generate a true or a false for the entire column and then populate the empty column.
View 9 Replies
View Related
Mar 29, 2014
am making Excel for private use, i need the following makro to be active, here is the idea because i didnt yet work with makros at all:
If A1 = False
then Range B1:D1 will be locked cells
If A1 = True
then Range B1:D1 will be unlocked cells
Those rules apply to 1 day in the year.
the range A1:D1 will be copied about 400 so the makro should be active to each day separatly.
Check the picture attached for example of one day
View 1 Replies
View Related
Jan 4, 2007
I have an excel sheet, Data's range is B2:B5.
The data is listed as follows: Tom, Pete, Steve, Lisa.
I need a VB code to copy and paste the names (range) to J2:J17. By having the names pasted four times each.
The result would look like this:
Tom
Tom
Tom
Tom
Pete
Pete
Pete
Pete
Etc.
View 9 Replies
View Related
Jun 3, 2014
I need a macro to do the following
Assume A1 has 100 & B1 has 20
The macro should divide 100 by 20 & then fill 20 for number of times I get as the answer starting from B3 9 in this case its 5 times
E.g.: B3 , B4 , B5 , B6 , B7 should be filled with 20
If A1 has 200 & B1 has 50
B3, B4 , B5, B6 should be filled with 50
View 1 Replies
View Related
Jun 1, 2009
I have a form that users will fill in, and I need to print a set number of labels (all identical) based on the info that is entered.
I have the form set up with data validation and indirect references(Lists on a separate sheet)
Example...
User enters in:
Customer name
Product name
Lot #
PO#
Date made
Number of items
From there I have a separate set of cells that reference the above info formated to how I want the label to appear when printed.
Now, I need to repeat that label the set number of times (# entered in as "number if items") in a label sort of format (not sure if a mail merge will work for this??)
Then, print off and stick identical labels onto each part that is manufactured per PO/Date etc.
View 9 Replies
View Related
Dec 21, 2009
how do i make a number list. i want to start at 8000 then i want excel to auto generate up to 9000. it will take ages to sitt and punch 8000 8001 8002 ......
Next problem
how can i sett that cell A1 is connected with B1. so when i sort by number it follows. Example:
View 2 Replies
View Related
Nov 17, 2008
Format Random Number Cells As Draw Result Entered ...
View 9 Replies
View Related
Mar 12, 2013
I am keeping track of several items and I am worried when their value falls below a certain level (for the sake of the example I will say 5). In light of this, I would like to be able to tell when an item reports below 5, how many times in a row that item has reported below a 5. The items will be in column A and the results will be shown across the corresponding rows that the item is on.
View 6 Replies
View Related
Jul 28, 2014
need to understand the easiest way of highlighting the highest and lowest number in a range of cells several times in the same column.
As I said the cell range will be in the same column. So highlight the highest number green and lowest number red in cells a3 to a9 and then repeat the same process again in cells a11 to a17 and so on.the cell references are an example.
So I have several separate sets of numbers in the same column.
View 3 Replies
View Related
Jul 30, 2008
I am trying to extract the number of times a name appears on a certain range of cells on a worksheet, now I can get this to work, but I am sure there is a better way I just cant get it to work!
=SUM(COUNTIF(sales1!$B$8:$F$11,A18),COUNTIF(sales2!$B$8:$F$11,A18),COUNTIF(sales!$A$8:$B$11,A18))
I have only used 3 pf the worksheets, but in time there could be up to 30.
View 4 Replies
View Related
Nov 2, 2009
Cell C10 contains 2 possible values, "CLIENTS" or "INDIRECT"
These are also the names of 2 dynamic named ranges
I am trying to use a COUNTIF to validate a subsequent cell, checking if the contents appear in the original list.
=COUNTIF(INDIRECT(C10),D10)
Checks to see if the value entered into D10 is within the dynamic named range, the name of which is entered into cell C10
Gives me a #Ref error
View 9 Replies
View Related
Sep 15, 2014
Need Excel Macro or Formula for finding duplicated cells more than 5 times and copy them into new sheet.
For Example;
apple
orange
apple
banana
apricot
[Code]...
OUTPUT in new Sheet will be
apple 5
orange 5
View 1 Replies
View Related
Aug 5, 2007
I want to count every time a certain cell changes. For example, if C2 is currently set at August 5, 2007 and I change it to August 12, 2007, then add 1 to cell B2.
View 9 Replies
View Related
Oct 2, 2009
I'm trying to do a formula that references a cell and returns a different result dependant on the number in the cell being referenced.
For example I've said if A1 has a 3 in it then put the word TEST as the result, plus if it has a 4 put the word RESULT.
What I wrote as my formula is as follows-
=IF(A1=3,"TEST")+IF(A1=4,"RESULT")
It works fine when I only use one result but goes wrong when I add two. If I change the words I want to show to numbers it comes up fine but with words it just returns a Value error.
View 2 Replies
View Related
Jan 29, 2008
I have a spreadsheet with contact information in it. I am trying to figure out a way to count how many times I click a contacts email address, then tally it in a weekly log. The end result will be a page that totals how many emails I sent each week for the year based on the number of clicks I have made to the spreadsheet.
Ideally I would also like to log the number of times the phone number is clicked too, but I am unsure how to make the phone number a live cell.
View 3 Replies
View Related
Mar 17, 2014
Please see attached sample worksheet. Column A will be generated by the user manually.
I'm looking for a way in VBA to have A1:D20 in Sheet2 copied and pasted in the "Bank Reconciliation" Sheet based on how many "Markets" there are in Column A. Then, once that's complete to have A22:D30 (the smaller box in Sheet2) copied and pasted directly below those results.
I have what the macro would hopefully generate to the right in "Bank Reconciliation" (B6:E54) as an example. So if there's a market in A1, copy and paste the box to B6. If there's a market in A2, copy and paste the box directly below the first (B26) etc. etc. until it's done, then paste the smaller box directly below whatever the macro generates.
Book2.xlsx
View 3 Replies
View Related
Feb 5, 2014
I have been trying to get the row number of a cell to be decided by the integer result of a function. My thought was to do something like this .........(D(MATCHxxxxxx))....... With "D" being the column and "MATCHxxxxx" representing some function that results in an integer.
View 3 Replies
View Related
May 31, 2014
i have this in my 1 cell: ttgtcctacttacaacactgtgcttagtaatggttattgcgactttatccttgttctgaa i want to count how many "a" in this cell . which formula i can use to solve this problem ?
View 8 Replies
View Related
Jan 7, 2013
It doesn't encompass the full spectrum of what I am hoping to have on this timesheet.
For some reason - when I select "REB (0730-1600)", it comes up to 9 hours and not 8.5 hours.
And I cannot have a =SUM column. My goal was to select a shift (Cell 5), it automatically input the hours worked (Cell 7), and then somewhere formulate a total for the week.
View 3 Replies
View Related