LinkBack URL
About LinkBacks
Hi,
I've done this in 2007 Excel. But what I need to do in Excel 2003, is to copy certain cells from one spreadsheet to another. until it encounters a blank. I've tried using the "Record a macro", but it stops after the last recorded copy and paste.
Hi,
I've done this in 2007 Excel. But what I need to do in Excel 2003, is to copy certain cells from one spreadsheet to another. until it encounters a blank. I've tried using the "Record a macro", but it stops after the last recorded copy and paste.
You will need to explain some more. What you need to be copied? Where it should be copied?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I have two spreadsheets, one has name, company address, address2, city state zip the other has name, company address, address2, city state zip company address, address2, city state zip company address, address2, city state zip . I have added two rows in the first spread sheet, then I am copying and pasting the the two additional address lines into those two rows. I have tried recording the macro but it stops at my last stop and does not finish. I need for to run until it encounters a blank cell.
Please Login or Register to view this content.
Last edited by arlu1201; 07-16-2012 at 03:01 PM. Reason: Add code tags in future.
It needs to copy certain cells.
Why dont you attach a sample file with dummy data which you are using along with the code?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks