Copy from Worksheet
Sponsor
Excel Vba Question:
Im having problem when i want to copy a worksheet using excel vba macro function, having the name of a worksheet in cell A1, I would like to extract
non-contiguous data from the sheet of that name and paste it onto my “Data
temp” sheet. How can I copy the data from worksheet using excel vba function to extract from the named sheet onto the Data Temp sheet?
Excel Vba Answer:
To copy the data from worksheet using excel vba function to extract from the named sheet onto the Data Temp sheet, use this macro:
Sub move_it()
Dim ws As Worksheet
Set ws = Sheets(Range(”A1″).Value)
s = Array(”B1″, “Z1″)
For i = LBound(s) To UBound(s)
ws.Range(s(i)).Copy Sheets(”Data temp”).Range(s(i))
Next
End Sub
Rate This Tips:
(2 votes, average: 5.00 out of 5)
Loading ...Incoming excel search terms
excel vba copy worksheet,vba copy worksheet,copy worksheet vba,mss,excel vba copy sheet,vba excel copy worksheet,excel vba copy range to another worksheet,vba copy entire worksheet,,excel copy worksheet vba,excel vba copy,excel vba copy a worksheet,excel vba copy worksheet to another,excel vba duplicate worksheet,vba copy array to worksheet,vba copy sheet,vba worksheet copy,worksheet copy function,copy sheet vba,copy worksheet in vba,copy worksheets vba,excel copy worksheet,excel vba worksheet copy,excel worksheet copy vba,vba copy excel sheet,vba copy to new worksheet,vba excel copy worksheets,copy columns from one workbook to another using vba,copy data from excel to excel in vba,copy excel worksheet using vba,copy excel worksheet vba,copy from worksheet and paste vba,copy paste worksheet vba,excel copy vba,excel macro copy data specific worksheet,excel macro copy range,excel sheets copy from one sheet to another,excel vb copy worksheet,excel vba clear worksheet,excel vba copy column to new worksheet,excel vba copy data,excel vba copy data array,excel vba copy range to new worksheet,excel vba copy worksheet to another workbook,excel vba exact copy of sheet,excel vba set ws copy,excel vba sheet copy,excel vba sheets copy,excel vba temporary worksheet,macro copy worksheet from one workbook to another
Related Excel Tips
Comments
2 Comments on Copy from Worksheet
-
Pete Ingenhutt on
Wed, 5th Aug 2009 6:42 pm
-
Kari on
Mon, 21st Sep 2009 10:39 pm
I want to have the name in an Excel worksheet cell to automatically become the name on the sheets tab. Is there a formula that will do this automatically?
I just don’t get it:; I have the same question and it has been answered, but I need the answer simplified for someone that needs exact step by step to get it done. I have an excel workbook and I want the information which is just one word that I enter in a cell of the sheet to automatically become the name on the tab at the bottom. Is there an easy explination or example?
Have another excel answer or questions for this problem ?
Feel free to post it here..
Best Excel Tips
- Calling Macro Visual Basic Procedures of a Different Project (5.00 out of 5)
- How to Remove Excel Vba Macro Button (5.00 out of 5)
- Remove Hyperlinks in Excel (5.00 out of 5)
- Delete Worksheet (5.00 out of 5)
- Copy from Worksheet (5.00 out of 5)
- How to Calculate 6 Working Days Between Two Dates (5.00 out of 5)
- Unprotect Worksheet Password (5.00 out of 5)
- Calling Macro Visual Basic Procedures of a Different Project
