I need to copy the text from shapes within some ranges of a sheet in excel and paste in other ranges.
There are 9 ranges that will be filled with shapes and 9 ranges to copy the text from those shapes
The macro should search for each shapes within each range and copy to a specified range.
The shapes will be copied from "Canvas" sheet to "Plan" sheet.
Please be sure to understand this:
Each post-it placed on range R3 to U21 or Clients represent a type and each type is defined by the color of post-it in the other ranges.
The type of each post-it text should appear on column C of the ranges of sheet "Plan".
I created a sheet named "For macro creation" giving the ranges and I'm attaching two files (one in blank and one as it should appear).
In the excel attached we already have post-its placed but we should have the possibility create one only drag and drop the four types on right site to the ranges and the macro should work.
All informations are already here. Please read carefully.