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

Make Column Show Result Of Formula As Positive Number Only?

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

Copy Down X Number Of Times

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

Copy Fields Number Of Times

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

Copy And Paste A Number Of Times

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

Copy Ranges Certain Number Of Times

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

Copy Range & Subsequent Copies To Be Linked To 1st

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

Open Found Files & Copy / Paste Onto Subsequent Rows

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

Macro To Copy Existing Workbook X Number Of Times

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

Copy & Paste Specific Number Of Times Based On Value

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

Macro To Replace Cells And Subsequent Rows

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

Associate The Information In The Subsequent Cells To A Corresponding Sector

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

How To Make Macro To Lock Certain Cells Connected To Another Cells Value Then Copy Daily

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

Copy & Paste Cells Several Times.

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

Macro To Fill Cells For Number Of Times With Value Divided

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

Repeating Multiple Cells A Set Number Of Times To Print Labels

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

Make A Number List And Combine 2 Cells

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

Format Random Number Cells As Draw Result Entered

Nov 17, 2008

Format Random Number Cells As Draw Result Entered ...

View 9 Replies View Related

How Many Times In A Row Result Has Been Below A Certain Value

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

Highlight Highest And Lowest Number In Range Of Cells Several Times In Same Column?

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

Countif (extract The Number Of Times A Name Appears On A Certain Range Of Cells On A Worksheet)

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

COUNTIF To Validate A Subsequent Cell

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

Macro Or Formula For Finding Duplicated Cells More Than X Times And Copy

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

Count Number Of Times A Certain Cell Changes?

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

IF Formula That References A Cell And Returns A Different Result Dependant On The Number In The Cell Being Referenced

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

Log Number Of Times A Hyperlink Cell Is Clicked

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

Copy And Paste Range Of Cells Based On Number Of Cell Values In Column A

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

Designating Function's Result As Row Number For Cell?

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

Count Number Of Times Letter A Appears In Cell?

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

VLOOKUP - Cannot Add Times To Make A Total

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







Copyrights 2005-15 www.BigResource.com, All rights reserved