splitting data

Hey I was hoping for some help with a little problem I am facing. I have a data set which is roughly 120,000 rows & 26 columns. I need to split these into individual workbooks 1000 rows each copy and paste them into a new excel and save them into a folder on my desktop called product split...

Hi All, I need to create two separate columns (Parent & Child) from a Single column. Can anyone help me on this attached the sample input and output format. Thanks in advance !!

Hi everyone! I have a single cell with contains a concatenated bunch of values. It looks like this Orange-Blue-Green-Pink-Yellow-Green3-Cyan-Majenta-Brown-White-Aqua-Black The concatenate is variable and changes a lot in size so it cant really be hardcoded Im trying to make it trim these words...

Hi Everyone, I am working with the results of a form, and cleaning up the answers. I have ran into a roadblock, and was hoping someone here can help me with this issue. There are 2 fields which have potentially multiple entries and I would like to split those into different rows. for example...

Hi, A thanks in advance to whoever replies I have a question in my project for which participants can select multiple answers. The data was obtained through google forms where the file was exported to csv for example for a question it may have answers like following Respondent 1 -...

Hi all, question about VBA in excel here.. In essence we want to create a VBA code that automatically creates Workbooks for each type of store. As an example: We have one source workbook with the following table: <tbody> Type of store Seller Item Price A Youtube Banana 5,00 B...

Hi I'm trying to spilt data in a worksheet into multiple worksheets or multiple workbooks using rows instead of columns. I haven't been able to find any previous threads that do not relate to columns. Basically I have the following all in one worksheet (called 'Master'): Blank row Header...

Hi all, building a spreadsheet with macros since I will be doing this with hundreds of worksheets over the next year. I am copying and pasting data from a PDF and using the macros to edit out all of the information I don't need. This forum has already been instrumental in getting to where I am...

Hello all, I am very familiar with the "text to columns" feature in excel. I want my data split into columns on what appears to be a return carriage. Delimited wont work do to inconsistent spacing. Here is an example of what the cell data looks like. <tbody> <tbody> Health Insurance...

Hello all, I know that this question has been asked a thousand time before, but I can't find the perfect one for me. I'm looking for a VBA that takes all my rows and separate them into multiple sheets in the same document. Here's exactly what i'm looking for: - something that keeps my...

Hello Everyone, I am having a heck of a time trying to figure out how to solve this problem of mine. I found a couple of similar questions asked, but there weren't any applicable answers. I basically have a five column spreadsheet containing address information. While most cells only contain...

Hello Friends Could you please help me writing code in VBA for splitting data into multiple sheets? The split needs to be based on value in one of the columns and the sheet where the data will be sent to should get sheet name same as value in the column. Following data sample may help me...

Hi there!</SPAN> I have a large amount of data that is all contained in a single worksheet. I am trying to create a macro to separate the data according to name in Column A, then place each block of data with a different name in column A in a separate worksheet in the same workbook. For example...