I need to modify the below piece of code to:
1. Select values from rows in Sheet1 where columns C through G sum <> 0
2. Add the suffix "_xyz" to values in ColA
I have attached a workbook. The values I need to see are on Sheet2.
Please Login or Register to view this content.
Thank you to this community for helping an Excel newbie.
MTT
I might be missing something but I can't see an attached workbook.
In the absence of the workbook, this slight amendment is untested:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I neglected to attach it. Here it is. When I ran the code I got a compile error on this line:
Please Login or Register to view this content.
Delete the asterisks (*) at the beginning and end of the line of code ... I think they must have come from the highlighting.
Please note that in the Title of the thread, you say "Adding a prefix to to copied values" and in the post itself, you say "Add the suffix "_xyz" to values in ColA"
I initially edited the code to add a prefix (which is what you have implemented) and then I edited it to add a suffix. Not sure which you want.
Without the asterisks, it appears to work.
Regards, TMS
hi MTT, option
PS. The result you provided has some dicrepancies with your requirements. The code provides result as per requirements sheet.Please Login or Register to view this content.
You're welcome. Thanks for the rep.
watersev,
That is fantastic. Thank you very much!
MTT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks