Results 1 to 9 of 9

Dynamic Cell Copies... or something.

Threaded View

  1. #1
    Registered User
    Join Date
    07-28-2015
    Location
    chicago, illinois
    MS-Off Ver
    2013
    Posts
    28

    Dynamic Cell Copies... or something.

    Greetings Spreadsheet Gurus! I am back with another basic question for you, but confounding problem for me. Here is what I am trying to do.

    I am trying to figure out the easiest way to copy the following format so that the Column number(text value within cell) is the only thing that increases as a column header.

    Example: Spread sheet with three columns. First column is "Column 1 Description ALPHA" Second Column is "Column 1 Description BRAVO" and the third column is Column 1 Description Charlie"

    I need to figure out a way to copy these three column titles 300 more times and only increase the value after "Column".

    So next would be Column 2 Description Alpha, Column 2 description 2 BRAVO, then Column 2 description CHARLIE

    How do I do this -> Column (x) Description Alpha, Column (x) Description Bravo, Column Description (x) Charlie

    These need to increase sequentially across the row in column form. So Dragging Right instead of Dragging Down to begin the copy process.

    Does that make sense? Thanks!
    Last edited by xDimitrius; 09-20-2015 at 05:52 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF(VLOOKUP) Formula That also Copies Cell Background Color to Target Cell
    By JRidge in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-09-2014, 06:38 AM
  2. [SOLVED] IF(VLOOKUP) Formula That also Copies Cell Background Color to Target Cell
    By JRidge in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-04-2014, 05:32 AM
  3. Print button fucntion to determine if 2 copies or 3 copies are printed
    By internalglitch in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-03-2014, 10:20 AM
  4. macro that copies data in cell and paste it to cell x columns to right in shhet
    By Stevebarnes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2013, 12:14 PM
  5. Macro that copies and pastes value from one cell, if another cell contains data
    By defensorfedei in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-02-2012, 11:54 PM
  6. Automating Dynamic Range or Table copies to Single page
    By pacman_d in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2010, 11:55 PM
  7. dynamic name range that copies formula from previous row to new row
    By hibiscus27 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-20-2007, 04:06 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