VBA code to copy a range of data based on conditions
I have multiple tables one below the other with headings Department(Column A),Item(Column B),Sales(Column C), Effective date(Column D)
one table could have 10 lines followed by another table with 25 lines
Heading
. Data
.Data
.
Heading
.Data
.Data
.Data
.Data
I want ot use a VBA code to copy the first table to the next tab for first iteration ,second table to the next tab for the 2nd iteration and so on
Thank You so much in advance
Bookmarks