Hi there,
I am trying to copy and mid(Ax,1,3) cells from sheet1, column A1:A10000 to sheet2, column A1:A10000.
I would also like to do this for mid(Ax,6,11) for sheet2(B1:B10000)
P.S. I say sheet1,A1:A10000 but if possible it could also just go to the end of sheet or until Ax = ""
Many thanks!
It will be good if you explain with the help of a sample file.
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]
In the attached example I have done exactly what I wanted but using the standard excel formula.
I would like to have the same result but using a macro.
Thanks again and please let me know if any further explanation is needed.
You have done text to columns to separate this B01 010297 into 2 separate columns. What about 010911?
that wont be needed in sheet2 so only need exactly whats in sheet2 in the example
There are about 5 spaces in column B in sheet2. Are those required?
no i dont need the spaces.. sorry
Why do you want to do it via a macro? Why not do it manually? You just have to drag the formula down.
the sheets are a lot more complex than the example and the macro would just fit in as a small part of the over all macro.
All you need is this bit of code -
Please Login or Register to view this content.
you my friend are to clever! thanks!
Am glad it worked for you.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
okay ive done that, i have another question could i possibly email you about it?
Why dont you create a new thread?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks