splitting

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...

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

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...

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!

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...

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...

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'...

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...

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...

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...

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...

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...

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?

<!--[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...

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...

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

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"...

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...

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" &...

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 :)