How to get the first row in the same sheet

Hi all

i m trying get all first row of the table the problem is all the tables are in the same sheet does any one know to first row only after the table header and build another table by this .

Thank you

in general we qould do following (Assumption 3 col structure is fixed)

  • find index of month Col with value month (Tablestart)
  • find next index of month col with empty value (Table end)

with this index information we can slice / extract the data

Also have a look here:

1 Like

hi @ppr
okey Thanks got an idea :grinning:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.