RIC63
06-25-2022, 02:13 AM
Morning,
I need to analyze a lot of column -i.e. E12 ÷ AT25- and for each one
if there is only one number then the content of B84 must be copied -by paste special only value- on row 26 of that column
if there is more than one number then the contain of C84 ÷ C86 must be copied -via paste special only value- on row 26 of that column
then after each column that contain more than one number a new one must be inserted and filled with the data present in B64 ÷ B81 allways -via paste special only value-
On sheet 'Result' i show the result of the above steps
I currently use excel 2010 and also 2021
Thanks for any suggestions
I need to analyze a lot of column -i.e. E12 ÷ AT25- and for each one
if there is only one number then the content of B84 must be copied -by paste special only value- on row 26 of that column
if there is more than one number then the contain of C84 ÷ C86 must be copied -via paste special only value- on row 26 of that column
then after each column that contain more than one number a new one must be inserted and filled with the data present in B64 ÷ B81 allways -via paste special only value-
On sheet 'Result' i show the result of the above steps
I currently use excel 2010 and also 2021
Thanks for any suggestions