DOC Office

Portfolio

SEPERATE RECORDS

Seperating individual records in a worksheet into individual tabs based on the entry in a specific column can be a time consuming task, that involves lots of boring copying and pasting.

Lucky for you though, We’ve created this simple macro that splits your file into seperate worksheets with the click of a button.

We’ve programmed the attached sample file with the macro code to seperate all records into individual worksheets based on their entry in the column the user chooses, and also to do the reverse – to consolidate all worksheets into one master list.

While this solution might work well enough for a purpose, it’s unlikely that a ‘cookie cutter’ solution will be the perfect fit for anyone. Automating processes for any business requires a unique approach, considering the tasks required, the properties of the source data and the application of the end product. We welcome your call to discuss automation of your current processes with you – we think you’ll be pleasantly surprised by the cost and how quickly you’ll recoup your investment.
 
Download a sample macro that splits your data into seperate worksheets based on the value in the column you choose
 

Leave a Reply

Contact DOC

We welcome the opportunity to discuss your automation project or training needs with you – we think you’ll be pleasantly surprised by the cost and how quickly you’ll recoup your investment.

GET STARTED

To start the ball rolling on your automation project, call us to make an appointment.
We’ll visit you in your office, take a look at your current processes, discuss what you hope to achieve, then document our vision in a formal proposal for you to consider. It’s a risk free / fee free appointment where you have nothing to lose and everything to gain.

To make an enquiry about training your staff, call us to make an appointment.
We’ll visit you in your office, discuss your training requirements and the current expertise of your staff to devise a training package that suits you.

 

CONTACT INFO

Send a Message