Copying data into new sheet depending upon selection of rows or columns
Hy. This question may be posted on other forums as well but i am unable to find out my answer. please its urgent.
I want a macro that could
1. Copy my selected rows or columns or cells.
2. makes new file.xlsx
3. pastes that data in that sheet.
THAT'S ALL..............Please urgently waiting for macro
Do you have a sample file that you can upload?
To Attach a File:
1. Click on Go Advanced.
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
i have attached file but there is no macro in it
Should the entire data from sheet1 be copied into the new file? Or only particular rows?
only particular rows. it could be any row and could be any column.Originally Posted by arlu1201
How do you want to select the rows for copying? Is there a particular condition or conditions?
there are no conditions i just want that whenever i select single or multiple rows or columns and then run the macro it just makes another file with selected values pasted in it.
Use this codeCopy the Excel VBA code
Please Login or Register to view this content.
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button
its not workingUse this codeCopy the Excel VBA codePlease Login or Register to view this content.
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button
What do you mean by its not working? Are you getting any error? When you click on debug, is any error showing up?
Are you selecting the text and then running the macro?
its giving me
Compile Error:
Invalid or unqualified reference
Which row is highlighted in yellow?
i got the answer from some other forum. thankx 4 ur help.
Please Login or Register to view this content.
Last edited by arlu1201; 07-13-2012 at 12:22 PM. Reason: Use code tags in future.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks