Hello,
please help me to edit my code i need to copy 10 digits of number in column W
I've also attached my file.Please Login or Register to view this content.
THanks
Hello,
please help me to edit my code i need to copy 10 digits of number in column W
I've also attached my file.Please Login or Register to view this content.
THanks
Last edited by 6StringJazzer; 10-28-2016 at 02:09 PM. Reason: code tags to preserve spacing of data
withdrawn.........
Last edited by protonLeah; 10-28-2016 at 08:38 PM.
Ben Van Johnson
Hello ash3angel,
According to your required sample data, how is the system to know when you want ten numbers from the left, or from the right, or even maybe somewhere in between?
For Example: 5688308884 are numbers from the left of 56883088845688308885
and then : 5688308885 are numbers to the right of 56883088845688308885
This will not be possible.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
I have attached the macro file, the only thing i am missing is when i copy the first 10 digit and paste it in column W then it will copy again the 2nd 10 digits and when copying the 2nd row data it won't copy it anymore because it will not do the loop because its blank or when trying to change it i will skip or will just continue to loop
Does this help?
Please Login or Register to view this content.
In Column w:
=LEFT(TEXT(X1,"0"),10)
Hi John,
It's not copying the data in Column X
When I tested it on your sample, it copied it? Also, I admit some of your data is off. Although I assumed that each cell could be divided evenly by ten, when I run a Len(cell) for the X Column I'm getting some cells with an extra character (ie 21, 32 ect.). This throws the macro off. However, when you do a visual character count I get (20, 30 ect.)
Opps my fault, i copied the code in wrong sheets.
Its perfect the only thing left is which i forgot to quote the finish product should looks like this
column V column w
1 10 digits
10 digits
2 10 digits
3 10 digits
4 10 digits
10 digits
for every 10 digits in a row should be across in column v
Can you provide a sample with how it would look before and after?
Capture.PNG
the outcome should looks like
Try:
Please Login or Register to view this content.
its good, however i need to have space for every invoice
sample - lets pretend the 1 digit is equal to 10
starting row should remain and only leave space for every 10 digit numbers or copy to the next same with 2nd starting row first 10 digit across the 2nd starting row then it will insert a row then paste the other 10 digits
invoice 1 - 1
_________2
invoice 2 - 1
invoice 3 - 1
________2
________3
invoice4 1
_________2
Not sure I follow you? That's the reason for the result sheet.
Please Login or Register to view this content.
I have attached the result and raw - hope this will help
THanks
This places the results from Columns "D" and "E" into "A" and "B". Per your sample Results.
Please Login or Register to view this content.
Try
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks