I am trying to make it so that the data i type into the row of one workbook will be transposed into the column of a second workbook. This data is entered daily and I get tired of having to type the same thing into different workbooks. Here is an example:
Workbook one:
Putaways: 26 78 95 45 65 32
I would like those number to be put into workbook two into a column.
Workbook two:
Putaways:
26
78
95
45
65
32
I could not find any formulas that would do this.
Thanks for your help.
Workbook one:
Putaways: 26 78 95 45 65 32
I would like those number to be put into workbook two into a column.
Workbook two:
Putaways:
26
78
95
45
65
32
I could not find any formulas that would do this.
Thanks for your help.