Expansion

Copper Contributor

How could one expand a section of data without affecting the below cells by pulling in from another tab via a paste or just entered?  To grow without inserting spaces or leaving extra space and delete in future.

Example - On Tab 1 there could be 3 cells or maybe 50 that I need to get into Tab 2.  On Tab 2 I need each of those in column B to go sequential with the "A".  However if I have 50 I need the A's to grow down 50 and then the same with B,C...etc.

Tab 1                            Or

1                                   1

2                                   2

3                                   3

                                     4

                                     5

Tab 2

A   1                           A   1

A   2                           A   2

A   3                           A   3

B   1                           A   4

B   2                           A   5

B   3                           B   1

C   1                           B   2

C   2                           B   3

C   3                           B   4

                                  B   5

                                  C   1

                                  C   2

                                  C   3

                                  C   4

                                  C   5

1 Reply

@wtw346 Take a look at the attached file.

 

It has a named range called "RowsInSheet1" that counts the number of rows in Sheet1. The formula in cell A1 in Sheet2 is copied down 1000 rows. The indicator in cell C2 tells you where the last row of the data is.