I'm trying to put this together but I have no idea what I'm doing really.... I have my try hard pants on and everything..
Once the tname is found and copied, then open the other workbook and find the next blank cell and paste. Go back to HCU2 All tags update.csv and find the next tname over and over through C:C.
Please Login or Register to view this content.
Last edited by Tortus; 10-02-2013 at 02:40 PM. Reason: Solved baby
Assuming that both workbooks are already open (the macro doesn't have to open the second workbook), are both workbooks open in the same instance of excel?
What version of windows and excel are you using?
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."
2007 and yep, both workbooks would be open. I could use this code again by changing the workbook names within the VB or at least thats what I'm thinking i could possible do.
You can try:
Regards,Please Login or Register to view this content.
tt3
OrPlease Login or Register to view this content.
e/ Do you need this to be adjusted to work with any workbooks?
Last edited by Solus Rankin; 09-30-2013 at 01:14 PM. Reason: another question
The second code was exactly what I needed thank you so much! The next part would be to go the other way. If I change a value in Workingbook.xlsx - how could I keep the consistency writing the new value back to the active workbook? What I plan on doing is coping your code for many different things and have it paste in Workingbook.xlsx. Then change the value (text) and copy/paste back to the active workbook. Problem is how can I make the new value land in the active workbook in exactly the same place it came from?
I think you might benefit from creating a personal.xlsb, storing your macro here. These open up (hidden) every time you run Excel and allow to run the macros stored there on the active workbook (whichever workbook you have displayed on the screen at the time). It would be fairly easy to "bookmark" the cell the value was taken from so that you can return values here when you're done editing.
Ok, I'll look into bookmarking cell's. One other question, in your code how can I add more conditions?Does this make sense what I'm asking? lolPlease Login or Register to view this content.
Yes you can, but remember that tname is just the range the macro is looping through, its not the active cell. So you might want:
Please Login or Register to view this content.
Could you do please write an example of defining something like tname and dname in one code?
LikePlease!Please Login or Register to view this content.
Such as:orPlease Login or Register to view this content.
Please Login or Register to view this content.
Sorry.. I'm real slow and this doesn't work like i thoughtPlease Login or Register to view this content.
Is there any reason to loop twice or can you check both of them at the same time like this?Please Login or Register to view this content.
Got your PM and there was something going on with my connection. I couldn't access the forum page until today. Thank you for your help. I can play around with what you have provided and I'll post again if I have questions. This forum has helped me greatly.. wouldn't know what I would do without it
Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks