Two-way mirrored cells question

jdeviant,

Firstly, Ranges are everything in Excel. Your range can be multiple cells across multiple rows and or multiple columns, or it can be a single cell.

e.g. Range("A1")

Ranges can be dynamic. e.g Range("A" & i), where i is a row
Ranges can be cells e.g. Range.Cells(i,j), where i is a row and j is a column.
Ranges can be named. e.g. Range("MyRange"),

In your case, you are trying to convert data from a row to a column. For this,I might consider setting the row dimensions, which can then either be modified in an array, or transposed, or even looped. e.g.

Please Login or Register  to view this content.

Now you can imagine that rngMyRange only contains 1 row of data from column A to Column Z. With this, you can transform it, or you can loop the data so that column A = row 1, column B = row 2, and so forth.

Use a For Next loop... For example:

Please Login or Register  to view this content.

Now this example doesn't put anything in order, and it doesn't take spaces in your rows into account. All you will see here is how the columns were transposed using ranges and loops. You could even loop through each row in the Original and make mulitple columns in the Edits sheet if you wanted.

If you want things in specific places, you will need to be specific in your code about how you do that. But this should give you a good idea to start.

Hope that helps

Journeyman3000, your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)