Dynamic Cell Copies... or something.

[xDimitrius]

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!

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

To add a file to a new post

To add a file to an existing post.

[FDibbins]

If you are copying thos across column headings (it is a little unclear if you want rows or columns?) then try this, after you have entwered the 1st 3 enties, copied across...
=LEFT(A1,5)&MID(A1,5,FIND(" ",A1,6)-5)*1+1&MID(A1,SEARCH("desc",A1,1)-1,99)

If you are copying down the column, that will work as well

[xDimitrius]

Thank you both for your responses, here is an example workbook attached.

My use of "Lines" within a column header description was confusing so I used "column" instead.

Thanks!

[JohnTopley]

Try

="Column "&INT((COLUMN()-1)/3)+1 &" ALPHA"

Change columns 2 and 3 to BRAVO & CHARLIE

Select all three and drag across columns.

[xDimitrius]

That worked! Thank you so much!

Rep Given!

[JohnTopley]

Thank you for the feedback.

[FDibbins]

John, nice 1 - I was putting something together that would pull out the 1st word, ID the number and add 1, pull out the remaining words

[xDimitrius]

Thank you for the feedback.

I was able to easily modify the text to match what I actually needed. The values I gave you were examples, but the formula you gave me worked like a charm.

Title changed to SOLVED.