This may not be complicated but after i read some of the forums, i have not found a solution. My problem is i have all my information on one sheet. My sheet has 3 columns of data, on column A it specifies a table (table 2, 3, 4, 5, etc...). Each Table has data below. What i am looking for is for each table and the data below the table to be in a different sheet. So if i have 20 tables, i will have 20 sheets. Would really appreciate the help?!!!