Hello everyone,
My knowledge in VBA is at the beginner's stage, but I managed to create a VBA macro that would prompt the user to browse and select specific excel sheets. Then the macro would select specific cells and copy them into a new workbook/sheet (for example, take cell B:2 and copy it into A2, etc). The problem is that I started noticing that the origin document had new cells added to them, but since I had specific cells selected to be pasted, the macro makes a mess and doesn't copy the number of cells that I need to have transferred.
Essentially, this is what I need:
Capture.JPG
I need the macro to first find the cell labeled "Data 1" and then copy all the green text into the destination sheet as show. Then the do same thing for Data 2 and Data 3. Cells without color should be ignored, and the item column should contain the name of the origin's sheet. The origin sheet can also have up to 50 rows worth of information, so ideally I would like to have the macro run and select only the rows that have information in them while searching through the entire sheet.
Does anyone have a macro that would help me achieve that?
Many thanks in advance!
Bookmarks