Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy From 1 File to Another
I have 2 spreadheets PickX.xls and Picklist.xls
Picklist.xls is open and needs to receive data for column A only from PickX.xls. How do I write the code to get all of column A of PickX.xls into column A of Picklist . I want all data whether it is numeric,blank or consisting of characters. I need this code to go just before the for loop that is set up in the Picklist.xls. Private Sub cmdRemoveEndOfData_Click() Dim Rng As Range Dim Rng2 As Range Set Rng = Range("A1", Range("A65536").End(xlUp)) Set Rng2 = Range("K1") For Each c In Rng If Not IsNumeric(c) Then c.Select Selection.Cut Rng2 = Range("K1").Select ActiveSheet.Paste End If Next c MsgBox "Mainframe character has been removed" Range("K1").ClearContents ThisWorkbook.Save Call OpenTemplate ThisWorkbook.Close |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data for match word from one file to another file | Excel Worksheet Functions | |||
How do I copy a excel file into a InDesign file correctly? | Excel Discussion (Misc queries) | |||
copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
How do I copy a file and attach a date to the name of the file | Excel Discussion (Misc queries) | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel |