Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from Column to Column
I need help in copying data from column to column
I going to give an example. Example, Worksheet 1, cell A1= bob, cell A2 = mike, cell A3= jim I want the macro to goto Worksheet 2 and find the first column where the cells a1 through a3 are empty; the cells below a3 may have data in them Then I want the macro to copy the contents of Worksheet1, a1:a3 into the empty cells (A1:A3) in the first selected empty column in Worksheet 2 The next time I use the macro, there is different data in worksheet 1, in cells a1:a3. The macro will then copy these new string values into the next empty column in worksheet 2 I appreciate any help someone can offer Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from Column to Column
This sounds awful familiar - did you post this before.
for each cell in Worksheets("Sheet2").Range("A1:IV1") if application.countA(cell.Resize(3,1)) = 0 then cell.Resize(3,1).Value = Worksheets("Sheet1").Range("A1:A3").Value exit for end if Next -- Regards, Tom Ogilvy mike wrote in message ... I need help in copying data from column to column. I going to give an example. Example, Worksheet 1, cell A1= bob, cell A2 = mike, cell A3= jim. I want the macro to goto Worksheet 2 and find the first column where the cells a1 through a3 are empty; the cells below a3 may have data in them. Then I want the macro to copy the contents of Worksheet1, a1:a3 into the empty cells (A1:A3) in the first selected empty column in Worksheet 2. The next time I use the macro, there is different data in worksheet 1, in cells a1:a3. The macro will then copy these new string values into the next empty column in worksheet 2. I appreciate any help someone can offer. Mike |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from Column to Column
Yes Tom, I had asked for help with this before and could not get the program subroutine to work.
What you sent to me now works perfectly, just wanted to thank you. Could you suggest a reference book that would explain how and why to use such functions as "resize", "destination","xlup" and so forth. My reference manuals do not show these functions. thanks Mike |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from Column to Column
Tom
Thanks for your help. Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy last entry of column to bottom of column | Excel Worksheet Functions | |||
Match Column and copy to cell Column D | Excel Worksheet Functions | |||
how to make one column copy from one sheet to anoth column w/o zer | Excel Discussion (Misc queries) | |||
how to copy contents of one column to another column in another worksheet | Excel Discussion (Misc queries) | |||
To copy values in a column relevant to text in an adjacent column? | Excel Worksheet Functions |