1. A

    Splitting a master data set into a different workbook

    Hi all I have a need to split a master data set into different tabs on a separate workbook. This has come about because I can't let the end user have access to the Master set as they have deleted it several times! :) Essentially, this is a very small sample of my master data set: ID Company...
  2. R

    Splitting a table

    Hello, I have a huge table (about 200.000 rows). Now I want to split this huge table into, say, four minor tables A, B, C, and D. How can I achieve that by using VBA Code? Thanks for your help. Saludos Ralf
  3. J

    Logistics Consolidation Problem

    I need to find a way in excel to show me the lowest amount shipments it would take to send out all of these orders, without splitting individual orders, by adding together rows that could fit under the volume threshold of 3400. Any help would be appreciated. https://imgur.com/a/X8AXTZO image is...
  4. M

    Splitting a number in a cell into 2 smaller numbers

    Hi all , in cell B56 i have 13,857 which is a sum of B2:B53 and im looking to split this down into 10,000 into cell B58 then the remainder into cell B59 . Any ideas on what function i would use to do this? Thanks!
  5. S

    Splitting data in cells w/VBA macro

    Curious to know if there is a way to take data from one table and reorder the data into into another table. My project is creating tables of soil sample data collected for environmental cleanup. First table is output from another VBA routine. NOTE: the "GP-1" is the location of a soil...
  6. T

    Rename a closed workbook without opening it

    Hi Friends, I am using powershell code for splitting a CSV file because it is faster than VBA on CSVs. I am splitting the file based on one specific column. So, if any values are blank in this column , powershell is generating file named .csv. My question is can we rename this .csv file to...
  7. D

    Automatically Splitting Rows into Different Worksheets - Run-time error '1004' PasteSpecial method of Range class failed.

    Hi folks, I have been tasked with splitting a master worksheet into multiple worksheets i.e., splitting the data by values in a selected column. For instance: if the selected column contained different values for 'sales person', the task would be to split sales data for each 'sales person'...
  8. T

    Splitting rows in a table based on date fields.

    Hey, I have a list of bookings that have a start & end date and a amount. I need to split the table so that each month has it's own line and % amount For example before it would look like this. <tbody> Booking Start Date End Date Booking 1 01/08/2017 30/11/2017 Booking 1 01/10/2017...
  9. M

    Splitting names from one to two columns: what do others do in this situation?

    Hi all, I am tidying a spreadsheet in preparation for import into a CRM. All names are in one column. In the past I have had good success with the Text to Columns function for splitting first and last names into separate cells. Most colums are uniform, like John Smith so the function works...
  10. F

    Splitting Files - Performance and Limitations

    Hi Folks, I have created a macro splitting a block of data into many excels. It works for active sheet and as a criteria it uses a selected cell. Macro itself works fine, however I am encountering some problems with performance and object methods. The error occurs every time I reach ~105...
  11. M

    Splitting an Address equally in 2 columns

    Hi Everyone, First time poster, hope I am following all the rules. My dilemma right now is: I have an excel with around 3000 office addresses all in a single column, I need to split this in two (i:e, Address becomes, Address 1 and Address 2) For EG: <tbody> Address Address 1 Address 2...
  12. S

    Split sheet into multiple protected workbooks and save?

    Hi. As an intermediate VBA writer - if someone could please help me with and potentially give comments on the code. I have a sheet, with 70,000+ employees. The main manager's name for several thousand is in column AF and I want every unique name/value to have a seperate workbook created, with...
  13. T

    Splitting Data

    I have cells which contain date and time (29/02/2012 11:12:40) I need the date to remain and the time to be removed and placed in an adjacent cell Anyone know of a quick method to do this?
  14. M

    Splitting Cells Into Rows,Commas, Preserve uique ID

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> So I have a large data set with numerous zip codes per cell and I need to split the cells into individual rows but preserve the organization each zip codes comes from. The...
  15. D

    Splitting Column into 2 Columns part 2

    Hi guys. I've been trying to split a column into 2 columns for about a week. I've played with a couple of macro's I've found on the net but have yet to meet with success. I have 2 columns like this: 12 chevys 14 fords 8 toyotas 5 nissans The data starts in row A7 for numbers and row B7 for...
  16. J

    Easy Macro? Split Existing Document into seperate files, no more than 50 rows each, keep 1st column info

    Theoretically this should be easy right? I have a file with 300 names. It looks something like this (Except MUCH longer): Excel...
  17. W

    Splitting a single rows data into multiple rows

    Hi, I'm relatively new to the excel world and I'm stuck! A solution in either excel or access would be greatly appreciated and save me a lot of useless copy/paste. Here's what the problem looks like right now: -- removed inline image --- <table border="0" cellpadding="0" cellspacing="0"...
  18. I

    Date Time formula problem

    3 million lines that are formatted the same in text. I need to get them into a DB and i am trying to use excel. I have a single column that has 3 different date time formats. Format 1 is Date.Time = (01/02/11.13:52:12). Format 2 is Time = (16:31:17). Format 3 is just a dash (-). i need to get...
  19. A

    splitting data into multiple sheet

    I am new to macros. I have a requirement where i need the data to be splitted to multiple sheet. I have used the below code: Sub SplitData() mycount = 0 myrow = 0 Do mycount = mycount + 1 oldrow = myrow + 1 Sheets("Master").Select Do myrow = myrow + 1 Loop Until Sheets("Master").Range("A" &...
  20. J

    Desperately Need assistance!! Splitting data into intervals

    Hey there! So I have some daily stock returns over about 8 trading years and need to split them up into 60 day intervals....how do I do this? THANKS FOR HELPING :)

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back