Hello everyone,
I'm working on a file which has a table composed by merged rows on Sheet1 and another table with singular cells on Sheet2.
Basically, Sheet1 works as a "source" for Sheet2, which then becomes the true database.
My question is: is it possible to make a macro which recognizes the last product in the merged table and copies it into Sheet2?
I made an example for you on the attached file.
I also made a code which lets you unmerge the rows copied and makes them become part of the database table.
I hope I expressed myself pretty well. On the other hand i'll reformulate my question.
Thank you in advance!
Bookmarks