+ Reply to Thread
Results 1 to 9 of 9

Copying cell value with formula

  1. #1
    Registered User
    Join Date
    09-19-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Question Copying cell value with formula

    I have a set of data in
    Column A B C

    If I put value in Cell A1 as 'K' and Cell B1 as 'J' and Cell C1 as 3, the cell value of B1 should be copied 3 times and return it in cell A2, A3 and Cell A4. So I will get the same value of B1 for another 3 times. An example in the attached sheet may help to understand.

    How should I do it?
    Thanks you for helping me.
    Attached Files Attached Files
    Last edited by pal_slg; 09-24-2011 at 01:21 PM. Reason: corrected requirement

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Copying cell value with formula

    Will there always be 5 blank rows between the cells that you want to use for data entry, as per your example?

  3. #3
    Registered User
    Join Date
    09-19-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: Copying cell value with formula

    Quote Originally Posted by Andrew-R View Post
    Will there always be 5 blank rows between the cells that you want to use for data entry, as per your example?
    Sorry, the example was wrong. I just uploaded the corrected one.
    The number I put in column C will be the number of the added rows. If I put 3 there will be 3 extra rows. For 1 It will be only one extra row.
    Thanks for helping.

  4. #4
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Copying cell value with formula

    But there are still 5 rows between the rows that you're using for data entry (rows 1, 7 and 13).

    Are you looking for something that will:

    a) Copy down the value of column B into the blank rows the specified number of times OR

    b) Something that will insert the blank rows when you add new data to the new sheet?

    The solution is very different for each option.

  5. #5
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Copying cell value with formula

    Working on the assumption that the blanks rows were intentional here's your workbook with the first three blocks of formula in.

    I've used conditional formatting to highlight the cells you can use for data entry and you can cut and paste the formula from column A into the non-highlighted rows.

    Is that what you were looking for?
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    09-19-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: Copying cell value with formula

    Quote Originally Posted by Andrew-R View Post
    But there are still 5 rows between the rows that you're using for data entry (rows 1, 7 and 13).

    Are you looking for something that will:

    a) Copy down the value of column B into the blank rows the specified number of times OR

    b) Something that will insert the blank rows when you add new data to the new sheet?

    The solution is very different for each option.
    I think the new attachment will make it more clear. I have given the example with a note in the sheet.
    Thank you
    Attached Files Attached Files

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Copying cell value with formula

    Pal, please don't quote whole posts. Use the REPLY button, not the QUOTE button.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

  8. #8
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Copying cell value with formula

    OK, you can't insert new rows with a formula, you'll need a VBA macro.

    The macro can be triggered by a value being entered in column C, but if you're going to use that column to enter data for the inserted rows it will need some information for when and when not to insert rows, unless you're always going to add new data to the bottom of the sheet, then it doesn't need to insert rows at all, just put values in the relevant cells.

  9. #9
    Registered User
    Join Date
    09-19-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Thumbs up Re: Copying cell value with formula

    Ok I got it.
    Thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1