Hi All,
I'm not good with Excel and this is my first thread so please be forgiving for me .
I have got excel (version 2016) file with table filled by external application and results in table are like 3#Music (id#category). I have to do template which will show formatted data. In same file i want to make copy of that table or range but with formatted data without prefix id# or formated original table like that. I don't know number of rows (number of columns is always same). Second problem is the table is between other datas and i'm wondering is it possible to represent formatted data from table in some way that will take always same number of rows in sheet (sheet is a form to print).
Regards.
Bookmarks