Task:A user has to copy and paste a range of cells, if any row in column B has "PM" as a value.
I have several macros/VBS scripts that copy and paste from one workbook to another, how do I create a macro that says whatever row "PM" is in copy range F:BC on that row
My issues is the fact the PM can be in any row in column B in different sheets. Example.xlsx
Your discription says column B but your example shows PM in column C. Which one is it?
Where do these values need to be pasted?
Do all sheets need to be searched at the same time?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Solus,
Thank You for taking the time to respond. The value PM will aways be in column B, sorry for the error, in my example I added the sheet column to indicate that there would be different sheets and the value would be in differents rows.
The sheet are done individually and they will be pasted into another workbook starting at column F Row 2.
Maybe:
Please Login or Register to view this content.
Please Login or Register to view this content.
Souls and John Thank You very much for your help I will try both suggestions and let you know how it works.
Souls and John I have tried both of your suggestions, but I am not able get a result, the macro run with out an error, but it does not do what I need done either. Thank You both for your help
Thank you both for your help I have modified the code but now it fails at the paste section
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks