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,excel vba copy worksheet to another,mss,vba copy sheet,copy columns from one workbook to another using vba,excel macro copy data specific worksheet,excel macro copy range,excel sheets copy from one sheet to another,excel vba clear worksheet,excel vba copy sheet,excel vba sheets copy,excel worksheet copy vba,ms excel vba to copy sheet from named worksheet,vba copy cells worksheet,vba copy excel sheet,vba copy spreadsheet,vba copy worksheet,vba copying cells into array,vba excel worksheet copy,active worksheet vba,cell worksheet cells copy vba,clear worksheet excel vba,clear worksheet vba,clearing cells in excel worksheet visual basic,copy a worksheet in excel vba,copy a worksheet in vba,copy an exact copy of a sheet to another workbook in vba excel,copy and paste cells based on specific criteria in visual basic,copy array from one worksheet to another,copy array vba excel sheets,copy cell formula using excel vba,copy cells in one worksheet paste into another worksheet excel vba,copy collection sheets vba,copy column from one worksheet to another vba,copy comments from worksheet to worksheet vba,copy comments in excel,copy data from 1 spreadsheet to another in vba,copy data from 1 worksheet to another using vb,copy data from excel to excel,copy data from excel to excel using vba,copy data from one workbook to another in excel using vba,copy data from one workbook to another vba,copy data from other sheets vba excel,copy data from temp worksheet to another,copy data into a new sheet excel vba,copy data text to sheet excel,copy data to email using vba,copy divide worksheets,copy excel data into array vba,copy excel range using vba
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)
- Copy from Worksheet (5.00 out of 5)
- Change Worksheet Tab Colors (5.00 out of 5)
- Delete Worksheet (5.00 out of 5)
- Quick Way Determine The First and Last Business Day of the Month (5.00 out of 5)
- How to Calculate 6 Working Days Between Two Dates (5.00 out of 5)
- Date Calculation Start Date Minus Year, Month and Days (5.00 out of 5)
- Calling Macro Visual Basic Procedures of a Different Project
