Results 1 to 2 of 2

Copying a cell and pasting into a column for a certain number of times

Threaded View

  1. #1
    Registered User
    Join Date
    04-13-2020
    Location
    MD
    MS-Off Ver
    2018
    Posts
    19

    Copying a cell and pasting into a column for a certain number of times

    Hello,

    I am trying to figure out the VBA for the following situation: In the example attached, I want to copy the values entered in cells D2 and D3 and paste them to their respective columns in the "Table" sheet for "Runs" number of times (AKA the amount of rows in the "Runs" column in the first sheet).

    So for example, since cell D2's value is 4, I want this to be pasted 10 times (since the # of runs is 10) in the "Equil Conductivity" column of the "Table" sheet starting in cell A2. The amount of Runs is variable, in the current example it is 10.

    I hope this makes sense

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help copying a column and pasting into a single cell
    By rosscortb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2019, 04:00 AM
  2. Copying and Pasting Multiple Times
    By andrewc in forum Excel General
    Replies: 3
    Last Post: 11-25-2015, 05:58 AM
  3. Replies: 8
    Last Post: 05-17-2014, 02:33 PM
  4. Prevent copying and pasting a cell from a column with data validation to another column
    By kieranoduill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2013, 10:02 AM
  5. Increasing number in formula when copying/pasting into another cell
    By seaottr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-16-2013, 06:24 PM
  6. pasting cell number of times
    By rockstart in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-24-2011, 05:29 PM
  7. Copying and Pasting a cell with a constant number
    By DenDz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-31-2006, 03:00 PM

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