Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to copy contents of one column to another column in another worksheet
should i use VBA to do this?
i need to copy the content of a column in one worksheet to another, if the content in the cell is not empty. and when i add a macro, the sub procedure ask me to pass in object, is it way like this: sub copyAnswer(workbook, worksheet) end sub because the default one is sub copyAnswer() end sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to copy contents of one column to another column in another worksheet
try
Sub copycol() Sheets("sheet1").Columns("a").Copy _ Sheets("sheet2").Columns("a") End Sub -- Don Guillett SalesAid Software "yefei" wrote in message oups.com... should i use VBA to do this? i need to copy the content of a column in one worksheet to another, if the content in the cell is not empty. and when i add a macro, the sub procedure ask me to pass in object, is it way like this: sub copyAnswer(workbook, worksheet) end sub because the default one is sub copyAnswer() end sub |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to copy contents of one column to another column in another worksheet
thsnak very much
another issue how to get rid of part of the text in a cell? for example, if a cell contains "welcome", then i remoce it, and copy the rest content of the cell to somewhere else. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to copy contents of one column to another column in another worksheet
Glad to help. Have a look at help indes for REPLACE and/or SUBSTITUTE
-- Don Guillett SalesAid Software "yefei" wrote in message oups.com... thsnak very much another issue how to get rid of part of the text in a cell? for example, if a cell contains "welcome", then i remoce it, and copy the rest content of the cell to somewhere else. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
how to copy 2350 hyperlink full paths to any column in a worksheet ? | Excel Discussion (Misc queries) |