data transposition

[sutton_rich1]

Hi,

i have data in column A (approx 150 rows) that is updated periodically and this data needs to be moved alphabetically to start in row 2, column B and continue across the columns.

eg

Current
a
b
c
d

required
a b c d e

i have a second transposition problem.

i have names in multiple sheets in the same cell and need a macro to search for them and place them into alphabetical order in single column.

i am not very good with VBA so any coding will be appreciated.

 

[Joe4]

i have data in column A (approx 150 rows) that is updated periodically and this data needs to be moved alphabetically to start in row 2, column B and continue across the columns.

Have you tried using Excel's TRANSPOSE functionality?
http://office.microsoft.com/en-us/e...s-to-rows-or-rows-to-columns-HP005203138.aspx

 

[sutton_rich1]

Hi Joe,

i am looking for something that will be able to update automatically as there could be lots of changes.

Rich

 

[Joe4]

When and how are these changes happening?

After the data is transposed the first time, the data will no longer be going down one column but across all the rows.
So what changes will exactly be happening at that point, and how will it change the layout of the data?

 

[sutton_rich1]

The data is in a column on a separate sheet that is updated.

 

[Joe4]

OK, but once you run this code the first time to transpose the data, it is no longer in a column, but now in a row. So how do they updates occur to this now that the structure of the data has changed?