split data for multiple digits & letters , symbols into sheet based on another
hi
I want to split data into sheet master based on sheet main . there are many different digits & letters , symbols . so it should split column B into multiple columns B,C,D in sheet master based on sheet main . I put the expected result from column E: G . always I have structure of data like in sheet MAIN and the real data about 700 rows .
sorry if the detailes are poor , just tell me if anybody interest .
Re: split data for multiple digits & letters , symbols into sheet based on another
VBA or formula?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").
It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.
- Follow this link to learn how to install Power Query in Excel 2010 / 2013.
- Follow this link for an introduction to Power Query functionality.
- Follow this link for a video which demonstrates how to use Power Query code provided.
Re: split data for multiple digits & letters , symbols into sheet based on another
PHP Code:
Option Explicit Sub test() Dim i&, cell As Range With Sheets("Master") For i = 2 To Sheets("Master").Cells(Rows.Count, "B").End(xlUp).Row For Each cell In Sheets("Main").Range("B2:B" & Sheets("Main").Cells(Rows.Count, "B").End(xlUp).Row) If Replace(cell & cell.Offset(, 1) & cell.Offset(, 2), " ", "") Like Replace(.Cells(i, "B"), " ", "") Then .Cells(i, "B").Value = cell.Value .Cells(i, "C").Value = cell.Offset(, 1).Value .Cells(i, "D").Value = cell.Offset(, 2).Value End If Next Next End With End Sub
Re: split data for multiple digits & letters , symbols into sheet based on another
What you mean run repeatedly...
As per your request...The code takes your existing data and splits it into 3 columns...So there is no more original data...
Have no idea why you refer to Main Sheet all the time as this is the exact result you require in Master Sheet
Currently Master Sheet has the exact same data as Main Sheet...Only the 3 columns is combined into 1 column...
Or am I missing something...
Perhaps you should explain your requirement in more detail...
Re: split data for multiple digits & letters , symbols into sheet based on another
What you mean run repeatedly...
that meant I will add new data in sheet main then should macro run normally every time add new data without error , but it seems the code work just one time . it doesn't work for a new data after has already run the macro .
Re: split data for multiple digits & letters , symbols into sheet based on another
Gonna go around in circles all day long if we do not get a clearer explanation...
I think all of us have the same understanding...Which is not OP understanding...
Re: split data for multiple digits & letters , symbols into sheet based on another
What does this mean...What is it you actually wanted to achieve...You have not answered any of my previous posts...I still am confused...
every thing is ok based on OP just what I meant somtimes run the macro repeatedly inaccedintly then it will shows the rror because the data have already splited ,then macro can't split data are divided again . what I looked for to avoid the error when run the macro repeatedly .
Re: split data for multiple digits & letters , symbols into sheet based on another
Originally Posted by Alaa-A
what I meant somtimes run the macro repeatedly inaccedintly then it will shows the rror because the data have already splited ,then macro can't split data are divided again . what I looked for to avoid the error when run the macro repeatedly .
Bookmarks