Friends, I am trying to copy a range of cells that encompass two columns and paste it into another workbook.
The range will/could be added to at any given time so the code has to be able to go to the last cell with data. Here is the code I have so far but I cannot get it to work. Any ideas would be helpful!
Please Login or Register to view this content.
There are so many ways to do this, doing it correctly is based on the standard format of the data being examined. Can you provide some exact sample data (desensitized content, of course), so we can see what your data set really looks like?
Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks