Click on multiple cells from multiple sheets and copy range to new sheet in order

[marcosis123]

Hey,

I have very small knowledge of writing vba from scratch, but am ok editing info to suit my needs so any help would be much appreciated.

I’d like to be able to go through an excel document that has multiple sheets and as I’m clicking cells they are copying a range of cells relating to the click and pasting them in a new sheet, one after the other.

so if I select A3 it will copy A3-C3 to a new sheet and then when I select the next one A50 for example it will copy A50-C50 to the next available row on that new sheet.

it may not always be in column A that I select, but it’ll always be the same range of that row. For example column A,B and C of that selected row.

hope that makes sense and thanks again for any help you can give

cheers

 

[My Aswer Is This]

That works perfectly. Thanks mate.

My next quest is to somehow transfer these via a macro to a word template to fill in the blanks, but i know this is a different issue, so ill do my research first and see if i can find it myself.

Thanks again

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.