I have a piece of code that is copying all non blank values from a range in 'column b' in workbook 1 to 'column b' in workbook 2. This works fine.
What i need to be able to do is check values in 'column a' of workbook 1 also. If there is a value "D" in 'column a' of workbook 1, then I dont want the corresponding value in column b of workbook a to be included in the range that I am copying.
Can someone please help?
Please Login or Register to view this content.
Last edited by Knocknaboula; 07-23-2013 at 07:14 AM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you. I am really a novice at all this.
Try this code...
Please Login or Register to view this content.
Thank you very much for your reply. The filter is working fine but it is not copying the data to the second workbook. There are no errors. The second workbook is protected aparted from column B. Is the code you provided copying data from colum A also as this may be a reason why ist is not working?
I got it working. I just reselected the range that i needed before copying. Thank you very much for your solution. I really appreciate it.
ThisWorkbook.Sheets("Final").Activate
Application.CutCopyMode = False
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