Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2012, 08:13 PM
gelpena gelpena is offline Illusive Macro Windows Vista Illusive Macro Office 2010 64bit
Novice
Illusive Macro
 
Join Date: Feb 2012
Posts: 2
gelpena is on a distinguished road
Default Illusive Macro

Hello to all,

I have been trying to get a macro working for a while. I must thank MD at VBAexpress for all his help in putting together this piece of code. I need to modify it a little bit for it to do what I want it to do. As of now, data is gathered from Sheet1 and Sheet3 and copied to Sheet2. The problem is that it duplicates the values already copied in the first run of the macro. At this point I'd say all the code is missing is a line to check that the data it's copying is not already in the target sheet. I am totally at a loss when it comes to VBA programming which is the reason why I have not been able to do it. see the worksheet attached. I need your help. . http://www.thecodecage.com/forumz/mi...plication.html






http://www.vbaexpress.com/forum/show...t=40784&page=2
http://www.mrexcel.com/forum/showthread.php?t=610954
Attached Files
File Type: xls ArrangeSample.xls (62.5 KB, 8 views)

Last edited by gelpena; 02-11-2012 at 10:17 AM. Reason: SOLVED
Reply With Quote
  #2  
Old 02-11-2012, 10:05 AM
gelpena gelpena is offline Illusive Macro Windows Vista Illusive Macro Office 2010 64bit
Novice
Illusive Macro
 
Join Date: Feb 2012
Posts: 2
gelpena is on a distinguished road
Default

How do I mark this as solved?

http://www.thecodecage.com/forumz/mi...plication.html
Reply With Quote
  #3  
Old 02-11-2012, 10:09 AM
Matrix's Avatar
Matrix Matrix is offline Illusive Macro Windows 7 32bit Illusive Macro Office 2003
Admin
 
Join Date: Jan 2005
Posts: 429
Matrix is on a distinguished road
Default

https://www.msofficeforums.com/forum...ad-solved.html
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I assign a macro to a button when the macro is in my personal workbook? foolios Excel Programming 2 07-27-2011 02:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft