Is there a way with VB that I can have rows from one workbook copy into another workbook as long as there is text in a certain column?
For instance, I want a list of contacts to be copied over into a separate workbook only if the contacts have an email address listed. If they do not have an email address, I dont want them copied over.
Hi tharnden
Welcome to the Forum!!!
I'd suggest Filtering on the Email Column to exclude Blank...Copy/Paste the Visible Cells...yes, it can be done in VB...
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
That is how I have been doing it. I was hoping that if I used VB, as I updated the accounts in the first workbook, that the second workbook would update with the corrected information automatically. Am I correct?
Hi tharnden
You'd need to develop some "Change Event" Code in the first workbook that finds the changed record in the second workbook and updates it...yes, it's do-able...
I am clueless when it comes to VB. Any Ideas?
never mind. I think i am just going to make it a point to always copy and paste from the first workbook into the second just so I always make sure I have the updated information
Hi tharnden
Sure...you'll need to attach your Files (both Workbooks), explain what it is you're doing and why, if appropriate, so I understand your mission.Any Ideas?
The below is a Canned Reply...hopefully you'll get the message...I need to see what you have and where you wish to be...
Please attach a sample workbook(s) the Structure of which is the same as your actual workbook(s).
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
INCLUDE ANY CODE YOU'RE USING OR HAVE TRIED.
Remember to desensitize the data.
To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
OK...change your mind let me know...
Originally Posted by tharnden
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks