Dear Mr/Guru/Rabbi/Prof/Teacher of Excel :
any help about my task to create a macro, i cant use record because exported data is random in size.
after exported to excel id like to :
delete these columns. : A, D, ,E, G I, J,L,M,O,Q,S,U
then back to A1,
i usually press ctrl-down arrow to go to cells contains text, shift-rightarrow, press ctrl-R, then left-arrow then rightarrow then press delete, and then
i press again
i usually press ctrl-down arrow to go to cells contains text, shift-rightarrow, press ctrl-R, then left-arrow then rightarrow then press delete, and then
i press again
i usually press ctrl-down arrow to go to cells contains text, shift-rightarrow, press ctrl-R, then left-arrow then rightarrow then press delete, and then
.
.
.
.(picture attached)
.
.
.
until the end,
so these process id like to make a macro, i cant use record macro, because every exported file is not the same in size. sometimes huge, sometime a little.
Thx
Bookmarks