Hello all,
I am an excel noob who often tends to struggle with it. My latest issue is with copying and pasting multiple groups of text from the same column. The excel file I am referring to is posted here as an attachment and what I am trying to od is c/p the groups of text under the nonrecyclable (column G) for each of the four weeks at the same time. I am holding on to the ctrl key while selecting all these groups of text but when I click copy, I get the error message. I understand I can c/p each group of text one by one but I want to learn a way to c/p all the groups of text at the same time since I need to c/p from many of these types of excel sheets.
If anyone can give me a solution to my problem it would be greatly appreciated! Also I am not too knowledgeable about all of the vba and macro stuff so go easy on me!
Bookmarks