6 Replies Latest reply: Apr 23, 2014 12:16 AM by Akhila de Costa RSS

    extract multiple tables from a single sheet

      i get monthly reports from the security departments where there are a few tables in the sheet. the column names are consistent but the amount of data are not.

      but the thing about the tables is that it can start anywhere and i cannot define a cell... i know how to get data when they are laid horizontally using textbetween, right, left etc but is there anyway to get the data the same way when they are arranged horizontally.

       

      ive attached a sheet of sample data

       

       

      thank you in advance

      Akhila de Costa