Posts by siayaa

    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.