Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pls. Help: Need Macro for Copy and Paste
Hi Guys, Can anyone help me with making a macro to copy and paste a cell. Here’s the sample data A B C D 1 Code1 Tom Jones 2 deny 3 credit 4 Code2 Jim Tyles 5 good 6 Code3 Sam King 7 bad credit I need the macro to look into column A and look for blank cells. I there’s a blank cell, it needs to copy the row starting with A to K an paste it column L or in the row before that blank cell and if there another blank cell after the first one, it needs to copy and paste i column W and then loops again till it finds another blank cell. It needs to look like this: A B C D L W 1 Code1 Tom Jones deny credit 2 deny 3 credit 4 Code2 Jim Tyles good 5 good 6 Code3 Sam King bad credit 7 bad credit Hope you can help guys, this is just part of what I need to do with raw data. I just made a macro to reformat the sheet. And, this kin of macro is too complex for me :( Thanks in advanc -- japorm ----------------------------------------------------------------------- japorms's Profile: http://www.excelforum.com/member.php...nfo&userid=654 View this thread: http://www.excelforum.com/showthread.php?threadid=56246 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pls. Help: Need Macro for Copy and Paste
Have a look at http://www.rondebruin.nl/tips.htm : -- s80N ----------------------------------------------------------------------- s80NL's Profile: http://www.excelforum.com/member.php...fo&userid=3637 View this thread: http://www.excelforum.com/showthread.php?threadid=56246 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pls. Help: Need Macro for Copy and Paste
Thanks for the reply but it doesnt work. To make it short, the desription is in always after the first row if ever there is a description and the desription always start in column B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
Macro to Copy/Paste then Paste to Next Line | Excel Programming | |||
Copy and Paste Macro Help please.... | Excel Programming |