Help: Convert Row to a Table

  • Hello Everyone,

    I know VBA very basic level and created the below code to convert row data to a table. My code can crate a table currently but it is very slow and not dynamic enough to convert any data to a table. Can you please help?


    1. Mostly Y-axis will be Y.0, Y.2, Y.4, Y.6, Y.8, but from time to time it changes Sometimes it can be Y.00, Y.25, Y.50, Y.75

    2. Mostly raw data starts with Y.0 and continues, but sometimes it can start from another digit such as Y.2 or Y.6, etc.


    Raw data can be over 8000 rows, hence below is not efficient at all, only saving time compared to manually copy-paste values to a table :P


    Thanks for your help.


  • Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post


    All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.


    How to use code tags


    Just highlight all of the code and press the <> in the post menu above button to add the code tags.


    Thanks.